CSV: tables as plain text
CSV, for comma-separated values, stores a table as plain text: each line is a row, and a separator splits the line into columns. The format is older than personal computers; RFC 4180 from 2005 describes the common rules, such as quoting fields that contain commas or line breaks. In many European locales the separator is a semicolon, because the comma is the decimal mark.
Key facts
- Extensions
- .csv
- Media type
- text/csv
- Standard
- RFC 4180
Where it is used
CSV is the exchange format for data: bank and card transaction exports, contact lists, product catalogues, e-commerce orders, accounting imports and database dumps. Almost every spreadsheet, database and online service can import or export it.
Strengths
It is simple, small and readable in any text editor. Any program can read it, so it moves data between systems that share nothing else, and it has no formulas or macros, only values. It works well with scripts and version control.
Limitations
There is no single strict standard: separators, quotes, decimal marks, date formats and encodings vary, so imports can split columns wrongly or garble accents. CSV has no formatting, no formulas, no several sheets and no data types; leading zeros are often lost when a spreadsheet opens it.
Converting it to PDF
CSV to PDF reads your file, detects whether the separator is a comma, semicolon, tab or vertical bar, and lays the rows out as a table on PDF pages, ready to print or attach. Save the CSV as UTF-8 so accents survive. Very wide tables are easier to read in landscape.
Getting it back from a PDF
Extract PDF Tables finds tables in a PDF and saves them as a CSV file you can open in any spreadsheet or import elsewhere. PDF to Excel gives an XLSX instead. Results are best with digital PDFs that have clear columns; scans need OCR first.
Convert with these free tools
Side-by-side comparisons
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.
Guides that put it into practice
Common questions
- Why does my CSV open in a single column?
- The separator does not match your spreadsheet's regional setting. Use the import dialog and choose comma or semicolon explicitly.
- Can a CSV file keep formatting or formulas?
- No. It stores only values as text. Use XLSX for formatting, formulas or several sheets.
- Should I choose CSV or XLSX when extracting tables from a PDF?
- CSV is best for importing into other software; XLSX is better when you will work in Excel and want columns ready to use.