AuraDoc
Sign inSign up

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

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.

Other file formats

Need more than a quick fix?

AuraDoc is a document platform with OCR, AI search and summaries, and more than 60 PDF tools for teams. Try it free for 7 days.

Free tools for personal and professional use. This one runs on an isolated AuraDoc server: the file is deleted right after processing and never stored. Fair use and anti-abuse policy