CSV files open in spreadsheet programs, but the method depends on which program you have and what you want to do with the data
A CSV file is a plain text document where data sits in rows and columns, separated by commas. Your computer does not know it is a spreadsheet — it just sees text. When you double-click a CSV file, your operating system has to guess which program should open it. That guess is often wrong for what you need to do.
The fastest way to open a CSV file is usually to right-click it, choose "Open with", and pick a spreadsheet program from the list. On Windows, that is usually Excel or the free LibreOffice Calc. On Mac, it is usually Numbers or Excel. On Linux, it is LibreOffice Calc or Gnumeric. If you do not see a spreadsheet program in the menu, you can read one for free.
The reason the method matters is that some programs will mangle your data on import — turning a column of numbers into text, or breaking apart cells that contain commas. Knowing how to control the import process means your data stays intact.
Key Takeaways
- Right-click the CSV file and select "Open with" to choose which program opens it, rather than letting your computer guess.
- Excel, Numbers, LibreOffice Calc, and Google Sheets all open CSV files, but they handle commas and special characters differently during import.
- Most spreadsheet programs show you an import dialog where you can tell the program which character separates your columns — usually a comma, but sometimes a semicolon or tab.
- If a CSV file opens in Notepad or another text editor instead of a spreadsheet, you can still copy the text and paste it into a spreadsheet program.
Opening a CSV file in Excel on Windows
Open Excel first, then go to File > Open and navigate to your CSV file. This method gives you the most control over how Excel reads the data. When you select the file, Excel will show you an import dialog called "Text Import Wizard".
In the wizard, you will see three steps. Step 1 asks what character separates your columns — this should already be set to "Comma" if your file is a true CSV. Step 2 shows you a preview of how your data will look. Step 3 lets you set the format for each column (text, number, date, and so on). Most of the time you can just click Finish, but if you see numbers that look wrong or dates that are broken, this is where you fix it.
If you double-click a CSV file and it opens in Excel without showing the wizard, the import already happened and you may not be able to undo formatting mistakes. That is why opening Excel first is safer.
Opening a CSV file in Google Sheets
Go to sheets.google.com, click "File" > "Open", and search for your CSV file if it is stored in Google Drive. If the file is on your computer, click "Upload" and drag the CSV file into the box.
Google Sheets will import the file automatically and show you the result. If the import went wrong — for example, if all your data ended up in a single column — you can undo it and try again. Google Sheets is less likely to mangle data than Excel because it assumes everything is text until you tell it otherwise.
One advantage of Google Sheets is that you can share the file with others and work on it together without sending files back and forth. When you are done, you can read it as a new CSV file, an Excel file, or leave it in Google Sheets.
Opening a CSV file in Numbers on Mac
Open Numbers, go to File > Open, and select your CSV file. Numbers will show you an import dialog. Make sure "Comma" is selected as the delimiter (the character that separates columns). Click "Continue" and Numbers will create a new spreadsheet with your data.
Numbers handles CSV imports more carefully than some other programs — it usually preserves text that looks like numbers and does not try to convert it. If you need to move the data to Excel later, you can export it as an Excel file or CSV.
What to do if the CSV file opens in Notepad or a text editor
If you double-click a CSV file and it opens in Notepad, Notepad++, or another text editor instead of a spreadsheet program, your computer does not have a default spreadsheet program set. You can still get the data into a spreadsheet — it just takes one extra step.
Select all the text in the editor (Ctrl+A on Windows, Command+A on Mac), copy it (Ctrl+C or Command+C), then open your spreadsheet program and paste it into a blank sheet. The spreadsheet program will usually recognize the commas and split the data into columns automatically. If it does not, you can use the "Text to Columns" feature in Excel or the equivalent in your spreadsheet program.
Fixing common import problems
If your CSV file has data that looks wrong after import — numbers stored as text, dates showing as numbers, or text split across multiple columns — the problem usually happened during import. In Excel, you can select the column and use "Text to Columns" under the Data menu to re-import just that column and choose the right format.
If your CSV file contains commas inside the data itself (for example, an address like "123 Main St, Apt 4"), those commas should be protected by quotation marks in the file. A proper CSV file will show that address as "123 Main St, Apt 4" with quotes around it. Most spreadsheet programs recognize this and do not split it into separate columns. If your program does split it, the CSV file itself may be malformed, and you should contact whoever created it.
If you see strange characters or symbols after import, the CSV file may have been saved in a different character encoding (like UTF-8 or Latin-1). This is rare with modern programs, but if it happens, try opening the file in a text editor, checking what encoding it uses, and re-saving it in UTF-8 before importing again.
Setting a default program to open CSV files
On Windows, right-click a CSV file, select "Open with" > "Choose another app", pick your spreadsheet program, and check the box that says "Always use this app to open .csv files". From then on, double-clicking a CSV file will open it in that program.
On Mac, right-click a CSV file, select "Open With", pick your spreadsheet program, and click "Change All". This sets the default for all CSV files on your computer.
On Linux, right-click a CSV file, select "Properties" or "Open With", choose your spreadsheet program, and look for an option to set it as default. The exact steps vary by desktop environment.
Frequently Asked Questions
Can I open a CSV file in Google Docs instead of Sheets?
Google Docs is a word processor, not a spreadsheet program, so it will not format your data into columns. You can paste CSV data into Docs and it will appear as plain text, but you will lose the structure. Use Google Sheets instead — it is designed for this and is free.
What is the difference between CSV and XLSX?
CSV is plain text with commas between columns. XLSX is Excel's native format and can store formatting, formulas, colors, and multiple sheets. CSV is simpler and works in almost any program. XLSX is better if you need to save formulas or complex formatting. You can convert between them by opening one format and saving as the other.
Why does my CSV file look like one long column when I open it?
The file probably uses a different delimiter — semicolons or tabs instead of commas. Open the file with the import dialog (File > Open in your spreadsheet program, not double-click), and change the delimiter from comma to semicolon or tab. The data should split into columns correctly.
Can I edit a CSV file and save it back as CSV?
Yes. Open it in your spreadsheet program, make your changes, and go to File > Save As. Choose CSV as the file format. Your spreadsheet program will warn you that you are losing formatting — that is normal and expected. Click "Save" and the file will be saved as plain text with commas.
What if I need to send a CSV file to someone but they use a different program?
CSV is the most universal format — almost every spreadsheet program on every operating system can open it. Send the CSV file as-is. If the person needs it in a different format (like Excel), you can open the CSV, save it as XLSX or ODS, and send that instead. Ask them what format they prefer.