CSV files open in spreadsheet programs, text editors, or online tools — which one you use 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. You can open one in Microsoft Excel, Google Sheets, Apple Numbers, or even Notepad. The simplest route is usually to double-click the file — your computer will open it in whatever spreadsheet program you have installed. If that does not work, or if you want to edit the raw text, you can right-click the file, choose "Open with", and pick a different program from the list.
The program you choose matters because it changes what you can do. A spreadsheet program like Excel shows the data in organized columns and lets you sort, filter, and calculate. A text editor like Notepad shows the raw commas and line breaks, which is useful if you need to check the file's structure or make small edits. Online tools like Google Sheets let you open and share the file without installing anything.
Key Takeaways
- Double-clicking a CSV file usually opens it in your default spreadsheet program, which is the fastest way to view and work with the data.
- If double-clicking does not work, right-click the file, select "Open with", and choose Excel, Google Sheets, Numbers, or a text editor.
- Spreadsheet programs display CSV data in columns and rows; text editors show the raw commas and structure.
- You can open CSV files on phones and tablets using spreadsheet apps like Excel Mobile, Google Sheets, or Numbers.
Opening a CSV file on Windows
On Windows, the fastest way is to double-click the CSV file. If you have Excel installed, it will open there automatically. If you do not have Excel, the file may open in a text editor like Notepad, which shows the commas and line breaks but is harder to read if the data has many columns.
If double-clicking does not work, or if you want to choose a different program, right-click the CSV file and select "Open with". A menu will appear showing programs on your computer. Choose Microsoft Excel, Google Chrome (which can open it in Google Sheets), or Notepad depending on what you want to do. If you do not see the program you want, click "Choose another app" to see more options.
If you do not have a spreadsheet program installed, you can download Google Chrome for free and use Google Sheets in your web browser. Upload the CSV file to Google Drive, right-click it, and select "Open with" > "Google Sheets". Google Sheets will convert the CSV into a spreadsheet you can edit and save.
Opening a CSV file on Mac
On Mac, double-clicking a CSV file usually opens it in Numbers (Apple's spreadsheet program) or Excel if you have it installed. If it opens in a text editor instead, you can switch programs by right-clicking the file, selecting "Open With", and choosing Numbers or Excel from the list.
If you want to use Google Sheets instead, upload the CSV file to Google Drive using your web browser. Right-click the file in Google Drive and select "Open with" > "Google Sheets". Google Sheets will format the data into columns and rows automatically.
To open a CSV file in a text editor on Mac, right-click the file, select "Open With", and choose TextEdit. Make sure to set the format to plain text before saving any changes — go to Format menu and select "Make Plain Text".
Opening a CSV file on your phone or tablet
On iPhone or iPad, you can open CSV files using the Excel app, Numbers app, or Google Sheets app. Download the app from the App Store if you do not have it. Open the app, tap the file browser, and navigate to where the CSV file is stored (usually in Files, iCloud Drive, or email). Tap the file to open it.
On Android, download Excel, Google Sheets, or another spreadsheet app from the Google Play Store. Open the app and use its file browser to find your CSV file. Tap it to open. If the file is in your email, you can usually tap it directly from the email to open it in your default spreadsheet app.
If you received the CSV file by email, you can often tap it directly in the email app and choose which program to open it with. This is usually faster than downloading the file first.
When a CSV file opens as gibberish or in the wrong format
If the CSV file opens with strange characters, line breaks in the wrong places, or all the data crammed into one column, the issue is usually the delimiter — the character that separates the columns. Most CSV files use commas, but some use tabs, semicolons, or pipes instead. Your spreadsheet program may have guessed wrong.
In Excel, open the file and go to the Data tab. Click "Text to Columns". A wizard will appear asking you to choose the delimiter. Select "Comma" if that is what the file uses, or try the other options until the preview shows the data in the correct columns. Click Finish to apply the change.
In Google Sheets, the import dialog usually asks you to choose the delimiter when you upload the file. Select the correct one from the dropdown menu before clicking Import.
Editing and saving a CSV file
You can edit a CSV file in any spreadsheet program. Make your changes, then save the file. In Excel, go to File > Save As and make sure the file format is set to "CSV (Comma delimited)" before saving. In Google Sheets, go to File > Download > Comma-separated values (.csv). In Numbers, go to File > Export To > CSV.
If you edit a CSV file in a text editor like Notepad, you can add or change data directly, but you need to keep the commas in place so the columns stay aligned. This is riskier than using a spreadsheet program because it is easy to accidentally delete a comma and break the file structure.
After you save a CSV file, the changes are permanent. If you want to keep the original, save a copy with a different name before making edits.
Using online tools to open CSV files
If you do not want to install software, you can open a CSV file in your web browser using Google Sheets, Microsoft 365 online, or other free tools. Upload the file to Google Drive, right-click it, and select "Open with" > "Google Sheets". The file will open in your browser and you can view, edit, and download it without installing anything.
Other online CSV viewers include Airtable, which lets you view and organize CSV data in a database-like format, and Papaparse, which is a free tool for converting and viewing CSV files. These tools are useful if you need to check a file quickly or share it with others without sending the file itself.
Frequently Asked Questions
What is the difference between CSV and Excel files?
A CSV file is plain text separated by commas; an Excel file (.xlsx) is a binary format that can store formatting, formulas, and multiple sheets. Excel files are larger and more complex. CSV files are simpler and work across more programs, but they lose formatting and formulas when you save them.
Can I open a CSV file in Word?
Word is not designed for CSV files and will not format them into columns. Use a spreadsheet program like Excel, Google Sheets, or Numbers instead. If you only have Word, you can copy the CSV data into a Word table, but this is slower and more error-prone than using a spreadsheet program.
Why does my CSV file open with all data in one column?
The spreadsheet program did not recognize the delimiter (usually a comma) that separates the columns. In Excel, use the Text to Columns feature under the Data tab and select the correct delimiter. In Google Sheets, choose the delimiter when you import the file.
Can I convert a CSV file to another format?
Yes. Open the CSV file in a spreadsheet program, then go to File > Save As or File > Download and choose a different format like .xlsx (Excel), .ods (OpenDocument), or .numbers (Apple). Each program has its own export options.
Is it safe to open a CSV file from an unknown source?
CSV files are plain text and cannot contain viruses, but they can contain malicious formulas if opened in Excel. If you do not trust the source, open the file in Google Sheets or a text editor instead, which will not execute formulas. Always check the file contents before opening if you are unsure.