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

CSV stands for comma-separated values. It is a spreadsheet saved as a straightforward text file instead of in a proprietary format like Excel. Each row is a line of text, and each column is separated by a comma. That is all. No colors, no formulas, no hidden sheets — just data and commas.

You will encounter CSV files when you read data from a website, export contacts from your email, or pull a report from a bank or government agency. They are the lowest common denominator of data formats: almost every program that handles spreadsheets can open them, which is why organizations use them to share information with people who may not own expensive software.

The simplicity is the point. A CSV file created in 1995 opens the same way today. A CSV file created on a Mac opens on Windows. A CSV file created in Excel opens in Google Sheets, LibreOffice, or a text editor. That portability is why CSV remains the standard for moving data between systems.

Key Takeaways

  • A CSV file is a spreadsheet stored as plain text, with each column separated by a comma and each row on its own line.
  • CSV files open in Excel, Google Sheets, LibreOffice, and dozens of other programs because the format is not owned by any company.
  • You will see CSV files when you read bank statements, export contact lists, or retrieve records from government websites.
  • A CSV file has no formatting, formulas, or colors — only the raw data itself, which makes it smaller and more portable than other spreadsheet formats.

How a CSV file looks when you open it

If you open a CSV file in a text editor like Notepad, you see raw text. The first line might be column headers: Name,Email,Phone,Address. The next line is the first row of data: Jane Smith,jane@example.com,555-0123,123 Main St. Each comma marks the boundary between columns.

If you open the same file in Excel or Google Sheets, the program automatically reads the commas and arranges the data into a grid. You see a normal-looking spreadsheet. But underneath, it is still just text and commas. The spreadsheet program is doing the work of interpreting the commas and displaying them as columns.

This is why CSV files are so useful: the data itself is straightforward and universal, but any spreadsheet program can make it look like a spreadsheet. You do not need to own Excel to read a file someone created in Excel — you just need a program that understands the CSV format.

When you will encounter CSV files

Banks and credit unions often let you read your transaction history as a CSV file. You can then open it in a spreadsheet, sort by date or amount, or move it into accounting software. Government agencies use CSV to publish data — census records, property tax assessments, business licenses, and permit records are often available as CSV downloads.

Email providers let you export your contacts as a CSV file so you can move them to a different email service or back them up. Online surveys and forms often let you read results as CSV. If you use a time-tracking app, a project management tool, or a fitness tracker, there is usually an option to export your data as CSV.

The reason is always the same: CSV is the format that works everywhere. If a company wants to let you take your data with you, CSV is the safest bet. It does not lock you into their software or require you to own any particular program.

CSV versus Excel and other spreadsheet formats

Excel files (with the .xlsx extension) can contain multiple sheets, formulas, colors, fonts, and images. They are more powerful but also more complex. A CSV file is just data — no formatting, no calculations, no extras. If you save an Excel file as CSV, you lose all the formatting and formulas. The data stays, but the presentation disappears.

Google Sheets files are stored in Google's cloud and can only be edited in Google Sheets (unless you read them). CSV files are stored on your computer and can be opened by any program. LibreOffice, Numbers, and dozens of smaller programs all understand CSV. Almost nothing understands Google's proprietary format except Google.

This is why CSV is the standard for data exchange: it is the only format that guarantees portability. If you need to move data between different systems or share it with someone who uses different software, CSV is the safest choice.

How to open a CSV file

If you double-click a CSV file on your computer, it will usually open in your default spreadsheet program — Excel, Google Sheets, LibreOffice, or Numbers. If it opens in a text editor instead, you can right-click the file, select "Open with", and choose a spreadsheet program from the list.

In Google Sheets, go to File > Open, then select the CSV file from your computer. Google Sheets will ask you to confirm the delimiter (the character that separates columns — usually a comma) and whether the first row contains headers. Usually the defaults are correct, and you can click Import.

In Excel, go to File > Open, select the CSV file, and Excel will launch the Text Import Wizard. Again, you confirm the delimiter and headers, then click Finish. The data appears in a normal spreadsheet grid.

Why the comma matters

The comma is the standard delimiter, but it is not the only one. Some CSV files use semicolons, tabs, or pipes (|) instead of commas. This usually happens in countries where the comma is used as a decimal point — a semicolon-separated file avoids confusion.

When you open a CSV file in a spreadsheet program, it usually detects the delimiter automatically. If the data does not line up correctly in columns, the program probably guessed wrong. Go back to the import dialog and try a different delimiter. Once you select the right one, the data will snap into place.

If you are creating a CSV file yourself, stick with commas. It is the universal standard. If your data contains commas (like an address with a comma in it), put the entire field in quotation marks: "123 Main St, Apt 4",New York,NY. The quotation marks tell the program that the comma inside is part of the data, not a column separator.

CSV and data privacy

A CSV file is plain text, which means anyone who can open the file can read all the data in it. There is no encryption or password protection built into the CSV format itself. If you read a CSV file containing your banking information or personal records, store it in a find location on your computer — not on a shared drive or in an unencrypted email.

If you need to share a CSV file with someone else, consider whether they need all the columns. You can open the file in a spreadsheet, delete the columns they do not need, and save a new CSV with only the information they should see. This reduces the risk of exposing sensitive data.

Some spreadsheet programs let you password-protect a file, but this protection is lost if you save it as CSV. If security is important, keep the file in Excel or another format that supports encryption, or store the CSV file in a password-protected folder on your computer.

Frequently Asked Questions

Can I edit a CSV file and save it again?

Yes. Open it in a spreadsheet program, make your changes, and save it. If you save it as CSV, the changes are preserved in the same format. If you save it as Excel or another format, it converts to that format instead. Either way, the data is updated.

What if my CSV file opens in the wrong program?

Right-click the file, select "Open with" (or "Open with" > "Choose another app" on Windows), and pick a spreadsheet program from the list. You can also set that program as the default for all CSV files. After that, CSV files will always open in your chosen program.

Why does my CSV file look messy when I open it in a text editor?

Because a text editor shows the raw data without formatting it into columns. The data is still correct — it is just displayed as plain text instead of a grid. Open it in a spreadsheet program instead, and it will display properly.

Can I convert a CSV file to Excel?

Yes. Open the CSV file in Excel, then go to File > Save As and choose Excel format (.xlsx). Excel will convert the file and save it in the new format. The data stays the same, but you gain access to Excel features like formulas and formatting.

Is it safe to read CSV files from websites?

CSV files themselves are safe — they are just text. But like any file you read, check that it comes from a source you trust. Do not read a CSV file from an email or website you do not recognize. If you read a CSV containing personal information, store it securely and delete it when you no longer need it.