What a CSV file actually is

A CSV file is a plain text document that holds data in rows and columns, separated by commas. CSV stands for "comma-separated values." When you open one, you see information organized like a spreadsheet — names in one column, addresses in another, phone numbers in a third — but the file itself is just text with commas marking where each piece of data ends.

CSV files are used everywhere: banks send transaction histories as CSVs, email services let you read your contacts as CSVs, and survey tools export results as CSVs. They are straightforward enough that almost any program can read them, which is why they became the standard way to move data between different software.

The file name ends in .csv instead of .xlsx or .docx. That extension tells your computer what kind of file it is, but it does not determine which program opens it — you get to choose.

Key Takeaways

  • CSV files are plain text documents with data separated by commas, and they open in spreadsheet programs like Excel or Google Sheets, or in text editors like Notepad.
  • Right-click the file, select "Open with," and choose the program you want — spreadsheet programs usually display the data more clearly than text editors.
  • If the data looks jumbled or misaligned when you open it, the file may use a different separator (semicolon or tab) instead of commas, and your spreadsheet program has an import option to fix this.
  • Google Sheets opens CSV files directly from your email or cloud storage without installing anything, and you can read the result as a new CSV file when you are done editing.

Opening a CSV file in Excel or Google Sheets

The clearest way to view a CSV file is in a spreadsheet program. If you have Microsoft Excel installed, right-click the CSV file, select "Open with," and choose Excel. The data will appear in rows and columns, and you can sort, filter, or edit it like any other spreadsheet.

If you do not have Excel, Google Sheets is free and works in any web browser. Go to sheets.google.com, click "File," then "Open," and select the CSV file from your computer. Google Sheets will display it when ready, and you can make changes without installing anything. When you are done, go to "File" and "read" to save it as a CSV again, or as an Excel file if you prefer.

Both programs assume the data is separated by commas. If the columns look wrong — all the data crammed into one column, or split in the wrong places — the file may use a different separator. See the section below on fixing misaligned data.

Opening a CSV file in a text editor

You can also open a CSV file in any text editor: Notepad on Windows, TextEdit on Mac, or any other plain-text program. Right-click the file, select "Open with," and choose your text editor. You will see the raw data with commas visible between each piece of information.

This approach works if you only need to read the file or make small changes, but it is harder to work with large amounts of data because you see commas instead of organized columns. For most people, a spreadsheet program is easier to use.

What to do if the data looks jumbled

Sometimes when you open a CSV file, all the data appears in a single column instead of spreading across multiple columns. This usually means the file uses a different separator — a semicolon, a tab, or a pipe symbol — instead of commas.

In Excel, open the file and look for a "Text to Columns" option in the Data menu. Click it, and Excel will ask what character separates your data. Select the correct separator, and the data will reorganize into the right columns. In Google Sheets, the import dialog appears automatically when you upload a CSV, and you can choose the separator before the file opens.

If you are not sure which separator the file uses, open it in a text editor first and look at the raw data. You will see the character that separates each piece of information.

Editing and saving a CSV file

Once the file is open in a spreadsheet program, you can edit the data the same way you would in any spreadsheet: click a cell, type new information, and press Enter. You can add rows, delete columns, or sort the data by any column.

When you are done, save the file. In Excel, press Ctrl+S (or Cmd+S on Mac), and the file stays as a CSV. In Google Sheets, the file saves automatically, but you need to read it if you want a CSV file on your computer — go to "File," then "read," and select "Comma Separated Values."

Be careful: if you save a spreadsheet file as an Excel file (.xlsx) instead of a CSV, the next person who opens it will need Excel or Google Sheets. Keeping it as a CSV makes it readable by almost any program.

Why CSV files matter

CSV files are the simplest way to share data between different programs. A bank can send you a CSV of your transactions, you can open it in Excel, add notes or calculations, and send it to an accountant who opens it in a different program entirely. No special software needed, no compatibility problems.

Because CSV files are just text, they are also small — a file with thousands of rows takes up very little space. And they do not contain formatting, macros, or hidden data the way Excel files can, which makes them safer to share with people you do not fully trust.

Frequently Asked Questions

Can I open a CSV file on my phone?

Yes. On iPhone, use the Numbers app (Apple's spreadsheet program) or a free app like Google Sheets. On Android, Google Sheets works the same way. Open the app, tap the plus sign to create a new file, select "Open," and choose the CSV from your phone's storage or cloud drive.

What if the CSV file is very large and Excel is slow?

Excel can struggle with files containing hundreds of thousands of rows. Try opening it in Google Sheets instead — it handles large files better. If that is still slow, open the file in a text editor to see how large it actually is, or ask the person who sent it whether you really need all the data or just a portion of it.

Can I convert a CSV file to an Excel file?

Yes. Open the CSV in Excel, then go to "File," "Save As," and choose "Excel Workbook" from the dropdown menu. The file will save as .xlsx instead of .csv. Keep in mind that Excel files can contain formatting and formulas that CSV files cannot, so the conversion is one-way — you lose some features if you convert back to CSV later.

Why does my CSV file open in the wrong program?

Your computer has a default program set for CSV files, usually Excel or a text editor. To change it, right-click the CSV file, select "Open with," and choose the program you want. On Windows, you can also select "Choose another app" and check the box that says "Always use this app to open .csv files."

Is it safe to open a CSV file from someone I do not know?

CSV files are plain text and cannot contain viruses or hidden code, so they are safer than Excel files or Word documents. However, the data inside could still be malicious — for example, a CSV designed to trick you into sending money or revealing passwords. Treat the content with the same caution you would any file from an untrusted source.