What is a CSV file?

An example, in 4 lines

If you opened a CSV file in a text editor, this is literally what you'd see:

Name,Email,Country
John,john@email.com,Canada
Sarah,sarah@email.com,USA
Liam,liam@email.com,Ireland

How CSV works (in plain English)

• Each line in the file = one row in the table
• Each comma in a line = one column boundary
• The first row is usually a 'header' naming each column
• Values with commas inside are wrapped in double-quotes ("like this, here")
• Line breaks separate rows, not nested data

Why CSV matters in 2026

CSV has been around since the 1970s. It's older than the web. It's older than most spreadsheet software. And it's still the format every system on Earth understands — because it's simple, open, and tied to no one company.

What CSV doesn't do

CSV stores text data only. It has no formulas, no formatting, no multiple sheets, no charts, no images, no cell colours. If you need any of that, you want Excel (.xlsx), Numbers (.numbers), or Google Sheets. CSV is for raw data, not presentation.

When to use CSV

• Importing or exporting between two systems
• Backing up structured data
• Sharing a list with someone in a different software ecosystem
• Feeding data into a script, AI pipeline, or automation
• Storing data you might want to read in 20 years

When NOT to use CSV

• You need formulas or calculations (use Excel)
• You're storing rich content (images, formatting)
• You need real-time collaboration (use Sheets)
• You need version history (use a database)