XLSX vs CSV: workbook or simple data table
Both formats hold tables, but they are built for different moments. An XLSX workbook is a working file: several sheets, formulas, number formats, charts and print settings. A CSV file is plain text, one row per line and columns split by a separator, with nothing but values. Spreadsheets open both, yet what survives the trip is very different.
At a glance
| Aspect | XLSX | CSV |
|---|---|---|
| Content | Values, formulas, formatting, charts and comments. | Values only, stored as text. |
| Sheets | Several sheets in one workbook. | One table per file. |
| Data types | Dates, numbers and currencies keep their type. | Everything is text until a program interprets it. |
| Portability | Needs a spreadsheet program to open. | Any editor, database or script can read it. |
| Pitfalls | Hidden rows, formulas and comments may travel unnoticed. | Separators, encodings and leading zeros can go wrong. |
| Typical use | Budgets, reports and shared working files. | Bank exports, imports, data exchange between systems. |
Moving tables in and out of PDF
Excel to PDF prints a workbook using its own page setup, while CSV to PDF detects a comma, semicolon, tab or vertical bar separator and lays the rows out as a table. In the other direction, PDF to Excel writes the tables of a PDF into an XLSX file and Extract PDF Tables saves them as CSV.
When to choose which
XLSX
Choose XLSX when people will keep working on the numbers: totals with formulas, several related sheets, formatting that makes the report readable, or charts.
CSV
Choose CSV when the data must be imported into another system, such as accounting software, a database or a mailing tool, or processed by a script.
Free tools for both options
Guides that put it into practice
PDF terms explained
- 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.
- Text layerThe text layer is the part of a PDF that holds real characters, so you can search, select and copy. Learn how scans get one through OCR and how to check for it.
Common questions
- Why does my CSV lose the leading zeros of codes?
- The spreadsheet treats the column as numbers. Import it with the column type set to text, or keep codes in XLSX where the cell type is stored.
- Can a CSV file have several sheets?
- No. Each CSV file holds one table. Export each sheet to its own CSV, or keep the workbook as XLSX.
- Which format should I pick when extracting tables from a PDF?
- Pick CSV for importing into other software and XLSX when you will work on the table in Excel straight away.