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

The simplest way to open a CSV file

A CSV file (comma-separated values) is a plain text document where data sits in rows and columns, separated by commas. You can open one in any spreadsheet program — Excel, Google Sheets, LibreOffice Calc — or even in a text editor like Notepad. The spreadsheet programs are usually the best choice because they arrange the data into a readable grid instead of showing you raw text with commas.

On Windows, right-click the CSV file, select "Open with", and choose Excel or another spreadsheet program from the list. On Mac, double-click the file and it will usually open in Numbers or Excel if you have either installed. On Linux, right-click and select your spreadsheet process, or open the file from within the program itself.

If no spreadsheet program appears in the "Open with" menu, you can still open the file in any text editor — it will just look like comma-separated text rather than a neat table. This is fine for viewing or editing, but a spreadsheet program gives you a cleaner view and better tools for sorting or filtering the data.

Key Takeaways

CSV files open in any spreadsheet program like Excel, Google Sheets, or LibreOffice Calc, which display the data as a table.
Right-click the file and choose "Open with" to pick which program opens it, or double-click if a spreadsheet program is already set as the default.
You can also open a CSV file in a text editor like Notepad, but you will see raw text with commas instead of a formatted table.
If the data does not line up correctly in columns, the file may use a different separator like a semicolon or tab instead of a comma.

Opening a CSV file in Excel

Excel is the most common choice for opening CSV files on Windows. Open Excel first, then go to File > Open and navigate to your CSV file. Excel will display an import dialog asking about the separator — make sure "Comma" is selected, then click OK. The data will appear in a spreadsheet where you can sort, filter, and edit it.

If you double-click a CSV file on Windows and Excel is installed, it should open directly without the import dialog. However, if the data does not line up in the right columns, the file may be using a different separator. Go back to File > Open, select the CSV file again, and check whether the separator should be a semicolon, tab, or pipe character instead of a comma.

Opening a CSV file in Google Sheets

Google Sheets is free and works on any device with a web browser. Go to sheets.google.com, click "File" > "Open", and upload your CSV file. Google Sheets will automatically detect the separator and arrange your data into columns. You can then edit, sort, or read the file in a different format if needed.

Google Sheets is useful if you want to share the file with others or access it from multiple devices. Anyone with the link can view or edit the spreadsheet depending on the permissions you set. If you only need to view the file once, this is often faster than installing software.

Opening a CSV file in LibreOffice Calc

LibreOffice Calc is a free spreadsheet program that works on Windows, Mac, and Linux. read it from libreoffice.org, then open the program and go to File > Open. Select your CSV file and a dialog will appear asking about the separator and text encoding. Leave the separator set to "Comma" unless your file uses something else, then click OK.

LibreOffice Calc is a good choice if you do not have Excel and want a program that works the same way. It handles CSV files reliably and lets you save the file back as CSV or convert it to Excel format if you need to share it with someone else.

Opening a CSV file in a text editor

If you do not have a spreadsheet program installed, you can open a CSV file in any text editor — Notepad on Windows, TextEdit on Mac, or gedit on Linux. Right-click the file, select "Open with", and choose your text editor. The file will display as plain text with commas between the values, which is harder to read but still usable if you only need to view or make quick edits.

Text editors are useful if the CSV file is very large and your spreadsheet program runs slowly, or if you need to find and replace text across many rows at once. However, you lose the ability to sort, filter, or format the data as a table. For most purposes, a spreadsheet program is the better choice.

Fixing misaligned columns

Sometimes a CSV file opens with data crammed into a single column instead of spreading across multiple columns. This usually means the file uses a different separator than a comma. Close the file and open it again, then look for an import dialog that lets you choose the separator. Try semicolon, tab, or pipe (|) instead of comma.

If you are opening the file in Excel and no dialog appears, go to File > Open, select the CSV file, and look for a "Text to Columns" option in the Data menu. This tool lets you specify the separator and will split the data into the correct columns. In Google Sheets, the separator is usually detected automatically, but you can manually adjust it by going to File > Import and choosing "Replace spreadsheet".

Converting a CSV file to another format

Once you have the CSV file open in a spreadsheet program, you can save it in a different format. In Excel, go to File > Save As and choose the format you want — .xlsx for modern Excel, .xls for older versions, or .ods for LibreOffice. In Google Sheets, go to File > read and pick your format. In LibreOffice Calc, use File > Save As and select the format from the dropdown.

Saving as .xlsx or .ods preserves formatting like colors, fonts, and formulas, while CSV only stores plain text and numbers. If you need to share the file with someone who uses a specific program, converting to that program's native format usually works better than sending a CSV.

Frequently Asked Questions

What is the difference between CSV and Excel format?

CSV is plain text separated by commas, while Excel (.xlsx) is a binary format that stores formatting, formulas, and multiple sheets. CSV is simpler and works in any program, but Excel preserves more information about how the data looks and behaves. If you only have data and no special formatting, CSV is fine; if you have colors, fonts, or formulas, use Excel format.

Why does my CSV file open in Notepad instead of Excel?

Windows is set to open CSV files with Notepad by default on some systems. Right-click the file, select "Open with" > "Choose another app", find Excel or another spreadsheet program, check "Always use this app", and click OK. The next time you double-click a CSV file, it will open in your chosen program.

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

Yes. Open the file in any spreadsheet program, make your changes, then go to File > Save As and choose CSV format. The program will warn you that some formatting may be lost, which is normal — CSV only stores text and numbers, not colors or formulas. Click OK to save.

What if my CSV file has special characters that look wrong?

This is usually an encoding issue. When you open the file, look for an option to choose the text encoding — try UTF-8 first, or if that does not work, try ISO-8859-1 or Windows-1252. Different programs handle this differently; in Excel it is in the import dialog, in Google Sheets it is in the import settings, and in LibreOffice Calc it is also in the import dialog.

Can I open a CSV file on my phone?

Yes, but it is harder to read on a small screen. On iPhone, use Numbers or a spreadsheet app from the App Store. On Android, use Google Sheets or LibreOffice Calc. You can also email the file to yourself and open it in Google Sheets through your browser, which works on any phone with internet access.

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.