Convert PDF to CSV
Tables from a PDF come out as CSV rows and columns, ready to open in Excel or Google Sheets and add up.
Convert PDF to CSV when the numbers in a report have to be counted, not just read. CSV opens in Excel, Google Sheets and anything else that can add up a column.
What happens when you convert PDF to CSV
A table in a PDF is drawn: the lines are one thing, the captions another. You cannot select a column with the mouse and get a total, and copied values run together into a single line. CSV keeps the values themselves, laid out in rows and columns, and a formula can reach them.
Tables found in the document are pulled out. If there are several, they all land in one file one after another, separated by a blank line, so check where one ends and the next begins before you start counting.
- Cell values and the split into rows and columns carry over.
- Styling has no place in CSV: fonts, fills, borders and merged cells stay in the original.
- Accented and non-Latin text opens in Excel right away, with no encoding to pick.
- If the document holds no tables, the text goes into the file instead: each PDF line becomes one CSV row in a single column.
The other direction lives on the CSV to PDF converter page, which turns an export into a document you can print or send.
How to convert
- Upload your PDF to this page.
- Check that the target format is CSV.
- Start the conversion and wait for the finished file.
- Download the CSV and open it in a spreadsheet editor.
What people pull out of PDFs
- Turn a bank statement into a table and sort the transactions by category.
- Add up an invoice or estimate that arrived as a PDF with no source file.
- Feed a supplier price list into inventory software: almost every system accepts a CSV import.
- Compare two monthly reports by sorting on a column instead of retyping figures.
- Hand the data to a colleague who has no Excel: a CSV opens even in a text editor.
Frequently asked questions
Will formulas from the PDF survive?
A PDF holds no formulas, only the printed result of a calculation. The same numbers land in the CSV, and you write the formula that recalculates them in your spreadsheet editor.
What about a table in a scan?
Text and tables from a scanned PDF also reach the result, they are recognised. Look the export over in that case: on a blurred or tilted photo a value sometimes lands in the wrong column.
When is XLSX the better target than CSV?
CSV holds one sheet with no styling, and almost every system takes it on import. If you need several sheets, column widths and formatting, use the PDF to XLSX converter.
What if the PDF has no tables at all?
Then the document text goes into the CSV line by line. For running text the PDF to TXT converter is a better fit.
More about the formats
What the format is, how to open it and how it differs from the others.