How to Convert a PDF to Excel

If you are on Excel for Windows, you may not need a converter at all: Data > Get Data > From File > From PDF pulls the tables out of a PDF and loads them into a sheet. If that option is missing, or you are on a Mac, in a browser, or starting from a scan, there are several other routes that work. Here is how to choose one, and how to clean up the mess each of them can leave.

Import a PDF straight into Excel for Windows#

Microsoft’s documented path is exact. Open a workbook, go to Data > Get Data > From File > From PDF, choose the file, and select Open. As Microsoft’s Power Query guide puts it, “The Navigator dialog box opens your PDF and displays available tables.” Alongside the tables it detected, Navigator generally lists whole pages of the document too, with a preview so you can check a candidate before you commit to it. Look down the list: where one table runs across a page break, you can often import the pages separately and stack them with Append.

Navigator has two exits. “To view the data directly in Excel, Select Load > Load,” which drops the selection into a sheet as it stands, while Load > Load To opens the Import dialog if you want to say where it lands. Or, “To work with the data in Power Query first, select Transform Data.” Transform Data is the better default whenever the preview looks ragged: promote the first row to headers, delete the junk rows above and below the table, set each column’s data type, then Close & Load. Those steps come from Microsoft’s page on importing data with Power Query.

The ribbon button reads Get Data in desktop Excel, though some surfaces label it Get Data (Power Query), so look for the wording rather than a fixed button. And if From PDF simply is not listed under Data > Get Data > From File, your Excel build does not include the connector. Use one of the other methods below.

Microsoft does document one requirement: “The PDF connector requires .NET Framework 4.5 or higher to be installed on your computer.” On a current machine that is already satisfied. Microsoft’s version table shows .NET Framework 4.8 installed by default on Windows 11 (version 22000) and on Windows 10 version 1903 and later, and 4.8.1 on Windows 11 versions 22621, 22631, 26100 and 26200. Treat the .NET message as an error you might see, not as the likely explanation for a missing menu item.

Two platform limits are worth knowing before you go hunting. Microsoft’s list of Power Query sources for Excel for Microsoft 365 for Mac runs to Text/CSV, Excel workbook, XML, JSON, SharePoint Folder, SQL Server and a handful more. PDF is not one of them. Excel for the web is the same story: its documented sources are Excel workbook, Text/CSV, XML, JSON, SQL Server database, SharePoint Online list, OData, Blank table and Blank query, with no PDF among them.

Working from a folder of monthly statements rather than one file? Microsoft’s advice is not to run the PDF connector over and over but to “use a multi-file connector such as the Folder connector or SharePoint Folder connector,” then combine the results.

Which method fits your setup#

Method	What you need	Handles scans?	The catch
Data > Get Data > From File > From PDF	Excel for Windows, with the connector in your build	No	Not offered in Excel for Mac or Excel for the web
Copy-paste, then Data > Text to Columns	Any Excel and any PDF reader	No	Dates and leading zeros get mangled on the way in
Acrobat: Export a PDF, then Microsoft Excel Workbook	A paid Acrobat subscription	Yes, Adobe runs OCR	Free Acrobat Reader cannot export to Excel
Tabula	Free download; Java on Windows and Linux	No, text-based PDFs only	You draw the box around each table yourself
Excel Data from Picture	Windows 11, or Windows 10 1903+ with WebView2	Yes, it reads an image	Crop to the table only; limited character sets

The Acrobat route is short: open the PDF, use the Export a PDF tool (older builds put an Export PDF tool in a side pane), choose spreadsheet and then Microsoft Excel Workbook, select Export, and save. Adobe says text recognition runs on its own where it is needed: “Just scan to PDF and convert to Excel. The Acrobat PDF converter automatically extracts and formats the data into editable text thanks to optical character recognition (OCR).” Exporting to Excel is a paid Acrobat feature, so the free Reader will not do it. Adobe also runs a browser converter that outputs XLSX and states that “Your file will be securely handled by Adobe servers and deleted unless you sign in to save it.” That page publishes no free-usage number, so do not count on a particular allowance.

Tabula is the honest free answer for a Mac, an older perpetual Excel, or a PC with no subscription. Its site says “Tabula will always be free and open source,” it runs on Mac, Windows and Linux (Java is required on Windows and Linux), and it exports CSV, Microsoft Excel spreadsheets and JSON. It also states its own limit plainly: “Tabula only works on text-based PDFs, not scanned documents.”

When the table is only a picture#

A scanned page is a photograph of a table, not a table, so there is no text layer for Excel’s importer to read. If Acrobat is not an option, Microsoft’s answer is Data from Picture. On Windows the path is Data > From Picture > Picture From File or Picture From Clipboard, which needs “Windows 11 or Windows 10 version >=1903 (must have Microsoft Edge WebView2 Runtime installed)”. On the web and on macOS it is Data > Data From Picture. Microsoft also documents Insert > Data from picture on phones and tablets, and Actions > Image to Table in the Microsoft 365 app, though mobile menus move as those apps get consolidated, so treat those as what the documentation says rather than a promise about your handset.

Crop before you import. Microsoft’s requirements are that the shot be head-on and in focus and that “The image should only depict the data you want to import.” Character-set support is limited to a fixed set Microsoft names on that page: English plus a run of European languages from Bosnian through to Turkish.

Google Drive’s OCR is the weakest option here. Right-click the PDF in Drive, choose Open with > Google Docs, and Google runs text recognition, but its published limits are unforgiving for tables: the file must be 2 MB or smaller, the text at least 10 pixels high, the page right-side up, and Google says lists, tables, columns, footnotes and endnotes are not reliably detected. Google Sheets has no PDF import of its own. When you want the words rather than the grid, pulling text out of a PDF with an AI tool beats fighting Drive.

Copy, paste, and the date trap#

For one small table, selecting it in a PDF reader and pasting into Excel is fine. It usually lands as a single column of text, and the repair is Data > Text to Columns: choose Delimited and tick the separators the data actually uses, typically comma and space, or Fixed width for a report that lines up in monospaced columns. Then set a Destination and select Finish.

Do one thing before you paste. Part numbers, measurements and anything shaped like 3/4 or 1-5 get converted to dates on entry, and Microsoft is blunt about it: “Unfortunately there is no way to turn this off.” The documented workarounds are to format the destination cells as Text first, or to type an apostrophe ahead of the value. Microsoft recommends the apostrophe over a leading space if you plan to run lookups, because functions like MATCH and VLOOKUP overlook the apostrophe when calculating results. If the file asks for a password before it will open, deal with that first, as in our guide to removing a password from a PDF. And for a mostly-text PDF, opening it in Word and copying the resulting table across is a workable last resort, with the caveats covered in converting a PDF to Word.

When the import comes out wrong#

Symptom	Cause	Fix
No From PDF option	Your Excel build lacks the connector, or you are on Mac or the web	Use Tabula or Adobe’s converter instead
Navigator finds nothing	The page is a scan with no text layer	Run OCR first, or try Data from Picture
Rows run together	Multi-line rows were not identified correctly	Clean up in Power Query with Fill Down or Group
Import hangs on a large file	The whole document is being parsed at once	Set StartPage and EndPage, or turn off MultiPageTables
Numbers became dates	Excel’s automatic conversion, which cannot be disabled	Format the cells as Text before pasting

The last two rows need a word of explanation. The function underneath the connector is Pdf.Tables, edited in the formula bar or the Advanced Editor. Its options include StartPage (default 1), EndPage (default the last page), MultiPageTables (combines similar tables on consecutive pages, default true) and EnforceBorderLines (treat border lines as hard cell boundaries, default false). For a slow import, Microsoft suggests you “Try selecting pages one at a time or one small range at a time using the StartPage or EndPage options,” and adds that if the PDF is one single huge table, disabling MultiPageTables may help. For scrambled rows it points at UI operations or custom M code, naming Table.FillDown to copy misaligned data downward and Table.Group to combine adjacent rows. All of it is on the Power Query PDF connector page.

Whichever route you take, budget a few minutes for cleanup after the data lands. Headers repeated on every page, blank spacer rows and totals lines that the extractor treated as data are normal, not a sign the import failed. Sort by the key column, scan the top and bottom of the range, and clear out duplicate rows before anyone builds a formula on top of the result.