How to get a PDF table into Excel

Copy-pasting a table from a PDF into Excel almost never works. You select a tidy grid, paste, and everything lands in a single column with the numbers jammed against the labels. That is not Excel being awkward — it is a consequence of how PDFs store tables.

A PDF has no concept of a table. There are no rows, no cells, no column definitions. There are only pieces of text, each with an x and y coordinate on the page. The table you see is an illusion created by placing those pieces in neat columns. When you copy, you get the text without the coordinates, and the illusion collapses.

The fix is to reconstruct the grid from the coordinates instead of throwing them away. That is what a PDF-to-CSV conversion does, and CSV is a format Excel opens natively.

1. 1
   Convert the PDF to CSVDrop the file into the converter below. It groups text by vertical position to find rows, then clusters the horizontal positions to work out where the column boundaries are. You get one CSV per table-like region found.
2. 2
   Check the preview before you downloadThe result appears as a real grid. This is the moment to confirm the column count matches what you saw in the PDF. Catching a merge here takes a second; catching it after you have built formulas on top does not.
3. 3
   Open the CSV in ExcelDouble-clicking usually just works. If Excel puts every field in column A, use Data → From Text/CSV instead and pick comma as the delimiter — that path gives you an explicit import dialog rather than relying on your locale settings.
4. 4
   Fix the number formatsCSV carries no formatting, so a column of currency arrives as plain numbers and dates may need re-typing as dates. Select the column and set the format you want. This is one operation per column, not per cell.

Two failure modes are worth recognising, because they have different fixes.

Columns merged into one: two columns sat close together and the clustering read them as a single group. This is common in dense financial tables. Splitting them afterwards in Excel with Data → Text to Columns is usually quicker than fighting the source file.

One row split into two: a cell contained wrapped text, so its second line sat low enough to look like a new row. You will see a row that is mostly empty with a fragment of text in one cell. Delete the stray row and append the fragment to the cell above.

Most of them upload your file to a server. For a published price list that is fine. For a payroll summary, a bank statement, or anything under an NDA, it means handing a copy of the data to a third party whose retention policy you have not read. The conversion below runs in your browser: the PDF is parsed by JavaScript on your own machine and never leaves the tab.