AuraDoc
Sign inSign up

What is a CSV file?

CSV stands for comma-separated values. It stores a table as plain text: each line is a row, and the values in the row are divided by a separator, most often a comma, a semicolon, a tab or a vertical bar. The first line usually holds the column names. Databases, accounting programs, online shops and banks export CSV because almost every spreadsheet and script can read it.

Strengths and pitfalls

CSV is small, simple and free of formatting, which is exactly why it travels so well. It also has no types or styles: a number, a date and a postal code are all just text until the receiving program guesses. Leading zeros can vanish, dates can be read in the wrong order, and a separator that appears inside a value must be wrapped in quotes. Encoding matters too, since accents and non-Latin letters break if the file is read with the wrong one.

CSV and PDF

A CSV file is for machines and spreadsheets; a PDF is for reading and sharing. The CSV to PDF tool prints the file as a table, with the first row as the header and every row kept. It detects commas, semicolons, tabs and vertical bars on its own, and it reads UTF-8 best, plus UTF-16 and Latin-1. In the other direction, Extract PDF tables saves the tables found in a PDF as CSV, and PDF to Excel produces a workbook instead.

Practical advice

Check the result against the source. A very wide table may be cramped on a page, so keep only the columns your reader needs before converting. When you receive CSV from a PDF, open it in a spreadsheet and verify that numbers and dates landed in the right columns. Scanned PDFs have no text layer, so run OCR first or there is no table to read. Keep the original CSV as the editable master.

Tools that use this

Guides that put it into practice

Common questions

Which separator should I use?
Any of the common ones works. Semicolons are frequent in countries that write decimals with a comma. The converter detects commas, semicolons, tabs and vertical bars automatically.
Why do accents look wrong in my CSV?
The file was probably saved in an encoding different from the one used to open it. UTF-8 is the safest choice, and the converter can also read UTF-16 and Latin-1.
Is CSV the same as Excel?
No. Excel files can hold several sheets, formulas, styles and charts. CSV holds only one table of plain values.

Side-by-side comparisons

Related terms

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