What a CSV File Is and Why Your Programs Use It

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

CSV stands for Comma-Separated Values. It is a text file where data is organized into rows and columns, with commas marking where each column ends. When you open a CSV file in Excel, Google Sheets, or most other programs that handle data, the commas disappear and the information appears in a normal grid — but the file itself is just text with commas in it.

The reason CSV exists is simple: it works everywhere. A CSV file created on a Mac opens the same way on Windows. A program written in 1995 can still read a CSV file created today. Banks use CSV to send you transaction lists. Payroll systems use CSV to import employee data. Websites use CSV to let you download your information. Because CSV is just plain text with a standard format, no special software is required.

You have probably already used a CSV file without realizing it. When you download your bank statement as a spreadsheet, export your contacts from your phone, or save a mailing list from a website, you are often getting a CSV file.

Key Takeaways

CSV files are plain text organized into rows and columns, with commas separating each piece of data.
Any program that handles spreadsheets — Excel, Google Sheets, Numbers, or even Notepad — can open and read a CSV file.
CSV files have no formatting, colors, or formulas; they contain only the raw data itself.
When you download data from a website or export information from one program to use in another, CSV is the most common format used.

How a CSV file is structured

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

Name,Email,Phone Sarah Johnson,sarah@example.com,555-0142 Marcus Lee,marcus@example.com,555-0156 Diana Patel,diana@example.com,555-0189

Each line is a row. The commas separate the columns. The first row usually contains headers — the names of each column — and every row below it contains one record. In this example, you have three people, and for each person you have a name, an email address, and a phone number.

When you open this same file in Excel or Google Sheets, it automatically recognizes the commas and displays it as a proper table with four columns and four rows (including the header). The commas are still there in the file — the program just hides them from view and shows you a grid instead.

Why programs use CSV instead of other formats

You might wonder why companies do not just send you an Excel file directly. The answer is that CSV is more reliable across different systems. An Excel file (.xlsx) contains formatting instructions, formulas, colors, and other information that only Excel and similar programs understand. If you open an Excel file in an older program or on a different operating system, some of that information might not display correctly or might disappear entirely.

CSV strips away everything except the data. This makes it slower to corrupt, easier to move between systems, and may provide to work in any program that reads spreadsheets. It also makes CSV files much smaller than Excel files, which matters when you are downloading large datasets or sending files over the internet.

Government agencies, financial institutions, and healthcare systems often require CSV format for data transfers because it is the most universally compatible option. If a program needs to read data from many different sources, CSV is the safest choice.

Opening a CSV file on your computer

On Windows, right-click the CSV file and select Open with. You will see a list of programs. Choose Excel, Google Sheets, or any spreadsheet program you have installed. The file will open in a grid format and you can view, edit, or print it like any other spreadsheet.

On Mac, double-clicking a CSV file usually opens it in Numbers (Apple's spreadsheet program) or Excel if you have it installed. If it opens in a text editor instead and shows commas everywhere, right-click the file, select Open With, and choose a spreadsheet program from the list.

If you do not have a spreadsheet program installed, you can open a CSV file in Google Sheets for free by going to sheets.google.com, clicking File, then Open, and selecting the CSV file from your computer. Google Sheets will format it automatically.

Editing and saving a CSV file

You can edit a CSV file in any spreadsheet program. Add rows, change data, delete columns — it works like any other spreadsheet. When you save it, make sure you save it as CSV format, not as Excel or another format. Most programs will ask you to confirm the format when you save.

If you edit a CSV file in a spreadsheet program and then save it as Excel format by mistake, it will no longer be a CSV file. The next person who tries to import it into a different system might run into problems. Always check the file format before saving, especially if you are preparing data to send to someone else or to upload to a website.

One important note: CSV files cannot store formatting like bold text, cell colors, or formulas. If you format a spreadsheet in Excel and then save it as CSV, all that formatting disappears. The data remains, but the visual styling does not.

Common problems when working with CSV files

The most common issue is when your data contains commas. If a person's name is "Smith, John" and you save it in a CSV file, the comma in the name can confuse the program reading it. Most programs handle this by putting quotation marks around fields that contain commas — so it becomes "Smith, John" in the file — but not all programs recognize this correctly.

Another frequent problem is encoding. If your CSV file contains special characters like accented letters or symbols from other languages, different programs might display them differently depending on how the file was created. This usually only matters if you are moving data between very old systems or between different countries.

A third issue happens when you open a CSV file in Excel and the program tries to be helpful. Excel sometimes reformats numbers or dates automatically — turning "001234" into "1234" or changing date formats without asking. If you need to preserve the exact format of your data, open the CSV in Google Sheets or a text editor instead.

CSV versus other file formats

You might encounter other spreadsheet formats. XLSX (Excel format) contains formatting and formulas but requires Excel or a compatible program. ODS (OpenDocument Spreadsheet) is similar to XLSX but is the standard format for open-source programs like LibreOffice. TSV (Tab-Separated Values) works exactly like CSV except it uses tabs instead of commas — it is less common but appears in some scientific and technical datasets.

For most everyday purposes, CSV is the format you will encounter. It is the standard for downloading data from websites, exporting contacts, and transferring information between programs. If a website or program offers you a choice of formats, CSV is almost always the safest option because it works everywhere.

Frequently Asked Questions

Can I open a CSV file in Microsoft Word?

Technically yes, but you should not. Word will display the commas and the data will look like a jumbled list, not a proper table. Use Excel, Google Sheets, or any spreadsheet program instead. If you do not have one installed, Google Sheets is free and works in your web browser.

What happens if I double-click a CSV file and it opens in Notepad?

Your computer is set to open CSV files with a text editor by default. Right-click the file, select Open with, and choose Excel, Google Sheets, or another spreadsheet program. You can also set that program as the default so CSV files always open in a spreadsheet from now on.

Can I convert a CSV file to Excel format?

Yes. Open the CSV file in Excel or Google Sheets, then use File and Save As to save it as an .xlsx file. Keep in mind that if you add formatting like colors or formulas, those will be preserved in Excel format but would disappear if you converted back to CSV.

Is a CSV file safe to download from the internet?

CSV files are text files and cannot contain viruses or malware. However, always download from trusted sources. If you download a CSV file from an unknown website or an unexpected email, scan it with your antivirus program before opening it, just as you would with any file.

Why does my CSV file look wrong when I open it in Excel?

Excel sometimes misinterprets the data — for example, treating a column of numbers as dates or reformatting leading zeros. Open the file in Google Sheets instead, or open Excel first and use File > Open to import the CSV file, which gives you more control over how each column is interpreted.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.