A CSV file is a spreadsheet saved as plain text, and you can open it with almost any program on your computer

CSV stands for "comma-separated values." It is a spreadsheet format where each column is separated by a comma and each row is on a new line. When you open a CSV file, you will see data arranged in rows and columns — the same way you would see it in Excel or Google Sheets. The file itself is just text, so it opens in spreadsheet programs, text editors, and even some web browsers.

The easiest way to open a CSV file depends on what you want to do with it. If you just need to look at the data, you can double-click the file and it will open in your default spreadsheet program. If you need to edit it, work with it in a spreadsheet process like Excel, Google Sheets, or LibreOffice Calc. If you want to see the raw text underneath, you can open it in Notepad or any text editor.

Key Takeaways

  • Double-clicking a CSV file on Windows or Mac will open it in your default spreadsheet program, usually Excel or Numbers.
  • Google Sheets can open CSV files directly from your computer or from a link, and saves your changes without changing the original file format.
  • If a CSV file does not open correctly and columns appear jumbled, you can fix it by using the "Text to Columns" feature in Excel or the "Separator" option in Google Sheets.
  • You can open a CSV file in a text editor like Notepad to see the raw comma-separated data, which is useful if you need to understand how the file is structured.

Opening a CSV file on Windows

On Windows, right-click the CSV file and select "Open with." You will see a list of programs. Click on Excel, Google Sheets, or LibreOffice Calc. If you do not see these options, click "Choose another app" to find them. If you have Excel installed, you can also double-click the file and it will open automatically.

If the data looks wrong when it opens — for example, if all the information is crammed into one column instead of spreading across multiple columns — the program did not recognize the commas as separators. In Excel, select all the data, go to the "Data" tab, and click "Text to Columns." Choose "Delimited" and check the "Comma" box. Click "Finish" and the data will spread into the correct columns.

Opening a CSV file on Mac

On Mac, double-click the CSV file. It will open in Numbers (Apple's spreadsheet program) by default. If you want to open it in a different program, right-click the file, select "Open With," and choose Excel, Google Sheets, or another spreadsheet process from the list.

Numbers sometimes adds extra columns or changes the formatting when it opens a CSV file. If this happens, try opening the file in Google Sheets instead. Go to Google Drive, click "New," select "File upload," and choose your CSV file. Once it uploads, right-click it and select "Open with" > "Google Sheets." Google Sheets handles CSV formatting more reliably and will not change your original file.

Opening a CSV file in Google Sheets

Google Sheets is often the simplest option because it works the same way on any device and does not require you to install anything. Go to Google Drive, click the "New" button, and select "File upload." Find your CSV file on your computer and click "Open." Once the file uploads, right-click it and choose "Open with" > "Google Sheets."

You can also open a CSV file directly in Google Sheets by going to sheets.google.com, clicking "File," selecting "Open," and choosing "Upload." Google Sheets will automatically recognize the commas and place each value in the correct column. If you make changes and want to keep the file as a CSV, click "File," select "read," and choose "Comma Separated Values (.csv)."

Opening a CSV file on your phone

On an iPhone or Android phone, the easiest way is to use Google Sheets. Open the Gmail or Google Drive app, find the CSV file, and tap it. Google Sheets will open automatically. You can view and edit the data on your phone, though the small screen makes it harder to see all the columns at once.

If you receive a CSV file as an email attachment, you can tap it directly from the email. Your phone will ask which app to use. Select Google Sheets or a spreadsheet app if you have one installed. Some phones also have a built-in spreadsheet viewer that will open CSV files, though it usually only lets you view the data, not edit it.

When a CSV file does not open correctly

Sometimes a CSV file opens with all the data crammed into one column, or with strange characters scattered throughout. This usually means the program did not recognize the comma as the separator, or the file uses a different separator like a semicolon or tab.

In Excel, select all the data, go to "Data" > "Text to Columns," choose "Delimited," and check which character separates the columns (usually comma, but sometimes semicolon or tab). In Google Sheets, click "File" > "Import," select "Upload," choose your CSV file, and on the import screen you will see options to choose the separator. Select the correct one and click "Import."

If the file contains special characters or text in a language other than English, the program might display them incorrectly. This is usually a character encoding issue. Try opening the file in a text editor first to see if the raw text looks correct. If it does, the problem is with how the spreadsheet program is reading the file, and you may need to try a different program.

Opening a CSV file in a text editor

If you want to see the raw structure of a CSV file, you can open it in Notepad (Windows), TextEdit (Mac), or any text editor. Right-click the file, select "Open with," and choose Notepad or your preferred text editor. You will see the data as plain text with commas separating each value and line breaks separating each row.

This is useful if you need to understand how the file is organized, or if you want to make quick edits without opening a full spreadsheet program. However, text editors do not format the data into columns, so it is harder to read. For most purposes, opening the file in a spreadsheet program is more practical.

Frequently Asked Questions

What is the difference between a CSV file and an Excel file?

A CSV file is plain text separated by commas, while an Excel file (.xlsx) is a binary format that can contain formatting, formulas, and multiple sheets. Excel files are more complex and take up more space. CSV files are simpler and work in almost any program, but they do not preserve formatting or formulas.

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

Yes. Open the CSV file in Excel, Google Sheets, or another spreadsheet program, make your changes, and save it. In Excel, click "File" > "Save As," choose "CSV (Comma Delimited)" from the file type dropdown, and click "Save." In Google Sheets, click "File" > "read" > "Comma Separated Values (.csv)." The file will stay in CSV format.

Why does my CSV file open in the wrong program?

Your computer has a default program set for CSV files, usually Excel or Numbers. To change it, right-click the CSV file, select "Open with," choose the program you want, and check the box that says "Always use this app." From then on, that program will open CSV files automatically when you double-click them.

Can I open a CSV file without downloading it?

Yes, if the file is shared online. If someone sends you a link to a CSV file, you can often open it directly in Google Sheets by pasting the link into Google Drive's import tool, or by opening Google Sheets and using "File" > "Open" > "Paste a link." This works for files stored on Google Drive, Dropbox, or similar services.