CSV is a plain-text way to store data in rows and columns that almost any program can read

CSV stands for comma-separated values. It is a file format that stores information in a straightforward table structure — think of it like a spreadsheet, but saved as plain text instead of in a proprietary format like Excel. Each row represents one record, each column represents a field, and commas separate the values from each other.

The reason CSV matters is that it is universal. Microsoft Excel can open it, Google Sheets can open it, your bank's website can read it, and a text editor can open it. You do not need special software or a paid subscription. This makes CSV the format of choice when organizations need to move data between different systems or share information with people who use different tools.

A CSV file looks like this when you open it in a text editor:

Name,Email,Phone Sarah Chen,sarah@example.com,555-0142 Marcus Webb,marcus@example.com,555-0198 Jade Patel,jade@example.com,555-0156

When you open that same file in Excel or Google Sheets, it automatically recognizes the commas and displays it as a proper table with three columns and three rows of data.

Key Takeaways

  • CSV files store data in plain text using commas to separate columns, making them readable by nearly every program that handles data.
  • You can open and edit CSV files in Excel, Google Sheets, a text editor, or any spreadsheet process without needing special software.
  • Banks, government agencies, and online services often let you read your data as CSV so you can use it elsewhere.
  • CSV files have no formatting, formulas, or colors — just the raw data itself, which is why they are smaller and more portable than Excel files.

When you encounter CSV files in everyday life

You are most likely to see CSV when you read data from a website or service. Your bank may let you read transaction history as CSV. A job site may let you read your saved job listings as CSV. Google Takeout lets you read your Google data — contacts, calendar events, photos metadata — in CSV format.

Government agencies also use CSV heavily. If you request public records, they often arrive as CSV. Property tax records, business licenses, health inspection reports — these are frequently published as CSV files because the format is open and anyone can read it without needing to buy software.

CSV is also the standard format for importing data into a new system. If you switch email providers and want to bring your contacts with you, you export them as CSV from the old provider and import them into the new one. If you use accounting software and want to move to a different one, you export your transaction history as CSV and import it into the new system.

How CSV differs from Excel and other spreadsheet formats

An Excel file (.xlsx) can contain formulas, colors, multiple sheets, charts, and formatting. A CSV file contains only the data itself — no formulas, no colors, no multiple sheets. This is both a limitation and a strength.

The limitation is that if you have an Excel file with formulas that calculate totals, and you save it as CSV, those formulas disappear. Only the values they produced remain. If you have cells with background colors or special fonts, those disappear too.

The strength is that CSV files are tiny compared to Excel files, they work on any device, and they do not depend on Microsoft owning the format. A CSV file created in 1995 still opens perfectly today. An Excel file from 1995 may not open in modern Excel at all. CSV is future-proof because it is just text.

Why organizations use CSV to share data with you

When a bank, government agency, or online service offers to let you read your data, they often choose CSV because it guarantees you can actually use it. They do not know what software you have. They do not know if you have Excel. CSV works everywhere.

CSV also protects the organization. If they send you data in their own proprietary format, they are responsible for supporting that format. If they send you CSV, they are sending you plain text that any program can read. The responsibility shifts to you to use it however you need.

CSV is also the format used when data needs to move between different organizations' systems. Your employer's payroll system exports your tax information as CSV so it can be imported into the government's tax system. Your health insurance company exports claims data as CSV so it can be imported into your accountant's software.

How to open and use a CSV file

If you read a CSV file, the easiest way to open it is to double-click it. Your computer will usually open it in Excel, Google Sheets, or whatever spreadsheet program is set as the default. The data will display as a table with rows and columns.

If you want to edit the file, you can do so in any spreadsheet program. Add rows, delete columns, change values — it works like any spreadsheet. When you save it, make sure you save it as CSV format, not as Excel format, if you need other programs to read it.

You can also open a CSV file in a text editor like Notepad or Google Docs. It will look like the example above — commas separating the values. This is useful if you need to see the raw data or if you are having trouble opening it in a spreadsheet program.

Common problems when working with CSV files

The most common problem is that CSV does not handle commas inside the data well. If one of your data values contains a comma — for example, a company name like "Smith, Jones & Associates" — the CSV format can get confused about where the column break actually is. Most programs solve this by putting quotation marks around values that contain commas, but not all programs handle this correctly.

Another issue is that CSV does not specify what language or character set the file uses. A CSV file created on a computer in Japan may not display correctly on a computer in the United States if the character encoding is not specified. This is usually not a problem with English text, but it can cause issues with accented characters or non-Latin alphabets.

A third issue is that CSV does not preserve data types. If you have a column of numbers, a spreadsheet program might interpret them as text, or vice versa. This rarely causes problems in practice, but it can matter if you are doing calculations or sorting.

When to use CSV instead of other formats

Use CSV when you need to share data with someone who uses different software than you do. Use CSV when you need to move data from one program to another. Use CSV when you need a file that will still be readable in ten years without depending on any company to support a proprietary format.

Do not use CSV if you need to preserve formatting, colors, or formulas. Do not use CSV if you need multiple sheets in one file. Do not use CSV if your data contains complex structures or relationships. For those situations, Excel, Google Sheets, or a database program is more appropriate.

Frequently Asked Questions

Can I edit a CSV file and save it back as CSV?

Yes. Open it in Excel, Google Sheets, or any spreadsheet program, make your changes, and save it as CSV format. The program will ask you to confirm that you want to save as CSV rather than its native format — choose CSV if you want other programs to be able to read it.

What if my CSV file opens with all the data in one column?

The program did not recognize the commas as column separators. In Excel or Google Sheets, use the "Text to Columns" feature (Excel) or "Split text to columns" feature (Google Sheets) to tell the program that commas separate the columns. This usually fixes the problem when ready.

Is CSV the same as a spreadsheet?

CSV is a file format. A spreadsheet is a program. You can open a CSV file in a spreadsheet program like Excel or Google Sheets, and it will display as a spreadsheet, but the CSV file itself is just plain text with commas separating the values.

Can I convert an Excel file to CSV?

Yes. Open the Excel file, then use "Save As" and choose CSV format from the dropdown menu. Keep in mind that any formulas, colors, or multiple sheets will be lost — only the data values will remain in the CSV file.

Why would someone send me a CSV file instead of just emailing me a spreadsheet?

CSV is smaller, works on any device, and does not require you to have Excel or any other paid software. It is also the standard format for moving data between different systems, so if the sender is exporting data from their system, CSV is usually what they get.