DocTable

How to convert PDF to Excel

There are four working methods, and which one you need depends on a single question: does the PDF have a text layer, or is it a scan? Answer that first and the rest is mechanical.

Convert a scanned PDF — upload a file

how to convert pdf to excelpdf to xlsxpdf to xlsconvert pdf to excel freepdf to excel spreadsheet

First: check whether the PDF has a text layer

Open the PDF and try to select a line of text with your cursor.

The text highlights — it is a digital PDF. Methods 1, 2 and 3 all work, and method 1 is free.
Nothing highlights — the page is a picture of a document, from a scanner or a phone camera. Only method 4 works. Power Query will return an empty table, and copy-paste will copy nothing.

This one check explains most failed conversions. A tool is not broken because it returned an empty sheet from a scan; it was the wrong tool for that file.

Method 1 — Excel Power Query (free, built in)

Excel can import a PDF itself, without any other software. In Excel, go to Data → Get Data → From File → From PDF, choose the file, pick the table you want in the Navigator pane, then click Load.

This is the first thing to try for a digital PDF, because it costs nothing and keeps the data refreshable — re-running the query on an updated file re-imports it. Two limits worth knowing before you rely on it: the From PDF connector exists in Excel 2016 and later on Windows and in Microsoft 365, but not in Excel for Mac; and it reads the text layer only, so a scanned page returns nothing.

Method 2 — copy and paste, then Text to Columns

Select the table in your PDF reader, copy it, and paste into Excel. The paste usually lands as one column of text. Fix it with Data → Text to Columns, choosing Delimited and splitting on spaces or tabs.

Fast for a small, regular table. It breaks on the two things real documents are full of: a description that wraps onto a second line becomes two rows, and a column of numbers arrives as text, so SUM returns zero until you convert it back.

Method 3 — export from Adobe Acrobat

In Acrobat Pro, open the PDF and choose Export a PDF → Spreadsheet → Microsoft Excel Workbook. Acrobat generally reconstructs columns better than a plain copy-paste because it uses the layout information stored with the text.

It needs a paid Acrobat subscription, and — like the first two methods — it depends on a text layer. Acrobat can run OCR on a scan first, as a separate step, before exporting.

Method 4 — AI OCR, for scanned and photographed PDFs

If nothing highlighted in the check above, this is the only method that will produce data. OCR reads the page as an image and reconstructs the table from what it sees, rather than parsing characters that were never there.

This is what DocTable does. Upload the PDF or a photo of the page, and the AI OCR detects the header row, the data rows and the column boundaries, then exports to XLSX, CSV or Word. Because the page is read visually, a description that wraps onto a second line is reassembled into the single row it belongs to instead of splitting in two.

Sign-in (Google or a verified email) is required before the first scan, and gives 10 free scans; after that scans use paid credits, and downloading a result costs nothing extra. OCR output is probabilistic — check totals and dates before financial or legal use.

Which method should you use

Situation	Use	Cost
Digital PDF, Windows Excel	Power Query	Free, built in
Digital PDF, small simple table	Copy-paste + Text to Columns	Free
Digital PDF, complex layout, have Acrobat	Acrobat export	Paid subscription
Scan, photo, or no selectable text	AI OCR	10 free scans, then credits
Excel for Mac, digital PDF	Acrobat export or AI OCR	No From PDF connector on Mac

Why PDF to Excel exports break

A PDF does not contain a table. It contains characters, each with a position on the page, and the grid you see is an illusion produced by where those characters sit. Every method above is reconstructing a structure that was never stored. That is why the same file can convert perfectly in one tool and arrive scrambled in another, and it explains the four failures people hit most:

Everything in one column — the tool read the text but could not infer column boundaries from the spacing.
One row split into two — a wrapped description was treated as a new record.
Numbers stored as text — a common copy-paste result; SUM returns zero until the column is converted.
An empty sheet — the PDF was a scan and the method needed a text layer.

Multi-page tables and XLS vs XLSX

Reports often continue one table across several pages, repeating the header on each. Import each page separately and you get repeated header rows in the middle of your data; a method that treats the upload as one document keeps the structure consistent instead.

Export to XLSX rather than the older XLS unless you specifically need to open the file in Excel 2003. XLS is the pre-2007 binary format and stops at 65,536 rows; XLSX is the current ZIP-and-XML format and holds just over 1,048,000.

Document-specific guides

The general steps above apply to any PDF. For the documents this comes up with most, there are focused pages: bank statement to Excel, invoice to Excel, receipt to Excel, and scanned PDF to Excel. For the converter itself, see PDF to Excel; for how the OCR works, see AI OCR. Processing is temporary — see Security & data processing.

For teams: converting PDFs in bulk

Doing this one file at a time doesn't scale for a customs desk or a reporting team processing dozens of PDFs a month. The Business pack is a bigger one-time top-up built for that: $49 for 2,000 pages — a lower per-page rate than the packs above — with an official PayPal receipt for expensing and a Data Processing Agreement available on request. Uploads are grouped automatically, so a batch of documents comes back as one clean file, not one file per page.

Get the Business pack — $49 for 2,000 pages

One-time credit, not a subscription — top up again whenever you need to. No contract, no setup fee.

Frequently asked questions

Can Excel open a PDF directly?

Not by double-clicking it. Excel 2016 and later on Windows can import one through Data → Get Data → From File → From PDF, which runs Power Query and returns the detected tables. Excel for Mac does not have the From PDF connector.

How do I convert a scanned PDF to Excel?

A scanned PDF has no text layer, so Power Query, copy-paste and Acrobat export all return nothing usable. It needs OCR, which reads the page as an image and reconstructs the rows and columns.

What is the difference between XLS and XLSX?

XLS is the pre-2007 binary Excel format, capped at 65,536 rows. XLSX is the current ZIP-and-XML format and holds just over 1,048,000 rows. Export to XLSX unless you have to open the file in Excel 2003.

Why did my columns all land in one column?

The tool exported the text but not the grid. A PDF stores characters with coordinates and no notion of a cell, so a method that only reads the text layer has to guess column boundaries from spacing, and merges columns when the spacing is uneven.

Is converting PDF to Excel free?

Power Query and copy-paste are free and built into Excel. Acrobat export needs a paid subscription. DocTable requires sign-in and gives 10 free scans, after which scans use paid credits; downloading a result costs nothing extra.

How accurate is PDF to Excel conversion?

On a clean digital PDF with a simple grid, all four methods are close to exact. Accuracy drops with merged cells, multi-line rows and low-resolution scans. OCR output is probabilistic, so always check totals and dates before financial or legal use.

Temporary processing — files are not archived. Always verify OCR output before financial or legal use. Default OCR model is the same for every language. See Privacy in the app.