Export data from almost any app — a spreadsheet, a bank, a website’s records — and you’ll often be handed a CSV file. It looks plain and unremarkable, and that’s exactly its strength. The CSV is one of the simplest and most universal file formats there is, and it quietly moves data between programs that otherwise couldn’t talk to each other. Here’s how it works.

What CSV stands for

CSV means Comma-Separated Values. The name literally describes the format: it’s a plain text file where each piece of data is separated by a comma. That’s genuinely all there is to it. A CSV storing a small table might look like this inside:

Name,Age,City
Alice,30,London
Bob,25,Cape Town

Each line is a row, and the commas mark where one column ends and the next begins. Open it in a spreadsheet and it lines up into a neat grid; open it in a text editor and you see the raw commas. Both are the same file.

Why such a simple format is so useful

The beauty of CSV is precisely its simplicity. Because it’s just plain text with commas, almost every program that handles data can read and write it — spreadsheets, databases, programming languages, analytics tools, accounting software, you name it. It’s the closest thing data has to a universal language.

This makes CSV the go-to format for moving data between systems. Export your contacts from one app as a CSV, import that CSV into another — done. The two programs never need to understand each other’s native formats; they just meet in the middle at the humble CSV.

CSV vs a real spreadsheet file

It’s worth understanding how a CSV differs from a proper spreadsheet file like the Office formats (XLSX). A CSV stores only the raw data — the values in the cells. It stores nothing else: no formatting, no colours, no fonts, no formulas, no multiple sheets, no charts. An XLSX stores all of that richness; a CSV throws it all away and keeps just the numbers and text.

That’s a feature, not a flaw. The stripped-down simplicity is exactly why CSV is so portable. But it means if you save a formatted, formula-filled spreadsheet as a CSV, you keep the values and lose everything else — a common surprise for people who don’t expect it.

The gotchas worth knowing

CSV is simple, but a few things trip people up:

  • Commas inside the data. What if a value itself contains a comma, like “Smith, John”? The format handles this by wrapping such values in quotation marks, so the comma inside isn’t mistaken for a separator. Usually this is automatic, but it’s the source of occasional “the columns are all wrong” headaches.
  • It’s not always commas. Confusingly, some regions and programs use semicolons or tabs instead of commas (a tab-separated version is called a TSV), often because their number formatting already uses commas. If a CSV opens as one jumbled column, a different separator is usually why.
  • Leading zeros and long numbers. Spreadsheets sometimes mangle CSV data — dropping the leading zero from a code, or turning a long number into scientific notation. Worth checking after import.
  • No formatting survives. Remember, only raw values are kept.

How to open and create them

Any spreadsheet program (Excel, Google Sheets, LibreOffice) opens CSVs and lets you save data as CSV via “export” or “save as.” For a quick peek at the raw contents, any text editor works too — a reminder that underneath the tidy grid, it really is just lines of text. When importing, most spreadsheets give you options to set the separator and how columns are interpreted, which solves most of the gotchas above.

Where you’ll meet CSV files

  • Exporting and importing data between apps — contacts, transactions, records.
  • Downloading data from banks, websites, and online services.
  • Bulk uploads — many systems accept a CSV to add lots of entries at once.
  • Data analysis — it’s the default format for feeding data into analytics and programming tools.

The short version

  1. A CSV is a plain text file of data, with commas separating the columns and each line a row.
  2. Its simplicity makes it near-universal — almost any data program reads and writes it.
  3. It stores only raw values, not formatting, formulas, or multiple sheets.
  4. Watch for commas inside data, alternative separators, and spreadsheets mangling numbers.

The CSV proves that the most useful formats are often the simplest. It’s not pretty and it doesn’t try to be — it’s just a reliable, universal way to move a table of data from one place to another. Next time you export or import a CSV, you’ll know exactly what that plain little file is doing, and why nearly every program on earth understands it.