Z

What is CSV?

CSV (Comma-Separated Values) is a plain-text format for tabular data, where each line is a row and fields are separated by commas. It is simple, compact and supported by every spreadsheet and data tool, but has no types, no nesting and no formal standard for quoting.

Each CSV line is a record; the first line is usually a header naming the columns. Fields containing commas, quotes or newlines are wrapped in double quotes. Everything is text — there are no numbers, booleans or nested structures.

CSV is ideal for exporting and importing flat, tabular data between spreadsheets, databases and analysis tools. For nested or typed data, JSON is a better fit.

CSV tools

Frequently asked questions

What does CSV stand for?

Comma-Separated Values — a text format where each line is a row and commas separate the fields.

Can CSV store nested data?

No. CSV is strictly flat and tabular. For nested or typed records use JSON instead.