PDF Tables to CSV
Pull the tables out of a PDF as CSV files, ready for your spreadsheet. No upload, no signup, no watermark.
Files stay on your device How it works
Drop files here, paste, or
PDF · up to 10 files, 100 MB each
Your files
Your file is ready
Get a PDF’s tables into a spreadsheet
Numbers in a PDF table are hard to work with: copying them out usually gives one long line of text, or every cell on its own line. To total a column, sort the rows or make a chart, you need them in a spreadsheet. This tool finds the tables in a PDF and saves each one as a CSV file, which Excel, Google Sheets, Numbers and every other spreadsheet open directly.
How to extract tables
- Choose up to 10 PDFs, each up to 100 MB.
- Press Extract tables.
- Download each CSV file, or all of them as a ZIP. Each file is named after the PDF, the page and the table, such as
report-page-2-table-1.csv.
How tables are found
A PDF doesn’t mark which text is a table; it only records where each piece of text sits. The tool looks for runs of lines that are split into separate cells by clear gaps, and lines up those cells into columns across the rows. Right-aligned numbers and centred headings fall into the right column. Paragraphs of ordinary text are left out, so you get the tables and nothing else. The note under each file says how many rows and columns it has.
Checking the result
- Headings come out as the first row, like any other row.
- Numbers keep the format they had in the PDF, such as
1,250.00; spreadsheets usually read them as numbers. - Merged or empty cells come out empty, so the columns stay in line.
- Glance over each table against the PDF, especially ones with wrapped cells or very tight columns.
Opening the CSV
- Excel: double-click the file, or use Data, then From Text/CSV, which lets you check the columns before loading.
- Google Sheets: File, then Import, then upload the file, and choose to insert it as a new sheet.
- Numbers on a Mac: open the file directly; each CSV becomes a table.
- Decimal commas: if your spreadsheet is set up for a country that writes 1.250,00, figures written as 1,250.00 may read as text. Change the import’s number format, or replace the separators after importing.
Good to know
- Scans and charts are pictures, not text, so no table can be read from them; the tool says so.
- No tables found: the tool tells you, rather than making empty files.
- For all the text rather than just the tables, use PDF to Text.