A CSV file is a plain-text spreadsheet that any program can read

CSV stands for "comma-separated values." It is a way to store data in rows and columns using only text — no special formatting, no hidden code, no proprietary software required. When you open a CSV file, you see information separated by commas, with each line representing one row of data.

The reason CSV exists is straightforward: it works everywhere. A CSV file created on a Mac opens the same way on Windows, on a phone, or on a Linux computer. You can open it in Excel, Google Sheets, Apple Numbers, or a basic text editor like Notepad. A bank can send you a CSV of your transactions. A government agency can send you a CSV of program data. A website can let you read your information as a CSV. Because the format is so plain and universal, nothing gets lost in translation.

CSV is not the fanciest format — it cannot store colors, formulas, or multiple sheets the way Excel can. But that plainness is exactly why it has survived for decades and why so many organizations still use it. When you need to move data from one place to another without losing anything, CSV is often the safest choice.

Key Takeaways

  • CSV files store data in rows and columns separated by commas, using only plain text that any program can read.
  • You can open a CSV file in Excel, Google Sheets, Notepad, or dozens of other programs without special software.
  • CSV files work the same way on Windows, Mac, phones, and any other device because they contain no hidden formatting.
  • Government agencies and banks often send data as CSV files because the format is straightforward, reliable, and loses no information during transfer.

How a CSV file looks when you open it

When you first open a CSV file in a text editor, you see something like this:

Name,Age,City,State Sarah,34,Portland,Oregon James,28,Denver,Colorado Maria,45,Austin,Texas

Each piece of information is separated by a comma. The first line usually contains the column headers — the names of the categories. Every line after that is one record. When you open that same file in Excel or Google Sheets, the program automatically recognizes the commas and arranges the data into a proper grid with columns and rows, even though the file itself is just plain text.

This is why CSV is so portable: the program reading the file does the work of organizing it. The file itself makes no assumptions about how it should look. A spreadsheet program makes it look like a spreadsheet. A database program can import it into a database. A statistics program can analyze it. The data stays the same; only the presentation changes.

When you will encounter CSV files

You are most likely to see CSV files when you read data from a website or receive information from a government or financial institution. A bank might let you read your transaction history as a CSV. A utility company might send you a CSV of your usage data. A government program might provide a CSV of public information — census data, housing statistics, or program locations.

You might also create a CSV yourself without realizing it. If you use Google Sheets or Excel and save your spreadsheet as a CSV instead of the program's native format, you are creating a CSV file. This is useful when you need to share data with someone who uses different software or when you want to move information from one program to another.

In housing and social services, CSV files are common because agencies need to share large amounts of data — lists of available programs, income limits, process important date — in a format that works everywhere. A nonprofit might read a CSV of housing resources from a government database, then import it into their own system to help clients.

The difference between CSV and Excel files

An Excel file (with the extension .xlsx) can do things a CSV cannot. Excel files can contain multiple sheets, formulas that calculate automatically, colored cells, merged cells, and special formatting. Excel files are also proprietary, meaning they are designed specifically for Microsoft Excel, though other programs can read them.

A CSV file is simpler. It contains only data — no formulas, no colors, no multiple sheets. If you open a CSV in Excel and add colors or formulas, then save it as an Excel file, those additions will not be there if you later save it back as CSV. The CSV format strips away everything except the raw data and the commas that separate it.

This simplicity is actually an advantage in many situations. If you need to move data between programs or share it with someone using different software, CSV is safer because nothing gets lost or corrupted. If you need fancy formatting and calculations, Excel is the better choice. For most data sharing, though, CSV is the standard.

How to open a CSV file

If you have a CSV file on your computer, you have several options for opening it. The simplest is to double-click it. Your computer will usually open it in Excel, Google Sheets, or whatever spreadsheet program you have installed. The file will appear as a grid of rows and columns, and you can read and edit the data just as you would in any spreadsheet.

If you want to see the raw text underneath — the commas and line breaks — you can right-click the file and choose "Open with" and select Notepad (on Windows) or TextEdit (on Mac). You will see the plain text version with commas separating each value. This is useful if you want to understand exactly how the data is structured or if you need to edit it in a way a spreadsheet program does not allow.

On a phone or tablet, you can open a CSV file with a spreadsheet app like Google Sheets or Microsoft Excel. You can also email yourself a CSV file and open it directly from the email attachment. The process is the same: the program recognizes the commas and arranges the data into a readable grid.

Why CSV is still used despite newer formats

Newer file formats exist — JSON, XML, and others — that can store more complex information and work better with modern software. But CSV has not disappeared because it solves a specific problem that those formats do not: it is readable by humans and machines alike, and it requires no special knowledge to understand.

If you open a JSON file in a text editor, you see code that looks like gibberish to most people. If you open a CSV file, you see data arranged in a way anyone can understand. This makes CSV ideal for situations where a human being might need to look at the file directly, or where the data needs to move between many different systems.

CSV is also extremely stable. The format has not changed in decades, and it will not change. A CSV file created in 1995 opens the same way today. This reliability makes it the default choice for government agencies, banks, and any organization that needs to store data in a way that will still work 20 years from now.

Frequently Asked Questions

Can I edit a CSV file?

Yes. You can open it in Excel, Google Sheets, or any spreadsheet program and edit the data just as you would any other spreadsheet. When you save it, make sure you save it as CSV format, not as an Excel file, or you may lose the ability to use it in other programs.

What does the file extension look like?

A CSV file ends with .csv — for example, "transactions.csv" or "housing_programs.csv". If you do not see the file extension on your computer, that is normal; your operating system hides it by default. The file is still a CSV regardless.

Is a CSV file safe to read?

CSV files themselves are safe — they contain only data, not code that can run on your computer. However, like any file from the internet, you should read CSV files only from sources you trust. If a website asks you to read a CSV, make sure it is a legitimate organization before you do.

Can I convert a CSV file to Excel?

You can open a CSV in Excel and then save it as an Excel file (.xlsx). This preserves the data and lets you add formatting, formulas, and multiple sheets. However, if you later save it back as CSV, all the formatting and formulas will be lost, leaving only the raw data.

What if my CSV file does not open correctly?

This usually happens when the data contains commas within the values themselves — for example, an address like "123 Main St, Apt 4". The program may get confused about which commas separate columns and which are part of the data. Try opening the file in a different program, or contact the organization that sent you the file for help.