Converting
How to Export Tables From a PDF to CSV
Get tabular data out of a PDF and into a CSV you can actually work with — and how to check the extraction before you trust the numbers.
CSV is the format data goes to when it needs to be processed rather than read: imported into a database, loaded into a script, opened in any spreadsheet on any platform.
Get the table out
- 1Open the PDF to Excel tool and add your document.
- 2Convert. Text is grouped into rows and columns using position and any ruled lines.
- 3Open the result in a spreadsheet and check the column boundaries.
- 4Save as CSV once you are satisfied the grid is right.
Verify before you trust it
Table extraction fails quietly, which is what makes it dangerous. Four checks catch nearly everything:
- Count the rows. A mismatch usually means wrapped cells were split into extra rows.
- Total a numeric column and compare it with the total printed in the PDF.
- Look for cells containing what should be two values — a column boundary that was missed.
- Check the first and last rows, where headers and totals get mixed into the data.
Cleaning the data
| Symptom | Fix |
|---|---|
| Numbers will not sum | They are text — strip currency symbols, spaces and stray characters |
| Two values in one cell | Text to Columns with the right delimiter |
| Header repeated through the data | The table spanned pages; delete the repeats |
| Rows split in two | A cell wrapped onto a second line; re-join them |
| Dates read as text or as the wrong day | Reformat the column explicitly |
Ask for the source first
Every PDF table was generated from something — a spreadsheet, a database, a report tool. That source is authoritative and requires no verification. For a one-off table, extraction is quicker than an email; for anything recurring or financially material, the email is worth sending.
Scanned tables
OCR first, then extract, then verify twice. A digit misrecognised in a column of figures is invisible in the output and entirely plausible in the data — this is the highest-risk extraction there is.
Do it now
PDF to Excel
Turn PDF tables into a spreadsheet (XLSX). It runs in this browser tab — your file is not uploaded anywhere.
Open PDF to ExcelFrequently asked questions
Can I go straight from PDF to CSV?+
Convert to a spreadsheet first. That is where you can see and correct the column boundaries before committing to a flat file.
Why is my data all in one column?+
The spacing between columns was not read as a boundary. Use Text to Columns to split it.
Can I extract a table that spans several pages?+
Yes, but each page is handled separately and repeated headers land in the middle of your data. Delete them afterwards.
How accurate is table extraction?+
Very good on ruled, regular tables. Poor on borderless layouts with merged cells — and always worth verifying against a printed total.