Microsoft's documentation for the connector lists Excel among the products that have it, and describes the steps: select the PDF option, "Browse for and select the PDF file you want to load", then "In Navigator, select the file information you want, then either select Load to load the data or Transform Data to continue transforming the data in Power Query Editor." The function behind it "Returns any tables found in a PDF file", and by default "similar tables on consecutive pages will be automatically combined into a single table" ([*Power Query PDF connector*, Microsoft Learn](https://learn.microsoft.com/en-us/power-query/connectors/pdf), read 20 October 2026). In Excel, the PDF option sits among the data sources you can import from; Microsoft's page names the connector, not the exact menu, so look for it under the Data tab's Get Data commands.
Microsoft is frank that results need tidying: "In cases where multi-line rows aren't properly identified, you might be able to clean up the data using UI operations or custom M code" (the same page). Rows whose text wraps onto two lines are the usual casualty, so check those first.
## Acrobat: convert the PDF to a workbookAdobe's steps: "Select Convert from the global bar", "Select Microsoft Excel from the left pane and then select XLSX", then "Select Convert to XLSX" and save. Under Settings you can choose to "create a worksheet for each table, page or the entire document", set decimal and thousands separators, and use "Text Recognition Settings: Recognize text images if needed and set the language" ([*Convert PDFs to Microsoft Excel formats*, Adobe Acrobat Help](https://helpx.adobe.com/acrobat/desktop/save-export-documents/convert-to-other-formats/pdf-to-excel.html), read 20 October 2026). That last setting matters for scanned PDFs.
## On a phone: Data from PictureMicrosoft's phone steps: "Open Excel on your phone or tablet and tap Insert > Data from Picture", frame the data "until you see it surrounded by a red border", and capture. Excel then flags anything it was unsure of: "Tap Ignore to move on to the next issue or tap Edit to correct the issue", and "Press Insert when you're done". The Microsoft 365 app does the same through Actions, then Image to Table ([*Insert data from picture*, Microsoft Support](https://support.microsoft.com/en-us/excel/insert-data-from-picture), read 20 October 2026). For a PDF on your phone, our suggestion is to show the table full-screen and capture it with Excel's camera, or screenshot it if your version offers a picture-file option. Two limits from the same page: the image should be "head-on and focused", and "Only the following character sets are supported", a list of English and twenty other languages, mostly European.
## Scanned PDFsIf the table is in a scan, there is no text for the PDF connector to read. Microsoft's connector page does not mention scanned files either way (the *Power Query PDF connector* page, read 20 October 2026), so treat a scan as needing a text layer first; [making a scanned PDF searchable](https://docfindapp.com/answers/make-a-scanned-pdf-searchable) covers that, and [checking for a text layer](https://docfindapp.com/answers/does-my-pdf-have-a-text-layer) takes a few seconds. Acrobat's text-recognition setting and Excel's Data from Picture both work from the image instead.
## Before you trust the numbersOur checklist, whichever route you use: