PDF to Excel
By Oakgen Team · Updated
In Microsoft 365 Excel on Windows choose Data > Get Data > From File > From PDF, pick the table in the Navigator and load it. Adobe Acrobat also exports a PDF to XLSX.
Option 1: Excel's built-in import
In Excel go to Data > Get Data > From File > From PDF. Choose the file, then pick a table from the Navigator, which lists the tables Excel found. Load puts it on a sheet; Transform Data opens it in Power Query to clean it first. Microsoft's Power Query connector reads tables; its documentation lists options for a start and end page and for tables that continue across pages, which you set in the query formula rather than in the Navigator.
Microsoft's version table lists the PDF connector as included in Microsoft 365 plans and not in Office 2016 or 2019. It does not say whether Excel 2021 or 2024 include it, so check your own Data menu. Microsoft's support page lists .NET Framework 4.5 or higher as a requirement.
Option 2: Adobe Acrobat export
In Acrobat desktop, choose Convert > Microsoft Excel > XLSX, then Convert to XLSX. You can put each table, each page or the whole document on its own worksheet and set decimal and thousands separators. Adobe's page also offers text recognition settings. On the web, Adobe's Export a PDF tool covers Excel as well; Adobe's help page for the free reader says the export service needs a paid subscription.
Scanned PDFs and limits
A scanned PDF contains only an image, not text. Adobe's documentation says to run its text recognition (OCR) first. Microsoft's documentation does not say how the Excel connector treats image-only PDFs, so test with your own file before relying on it.
An Excel worksheet holds 1,048,576 rows by 16,384 columns, which is far more than most PDF tables need.
- Merged cells and multi-line headers often need cleaning after import.
- Check totals against the PDF before using the numbers.
File formats in one line
PDF is the ISO 32000-2 (PDF 2.0) format. Excel's .xlsx is part of the Office Open XML family (ISO/IEC 29500 and Ecma-376), a published standard, which is why many tools can write it.
Do more with Oakgen Agent
Attach your PDF (up to 100 pages) and the Agent can read it and build a new .xlsx file from the tables you point to. It rebuilds the data, so it does not keep the PDF's layout, and you should check the numbers.
Coming soonA one-click PDF to Excel converter that keeps the original layout.
Open in Oakgen AgentThe prompt is filled in for you. Nothing is sent until you press send in the Agent.
FAQ
Can Excel open a PDF directly?
Excel for Microsoft 365 on Windows can import tables from a PDF with Data > Get Data > From File > From PDF. Older perpetual versions such as 2016 and 2019 are listed as not including it.
Why is my converted PDF table messy?
PDFs store text positions, not table structure. Merged cells, wrapped headers and tables split across pages often import as extra rows or columns.
What about scanned PDFs?
They need text recognition (OCR) first, for example in Adobe Acrobat. Without it the file has no text to extract.
Can Oakgen Agent do this?
Partly. It can read an uploaded PDF of up to 100 pages and rebuild the tables you point to as a new spreadsheet. It re-creates the data rather than converting the file, so check the numbers.
Sources
- Microsoft Support: import data from data sources (Power Query), From PDF steps (read 2026-11-19)
- Microsoft Support: Power Query data sources in Excel versions (read 2026-11-19)
- Microsoft Learn: Power Query PDF connector (read 2026-11-19)
- Microsoft Support: Excel specifications and limits (read 2026-11-19)
- Adobe Help Center: convert PDF to Excel (read 2026-11-19)
- Adobe Help Center: recognize text in scanned PDFs (read 2026-11-19)
- Adobe Help Center: export a PDF from Acrobat Reader (read 2026-11-19)
- ISO 32000-2:2020, PDF 2.0 (read 2026-11-19)
- Ecma International: ECMA-376 Office Open XML file formats (read 2026-11-19)