CSV files open in spreadsheet programs like Excel, Google Sheets, or free alternatives like LibreOffice Calc

A CSV file is a plain-text document that stores data in rows and columns, separated by commas. When you open it, your computer needs a program that understands this format and can display the data in an organized way. The simplest route is usually the spreadsheet program you already have — or a free one if you don't.

The file itself doesn't care which program opens it. The same CSV will look identical in Excel, Google Sheets, or LibreOffice. The difference is in what you can do with it afterward: some programs let you edit and save changes, others are read-only, and some add features like sorting and filtering that make the data easier to work with.

Key Takeaways

  • CSV files are plain text and open in any spreadsheet program — Excel, Google Sheets, LibreOffice Calc, or even Apple Numbers.
  • On Windows, right-click the CSV file, select "Open with", and choose your spreadsheet program from the list.
  • On Mac, double-click the CSV file and it will open in your default spreadsheet program, or right-click to choose a different one.
  • Google Sheets lets you open a CSV directly from your computer without installing anything, and you can edit it online.
  • If the data looks jumbled after opening, the program may have misread the comma separators — use the "Text to Columns" or import wizard to fix it.

Opening a CSV file on Windows

Right-click the CSV file on your desktop or in File Explorer. A menu will appear. Select "Open with" and you'll see a list of programs installed on your computer. Look for Excel, Google Sheets, LibreOffice Calc, or any other spreadsheet program you have. Click the one you want to use.

If you don't see a spreadsheet program in the list, click "Choose another app" at the bottom. This opens a longer list of all programs on your computer. Scroll down to find one, or click "Look for another app on this PC" to browse manually. Once you pick one, the CSV will open in that program.

If you want the same program to always open CSV files, check the box that says "Always use this app to open .csv files" before clicking. After that, you can just double-click any CSV file and it will open automatically in your chosen program.

Opening a CSV file on Mac

Double-click the CSV file. Your Mac will open it in whatever spreadsheet program is set as the default — usually Numbers if you have it, or Excel if that's what you use. The file will appear in a spreadsheet view with your data organized in rows and columns.

If you want to open it in a different program, right-click the CSV file and select "Open With". A submenu will show the spreadsheet programs you have installed. Click the one you want. If you want that program to be the default for all CSV files going forward, select it and then click "Change All" when prompted.

Using Google Sheets to open a CSV without installing anything

Go to Google Sheets in your web browser (sheets.google.com). Click the "+" button to create a new spreadsheet. Then click "File" in the menu, select "Open", and choose the "Upload" tab. Click "Select a file from your computer" and find your CSV file. Google Sheets will import it and display it as a spreadsheet you can view and edit online.

This method is useful if you're on a computer that doesn't have a spreadsheet program installed, or if you want to work on the file from multiple devices. Your CSV stays on your computer — Google Sheets creates a copy in your Google Drive that you can edit. If you make changes and want to save them back as a CSV, click "File", then "Download", then "Comma-separated values (.csv)".

Fixing jumbled or misaligned data

Sometimes when you open a CSV, the data looks wrong — all the information might be crammed into one column instead of spread across multiple columns. This usually means the program didn't recognize the commas as separators. Most spreadsheet programs have a tool to fix this.

In Excel, select the column with the jumbled data. Click "Data" in the menu, then "Text to Columns". A wizard will appear. Make sure "Delimited" is selected, then check the box next to "Comma". Click "Finish" and the data will split into the correct columns. In Google Sheets, the import process usually handles this automatically, but if it doesn't, you can delete the sheet and re-upload the file — Google Sheets will ask you to confirm the separator before importing.

Understanding what you can and cannot do with a CSV

A CSV file is designed to hold data only — no formatting, no formulas, no colors or fonts. When you open it in a spreadsheet program, you can add those things, but if you save the file as a CSV again, all that formatting disappears. The CSV will only keep the raw data.

If you want to keep formatting, colors, or formulas, save the file in your spreadsheet program's native format instead. In Excel, that's .xlsx. In Google Sheets, it's a Google Sheet (which stays in Google Drive). In LibreOffice, it's .ods. You can always export to CSV later if you need to share the data with someone else or use it in a different program.

When to use each program

Excel is the standard choice if you have it — it handles large files well and has the most features for sorting, filtering, and analyzing data. Google Sheets is best if you need to share the file with others or work on it from different computers, since everything is stored online and you can give people permission to view or edit. LibreOffice Calc is a free alternative that works almost identically to Excel and runs on Windows, Mac, and Linux.

Apple Numbers (on Mac) is simpler and more visual than Excel, but it's less powerful for complex data work. Google Sheets in read-only mode is fine if you just need to look at the data and don't plan to change it. For very large CSV files (over 100,000 rows), specialized tools like R or Python may be faster, but for typical spreadsheets, any of these programs will work.

Frequently Asked Questions

Can I open a CSV file in Notepad or Word?

Yes, but you shouldn't. Notepad will show the raw text with commas visible, which is hard to read. Word will open it but may add unwanted formatting and can corrupt the file if you save it. Always use a spreadsheet program instead — it's designed to handle this format correctly.

Why does my CSV file have a .txt extension instead of .csv?

Some programs or websites save CSV files with a .txt extension by mistake. You can rename it: right-click the file, select "Rename", and change the extension from .txt to .csv. Then open it normally in your spreadsheet program. The file contents don't change — only the label does.

What if the CSV file won't open in any program?

The file may be corrupted or incomplete. Try opening it in a text editor like Notepad to see if the data is there. If you see gibberish or the file is very small, it may not have downloaded or saved correctly. Try downloading or exporting it again from wherever you got it.

Can I edit a CSV file and save the changes?

Yes. Open it in any spreadsheet program, make your changes, and save it. Make sure you save it as a CSV (not as Excel or another format) if you want to keep it as a CSV file. The program will warn you if you're about to lose formatting — click "Save as CSV" or "Use CSV Format" to proceed.

Is it safe to open a CSV file from an email or download?

CSV files are plain text and cannot contain viruses or malware on their own. However, they can be used to trick you — for example, a CSV that looks like a banking statement but is actually a phishing attempt. Open CSV files only from sources you trust, and be cautious if someone you don't know sends you one asking for personal information.