Yes, with limits. Excel for Windows has a built in Get Data From PDF feature, powered by Power Query, that can import a table out of a digital PDF without any add in. It is genuinely useful for a clean, single table PDF, and it costs nothing beyond the Excel you already have. But it is Windows only, it cannot read scanned pages because it has no OCR, and it often mis splits tables that have no borders or that span several columns. For those cases, and for anyone on Mac or Excel for the web, you need a dedicated converter.
Here is exactly what the built in feature does, how to use it, and where it runs out of road.
Does Excel have a built-in PDF to Excel converter?
On Excel for Windows, version 2016 and later including Microsoft 365, the answer is yes. Open the Data tab, choose Get Data, then From File, then From PDF. Excel loads the PDF through Power Query, scans it for anything that looks like a table, and lets you import the one you want. It is not marketed loudly as a "PDF to Excel converter," which is why many people never find it, but it is a real, supported feature and for the right file it works well.
How to use Excel's Get Data From PDF, step by step
Go to Data, then Get Data, then From File, then From PDF, and pick your file. Excel opens the Navigator window and lists the tables and pages it detected, each with a small preview. Click through the entries to find the table you want, since a busy page can produce several candidates. When the preview looks right, choose Load to drop it straight onto a sheet, or Transform Data to open Power Query first and clean up headers, remove blank rows, or set data types before loading. That is the whole flow for a well behaved file.
What Excel's built-in PDF import cannot do
The feature is capable but narrow. The table below covers the limits that catch people out.
| Limitation | What it means |
|---|---|
| Windows only | Get Data From PDF is not in Excel for Mac or Excel for the web. Those users have no built in option. |
| No OCR | It reads text that is already in the file. A scanned or photographed PDF returns nothing usable. |
| Borderless and merged tables | Tables without ruling lines, or with merged headers and wrapped cells, often split into the wrong columns. |
| Multi column layouts | A page with two side by side tables, or text columns around a table, frequently confuses the detection. |
| One file at a time | There is no simple batch mode for converting a folder of PDFs in one action. |
Digital PDF vs scanned PDF
This is the distinction that decides whether the built in tool will work at all. A digital PDF, the kind exported from accounting software, a bank portal, or a report writer, has the text stored inside it, so Power Query can read and place it. A scanned PDF is an image of a page, with no text underneath, so there is nothing for Get Data to extract and you get an empty or broken result. If your file came off a scanner or a phone camera, Excel's built in import is the wrong tool, and you need optical character recognition first.
When to use a dedicated converter instead
Reach for a standalone PDF to Excel converter when the built in path does not fit. That covers scanned documents, where you need OCR that reads the scan and rebuilds the grid; Mac and web users, who have no Get Data From PDF at all, so an online converter is the practical answer; complex or borderless tables that Power Query mangles; and any time you have a stack of files to process rather than one. If you like the Power Query route for clean files, the step by step for that method is covered in the guide to converting a PDF with Power Query, and you can also start from Excel's own import a PDF into Excel workflow.
Why doesn't the built-in feature find my table?
When Get Data From PDF loads but the Navigator shows no usable table, or splits the data badly, a few causes account for most of it. The file is a scan, so there is no text to detect, which is the most common reason of all. The table has no ruling lines, so Power Query cannot see where the columns break and either misses the table or merges columns together. The layout puts two tables side by side, and the detector treats the whole strip as one wide table with empty gaps. Or the numbers carry currency symbols and thousands separators that import as text, so totals refuse to add up until you set the column type. For the first case there is no workaround inside Excel, and for the others, Transform Data lets you split columns and set types by hand, but past a couple of files that cleanup outweighs the time a dedicated converter would take.
Is Power Query PDF import free?
It is included with Excel, so there is no separate charge. If you already have Excel 2016 or later on Windows, or a Microsoft 365 subscription, Get Data From PDF is built in and you pay nothing extra to use it. That is a genuine advantage over any paid converter for the clean, digital files it handles well. The cost only shows up as time when the feature cannot cope with a scan or a messy layout and you end up cleaning the output by hand.
Excel Get Data vs an online converter, compared
| Factor | Excel Get Data From PDF | Dedicated online converter |
|---|---|---|
| Platform | Windows Excel only | Any browser, Windows, Mac, or web |
| Scanned PDFs | Not supported (no OCR) | Supported with OCR |
| Clean digital table | Works well | Works well |
| Complex or borderless tables | Often mis splits | Handled by table detection |
| Cost | Included with Excel | Free tier or paid, varies |
| Batch files | No simple batch | Often supported |
The honest summary: for a clean, digital, single table PDF on a Windows PC, Excel's own Get Data From PDF is the right first try and you may not need anything else. The moment the file is scanned, the layout is complex, or you are not on Windows Excel, a dedicated converter is the faster path. Teams that need this reliably across many different document types usually skip the manual route and pull the data with tooling that turns messy sources into clean, structured data.