Guide · updated August 2026

How to convert a PDF to Excel

Four ways to get a table out of a PDF and into a spreadsheet, what each one is actually good at, and how to repair the columns when the extraction lands badly.

PDF was designed to make a page look identical everywhere it is printed. It succeeded, and in doing so it threw away the structure of whatever was on the page. A table in a PDF is not a table. It is a set of characters with coordinates that happen to line up. Any tool that converts PDF to Excel is reverse-engineering that layout, which is why results vary so much between documents.

Below are the four methods worth knowing, starting with the fastest.

Method 1 — A browser-based converter

Nothing to install, works on any operating system, and with this one the file never leaves your machine because the parsing happens in JavaScript on the page.

Open the PDF to Excel converter.
Drag the PDF onto the grid, or click Choose PDF file.
Look at the preview. Each column of your original table should sit in its own lettered column.
If two columns have merged, drag Column spacing to a lower number. If one column has split in two, raise it.
Type a page range like 3-18 if the table only occupies part of the document.
Click any cell to correct it, then Download XLSX.

Open the converter

Watch the column spacing control. It is the single most useful setting. It sets how far apart two pieces of text must be before they are treated as belonging to different columns. Dense financial tables usually want a low value; wide, airy tables want a high one.

Method 2 — Excel's built-in PDF import

Microsoft 365 and Excel 2021 can read a PDF directly. It is genuinely good when a table has ruled borders, and poor when it does not.

In Excel, go to Data → Get Data → From File → From PDF.
Pick the PDF. The Navigator pane lists every table Excel thinks it has found, named Table001, Page001 and so on.
Click through them until you find yours, then choose Load, or Transform Data to clean it in Power Query first.

Power Query is worth the extra step if this is a recurring job. Once you have written the cleanup — promoting headers, removing null rows, changing types — you can point the same query at next month's PDF and refresh.

On Excel for Mac and Excel for the web, the From PDF connector is not available. Use another method there.

Method 3 — Adobe Acrobat Pro

Acrobat's own export is strong on documents it created itself, and it is the only one of these that includes OCR for scans. It is also a paid subscription.

Open the PDF in Acrobat Pro.
Choose Export a PDF → Spreadsheet → Microsoft Excel Workbook.
Under Settings, enable text recognition if the document is a scan, and set the language.

Method 4 — Copy, paste, and Text to Columns

The fallback that always works, for a table small enough to be worth the effort.

Select the table in your PDF reader and copy it.
Paste into a blank Excel sheet. You will usually get one column.
Select that column and choose Data → Text to Columns.
Pick Delimited and tick Space, or pick Fixed width and place the break lines by hand.

Fixed width is the better choice for financial data, because values inside a cell often contain spaces and would otherwise be split apart.

Which method to use

Method	Best for	Cost	Files leave your device
Browser converter	Any text PDF, confidential documents, multi-page statements	Free	No
Excel Get Data	Tables with ruled borders, recurring monthly imports	Included with Microsoft 365	No
Acrobat Pro	Scanned documents needing OCR	Subscription	Depends on settings
Copy and paste	One small table, one time	Free	No

Fixing a bad extraction

Two columns have merged into one

The gap between them was narrower than the gaps inside the text. Lower the column spacing value. If that starts breaking other columns apart, extract anyway and split the offending column afterwards with Text to Columns, or in Google Sheets with SPLIT.

One column has split into two

Usually caused by a column that mixes short and long values, or by right-aligned numbers of differing widths. Raise the column spacing value. If only a few rows are affected, fix them in the preview grid before exporting.

Rows appear twice or out of order

Some PDFs draw text in an order unrelated to reading order, and a few draw a shadow copy of the text underneath for effect. Sort by the first column after export, and remove duplicates from the Data ribbon.

Numbers are stored as text

Excel refuses to treat 1,204.50 or (430.00) as a number when it arrives from a PDF. Select the column and use Data → Text to Columns → Finish, which forces a re-parse. For accounting-style negatives in brackets, find ( and replace with -, then delete the closing bracket.

Every row has one blank cell in the same column

The extractor found a column anchor from a heading that only appears once. Delete the column after export — the data is intact.

The page comes back empty

The PDF is a scan: an image of a page rather than characters. No amount of tuning will help, because there is no text to read. Run OCR first — Acrobat, most scanner apps, and macOS Preview's live text can add a text layer — then convert the result.

Keeping the data clean afterwards

Promote the first extracted row to a header row, then freeze it.
Delete repeated page headers if any survived the cleanup filter — sort by column A and they will group together.
Check the totals. If the PDF has a stated total, sum your column and compare. This catches a dropped row faster than reading every line.
Re-join descriptions that wrapped onto a second line, using =A2&" "&A3 or by concatenating in Power Query.

For the specific case of transaction lists running across many pages, there is a dedicated walkthrough for converting bank statements to Excel.