CSV or PDF for data: values to work with or a page to hand over
A table of figures can be stored as a CSV file or as a PDF, and the two formats answer different needs. CSV holds every cell as plain text separated by commas or semicolons, so a spreadsheet or a script can sort it, calculate with it and import it elsewhere. A PDF holds the same table as a fixed page that looks identical for every reader but is awkward to process. This page compares them so you can pick the format that fits what happens to the data next.
At a glance
| Aspect | CSV | |
|---|---|---|
| Purpose | Moving and processing data between programs. | Presenting a table that should look the same everywhere. |
| Editing | Every value can be changed in a spreadsheet or text editor. | Changing a value usually means rebuilding the page. |
| Appearance | No fonts, colors or column widths are stored. | Layout, fonts and spacing are kept exactly. |
| Reading by a program | Straightforward, because each cell is a separate value. | Needs the table to be detected and extracted first. |
| Typical case | An export from accounting or a database that someone will analyze. | A statement or report that goes to a reader who only needs to look at it. |
Decide by what happens after sharing
Ask what the receiver will do with the numbers. If they will sort, filter or calculate, send the CSV, or a spreadsheet, because retyping figures from a page invites mistakes. If they only need to read or approve the table, a PDF is the safer choice since nothing shifts on their screen. Many workflows use both: keep the data file as the source and produce a PDF for reading. If you only have the PDF, tables can be extracted again, but check the numbers, merged cells and dates afterwards.
When to choose which
CSV
Choose CSV when the data will be sorted, calculated or imported into another system.
Choose PDF when the table is final and should be read or printed exactly as laid out.
Free tools for both options
Guides that put it into practice
- Turn a CSV export into a PDFStep by step: check the file and its separator, convert the CSV into a PDF table, add page numbers and compress the result before you share it.
- Move PDF tables to ExcelStep by step: tell a text PDF from a scan, run OCR when needed, pull out the tables as spreadsheet data and check the numbers before you use them in a report.
PDF terms explained
- CSVCSV is a plain-text format that stores a table as lines of values split by a separator. Learn how it works, its pitfalls and how to move data between CSV and PDF.
- Table extractionTable extraction turns tables printed in a PDF into rows and columns you can edit in a spreadsheet. Learn how it works, its limits and how to check results.
Common questions
- Can I get a CSV back from a PDF table?
- Often yes, if the table is real text and not a picture. Scanned tables need text recognition first, and the result should be checked.
- Why do my accents look wrong in a CSV?
- The file may be read with a different character encoding than the one it was saved in. Opening it as UTF-8 usually fixes this.
- Which of your tools handle this?
- CSV to PDF lays a data file out as a printable table, Extract PDF tables reads tables from a PDF and PDF to Excel puts a table into a spreadsheet you can edit. Each result is a new file and the original stays intact.