How to Open a CSV File on Windows, Mac, or Online

CSV files open in spreadsheet programs, text editors, or your web browser — the right choice depends on what you need to do with the data

A CSV file (comma-separated values) is a plain-text document where data sits in rows and columns, separated by commas. Your computer does not know which program to use by default, so you have to choose one. If you want to view or edit the data in a grid, use a spreadsheet program like Microsoft Excel or Google Sheets. If you just need to read it quickly or make small changes, a text editor works. If the file is small and you do not have spreadsheet software installed, opening it in your browser is the fastest route.

The method you choose depends on what you plan to do next. If you need to share the file with others or work on it from different devices, Google Sheets saves automatically to the cloud. If you need formulas or advanced formatting, Excel or Numbers is better. If you just want to peek at the raw data or make a quick fix, a text editor is fastest.

Key Takeaways

CSV files are plain text and open in spreadsheet programs (Excel, Google Sheets), text editors (Notepad, TextEdit), or web browsers without any special software.
Double-clicking a CSV file usually opens it in Excel on Windows or Numbers on Mac, but you can right-click and choose a different program if you prefer.
Google Sheets opens CSV files directly from your computer or from a link, and saves your changes to Google Drive automatically.
Text editors like Notepad or TextEdit show the raw comma-separated data and work when you need to make quick edits without formatting.
Some CSV files use semicolons or tabs instead of commas as separators, which can cause columns to misalign in spreadsheet programs.

Opening a CSV file in Microsoft Excel on Windows

On Windows, double-clicking a CSV file usually opens it in Excel automatically. If it does, the data appears in columns and rows, ready to view or edit. If it opens in Notepad instead, close that window and try a different method.

To open a CSV file manually in Excel, launch Excel first, then go to File > Open. Navigate to the folder where your CSV file sits, select it, and click Open. Excel may show an Import Wizard window asking how to separate the columns — usually the default settings work, but if your data looks misaligned, check that Comma is selected as the delimiter.

If you want to change which program opens CSV files by default, right-click the CSV file, select Open with, choose Excel, and check the box that says Always use this app to open .csv files. After that, double-clicking any CSV file will open it in Excel.

Opening a CSV file on Mac

On Mac, double-clicking a CSV file usually opens it in Numbers (Apple's spreadsheet program). The data appears in a grid, and you can view or edit it the same way you would in Excel. If it opens in TextEdit instead, close that and try again — sometimes the first attempt fails.

To open a CSV file manually in Numbers, launch Numbers, go to File > Open, find your CSV file, and click Open. Numbers may ask how to separate the columns — leave the default settings unless your data looks wrong. If you prefer to use a different program, right-click the CSV file, select Open With, and choose the program you want. To make that program the default, select it, then click Change All.

Opening a CSV file in Google Sheets

Google Sheets is free and works in any web browser, so you do not need to install software. Go to sheets.google.com, click + New, and select File upload. Choose your CSV file from your computer, and Google Sheets opens it in a new spreadsheet. Your data appears in columns and rows, and any changes you make save automatically to your Google Drive.

You can also open a CSV file directly from Google Drive. Sign in to your Google account, go to drive.google.com, right-click your CSV file, and select Open with > Google Sheets. The file opens in a new tab, ready to view or edit. One advantage of Google Sheets is that you can share the file with others and work on it together in real time. If you only need to view the data and do not plan to edit it, this is the fastest option if you already have a Google account.

Opening a CSV file in a text editor

Text editors like Notepad (Windows) or TextEdit (Mac) show the raw CSV data as plain text, with commas separating each column. This works if you want to make quick edits without opening a full spreadsheet program, or if you need to see exactly how the data is formatted.

On Windows, right-click your CSV file, select Open with, and choose Notepad. On Mac, right-click the file, select Open With, and choose TextEdit. The file opens showing all the commas and line breaks. You can edit the text directly, but remember that any changes you make must follow CSV format — each row on a new line, columns separated by commas. Text editors are useful for troubleshooting when a CSV file does not open correctly in a spreadsheet program. You can see whether the separator is actually a comma, semicolon, or tab, and whether there are any hidden characters causing problems.

Fixing misaligned columns in a CSV file

Sometimes a CSV file opens with all the data crammed into a single column instead of spreading across multiple columns. This usually means the spreadsheet program is not recognizing the separator — the character that marks where one column ends and the next begins.

In Excel, select all the data, go to Data > Text to Columns. A wizard appears asking what separator the file uses. Check Comma, Semicolon, or Tab depending on your file, and click Finish. The data should spread across the correct columns. In Google Sheets, the file usually separates correctly on its own, but if it does not, you can use the SPLIT function to divide the data. In Numbers on Mac, select the column, go to Format > Cells, and check the delimiter settings.

If you are not sure which separator your file uses, open it in a text editor first and look at the first row. If you see commas between the values, the file uses commas. If you see semicolons or tabs, that is your separator.

Frequently Asked Questions

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

A CSV file is plain text with no formatting, formulas, or colors — just data separated by commas. An Excel file (.xlsx) can contain formulas, multiple sheets, colors, and other formatting. CSV files are smaller and work in any program, but Excel files preserve more information about how the data is organized.

Can I edit a CSV file and save it?

Yes. Open it in Excel, Google Sheets, or a text editor, make your changes, and save. If you use a spreadsheet program, make sure you save it as a CSV file (not as .xlsx or .numbers) so the changes stay in CSV format. In Excel, go to File > Save As, choose CSV (Comma delimited) from the file type dropdown, and click Save.

Why does my CSV file open with all data in one column?

The spreadsheet program is not recognizing the separator between columns. Use the Text to Columns feature in Excel or the SPLIT function in Google Sheets to fix it. First, open the file in a text editor to confirm whether it uses commas, semicolons, or tabs as separators.

Do I need special software to open a CSV file?

No. CSV files open in any spreadsheet program (Excel, Google Sheets, Numbers), any text editor (Notepad, TextEdit), or any web browser. You likely already have at least one of these on your computer.

Can I open a CSV file on my phone?

Yes. On iPhone, use the Numbers app or Google Sheets (both free from the App Store). On Android, use Google Sheets or Microsoft Excel (both free from the Google Play Store). Open the app, find the option to open or import a file, and select your CSV file from your phone's storage.

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.