How to Open a CSV File: Every Method, on Every Device (and How to Fix It When It Looks Wrong)

CodexFuse Team · 2026-10-27T00:56:52.153Z · 16 min read

Double-click it — but if the data looks wrong, import it instead. Every method for opening a CSV file in Excel, Google Sheets, on a Mac, or in your browser, plus the three fixes for mangled data.

Opening a CSV file should take five seconds: double-click it, and it opens in Excel. Most of the time, that is exactly what happens. But a CSV file is not a spreadsheet. It is a plain text file, and Excel has to guess how to turn that text into rows and columns. When the guess is wrong, your data lands in one long column, your product codes lose their leading zeros, and dates turn into something else entirely. This guide shows you how to open a CSV file on every device, which method to pick for your file, and the three fixes that rescue a file that looks wrong, in the order to try them. If you only need to peek at the contents without installing anything, a free CSV viewer opens the file in your browser.

How do I open a CSV file?

Double-click the file. If Excel, or Numbers on a Mac, is set as the default app for .csv files, it opens as a spreadsheet. If it opens in the wrong app, or the data looks wrong, open it from inside Excel instead: use Data > From Text/CSV, pick the file, check the preview, and set the delimiter and the column types before you load it. That import step is the difference between a file that opens and a file that opens correctly.

1. Make a copy of the file first. Keep the untouched export somewhere safe. Excel can change values the moment it opens a CSV, and a copy is the only way back.
2. Double-click the file. If the columns line up and the values look right, you are done.
3. If anything looks wrong, close it without saving and reimport the original with Data > From Text/CSV, where you control the delimiter, the encoding, and the column types.
4. Check the values before you save. Look at the ID columns, the dates, and any column that should start with a zero. Only then save your work, as a new .xlsx file or back to CSV.

What is a CSV file, exactly?

CSV stands for comma-separated values. A CSV file is a plain text file that stores a table: each line is one row, and commas separate the values inside the row. The first line usually holds the column labels. Because it is plain text, almost any program can read it, which is why banks, shops, survey tools, and contact apps all export to CSV. It stores no formatting, no formulas, and no multiple sheets, so when Excel opens one, it has to decide how to display the raw text as a table, and that decision is where things go wrong.

You can see the raw file for yourself. Right-click it and open it in Notepad on Windows or TextEdit on a Mac. What you see is the truth of the file: rows of text with commas between the values. If the raw text looks fine but Excel shows a mess, the file is fine and the opening method is the problem. That distinction saves a lot of re-downloading.

Method 1: Double-click the file

Double-clicking is the fastest way to open a CSV file, and it is the right choice when the data is simple. On Windows, double-clicking a .csv file opens it in Excel if Excel is the default app for that file type. On a Mac, it opens in Numbers or Excel, depending on your settings. Microsoft's own support page gives the same advice: you can double-click a CSV file in Windows Explorer to open it in Excel directly.

This method works well for plain data: names, plain numbers, short text. It fails silently on the tricky cases. Excel guesses the type of every value as it opens the file, and it guesses wrong on leading zeros, long ID numbers, and date-like text. A product code of 00123 becomes 123, and a 16-digit identifier can lose precision when Excel treats it as a number. If your file holds codes, SKUs, phone numbers, or long IDs, skip the double-click and use the import method below instead.

Method 2: Open the file from inside Excel

Opening from inside Excel is the middle ground: a little more control than double-clicking, without the full import wizard. In Excel, go to File > Open, choose All Files from the file-type filter next to the File name box, pick your CSV, and select Open. Microsoft documents exactly this route on its support page, and it is the right move when double-clicking sends the file to the wrong app, because you are telling Excel, not Windows, what to open.

The catch is that this method still lets Excel guess the data types. It solves the wrong-app problem, but not the mangled-values problem. If the file opens in the right app but the values are wrong, close it without saving and move on to the import method, which is the only one that lets you set the types before Excel touches the data.

Method 3: Import the file with full control

Importing is the method to use when the data matters. It is the only way to tell Excel the delimiter, the encoding, and the column types before it loads a single value. Open a blank workbook, go to Data > From Text/CSV, pick the file, and look at the preview. The preview shows you exactly how Excel will split the file, and you can fix it before anything is loaded.

Three settings decide whether the import comes out right. First, the delimiter: the character that separates the values. Most files use a comma, but European exports often use a semicolon, and some use a tab. If the preview shows everything in one column, the delimiter is wrong, so change it and watch the preview split into columns. Second, the file origin, or encoding: pick UTF-8 (file origin 65001) when accented letters or symbols look garbled, because the wrong encoding is what turns them into strange characters. Third, the column types: set any column that holds IDs, SKUs, ZIP codes, or phone numbers to Text before loading, so Excel keeps 001 as 001 instead of turning it into 1. Ecwid's support guide makes the same point for store owners: a SKU of 001 becomes 1 if the column is not set to Text, and the wrong SKU then goes back into the store on the next import.

One warning from the import guides is worth repeating: setting a column to Text after the file is already loaded does not bring the lost digits back. The zeros are gone the moment Excel converts the value. If that already happened, close the file without saving it, and reimport the untouched original with the column set to Text first.

How to open a CSV file in Google Sheets

If you do not have Excel, Google Sheets opens CSV files for free in the browser. Open a new blank spreadsheet, go to File > Import, choose Upload, and pick your CSV file. Sheets asks where to put the data and what separator to use, then loads it as a normal spreadsheet. FreshBooks describes the same flow: open a blank document, choose Import or Open, find the file, and it formats itself.

Sheets has one advantage over Excel here: it is less aggressive about rewriting your values, and it never touches the original file, because the import creates a new spreadsheet. The trade-off is that a very large file can be slow in the browser, and Sheets still needs the right separator if the file does not use commas. When the file is a bank export or a customer list, open it locally first, in Excel or in a browser-based viewer that reads the file on your machine, rather than uploading it to a random website.

How to open a CSV file on a Mac

On a Mac, double-clicking a CSV usually opens it in Numbers, Apple's spreadsheet app, which handles most files well. If you want Excel instead, right-click the file, choose Open With, and pick Excel for that one file. To make Excel the default for every CSV, select the file in Finder, choose File > Get Info, expand Open with, pick Microsoft Excel, and click Change All. That applies Excel to all .csv files, not just the one you selected.

Inside Excel for Mac, the import route is Data > Get Data (Power Query) > Text/CSV, which opens the same preview with the delimiter, encoding, and type controls. The Mac path differs from Windows in the menus, but the rules are identical: check the preview, set ID columns to Text, and keep a copy of the original.

How to open a CSV file in your browser

Sometimes you only need to look at the file, not edit it. A browser-based CSV viewer reads the file and shows it as a table, with no install and no spreadsheet app. CodexFuse's CSV viewer does this in the browser, and some online viewers, such as OnlineCSVViewer, process a local file in your browser without uploading it to a server. That local processing matters: a CSV from your bank, your shop, or your contacts holds real personal data, and it should not be uploaded to a site you do not trust just to take a look.

The browser route is also the answer for very large files. An Excel worksheet holds at most 1,048,576 rows and 16,384 columns, so a file bigger than that will not fit on one sheet at all. A viewer that streams the file can show you the first rows and let you search it without trying to load the whole thing into a grid.

Which method should you use?

Pick by what is in the file, not by habit. The table below is the whole decision: if the file is simple, double-click; if the values must stay exact, import.

If you are converting the file rather than just reading it, the same idea applies in reverse: our guide to convert JSON to CSV walks through the export side, and the JSON-to-CSV converter does the conversion in the browser. CSV sits in a small family of plain-text data formats, and the same open-and-fix thinking applies to its siblings: our guides to how to open a JSON file and how to open an XML file cover the same traps for those formats.

Why does my CSV file look wrong?

Almost every broken-looking CSV comes down to one of three causes, and they have a fixed order: check the delimiter first, then the encoding, then the data types. Guessing in the wrong order wastes time, because a delimiter problem looks like an encoding problem and a type problem looks like a broken file.

Three examples show how fast the damage happens. A SKU written as 001 in the file becomes 1 when Excel opens it directly, because Excel reads it as a number. A longer code, 000123, becomes 123 for the same reason. And a value like 01/02/2023 gets turned into a date in your local format, which may mean January 2 or February 1 depending on where you are. None of these are file errors. They are Excel doing exactly what it was told to do on a direct open, and the import method is the way to tell it otherwise. The file itself never changes unless you save over it, which is why the untouched copy matters so much.

How to save a CSV file back without breaking it

When you are done editing, you have two honest choices. If you need formulas, formatting, or multiple sheets, use File > Save As and pick Excel Workbook (.xlsx). Microsoft's own tip is to save the opened CSV as an .xlsx file that way, and the original CSV stays untouched. If the next step is importing the file back into a shop, a bank, or another system, save it as CSV again: File > Save As, choose CSV UTF-8 or CSV (Comma delimited) as the type, and click Save. Ecwid's guide gives the same steps, and warns to check the format warning Excel shows before it writes the file, because saving as CSV drops every workbook feature the text format cannot hold.

Renaming a file from .csv to .xlsx does not convert it. The extension is only a label; the contents are still plain text until a real save rewrites them. And never save over the original export until you have checked the values: once the zeros are gone from the saved file, the only recovery is another export.

How to make Excel the default app for CSV files

If your CSV files keep opening in Notepad or another app, change the file association once and the problem goes away. On Windows 11, open Settings > Apps > Default apps, search for .csv, and choose the installed desktop version of Excel. On Windows 10, the same page lists file types instead of a search box: scroll to .csv and pick Excel beside it. On a Mac, use Finder: select a CSV, choose File > Get Info, expand Open with, pick Excel, and click Change All.

Two things this change does not do. It does not convert a CSV into a workbook, and it does not protect the values inside the file from Excel's type guessing. A default app only decides which program opens the file; the import method still decides how the data is read. Set the default for convenience, and use the import for any file whose values must stay exact.

Sources

• Microsoft Support — "Open or import a CSV file" — File > Open with the All Files filter, double-click to open in Excel, and saving as XLSX via File > Save As. support.microsoft.com
• UMA Technology — "How to Open a CSV File in Excel" — double-click, File > Open, Text Import Wizard and From Text/CSV, UTF-8 file origin 65001, leading zeros dropped (000123 becomes 123), delimiter and encoding troubleshooting. umatechnology.org
• Solve Your Tech — "How to Open CSV Files With Excel by Default" (updated October 20, 2026) — Windows 11 and 10 default-app steps, Mac Get Info > Change All, 00123 becoming 123, 16-digit identifiers losing precision, the 1,048,576-row and 16,384-column worksheet limit, Power Query detecting types from the first 200 rows. solveyourtech.com
• Ecwid Support — "Opening and saving CSV files in Excel" — import via Data > From Text with Delimited and Text column format, SKU 001 becoming 1, saving as CSV UTF-8, delimiter types including comma, semicolon, tab, and pipe. support.ecwid.com
• FreshBooks — "What Is a CSV File? Learn How to Open, Edit & Create a CSV File" — double-click to open, and File > Import to open a CSV in Google Sheets or Google Docs. freshbooks.com
• How-To Geek — "What Is a CSV File, and How Do I Open It?" — viewing a CSV in Notepad, double-clicking to open in Excel, and opening in Google Sheets or LibreOffice Calc without Excel. howtogeek.com
• freeCodeCamp — "What is a CSV File and How to Open the CSV File Format" — CSV as a plain text file storing table data, first line as column labels, and opening via File > Open in a text editor or spreadsheet program. freecodecamp.org

Frequently asked questions

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

Because Notepad, or another app, is set as the default for .csv files on your computer. Right-click the file, choose Open with, and pick Excel for that one file. To fix it permanently, go to Settings > Apps > Default apps on Windows, search for .csv, and choose Excel; on a Mac, use Finder > Get Info > Open with > Change All. The file itself is fine; only the association is wrong.

Why is all my data in one column?

The file uses a different delimiter than Excel expected. A file that opens as one long column is almost always semicolon-delimited or tab-delimited, often from a European export. Close the file without saving, then reimport it with Data > From Text/CSV and choose the separator the file actually uses. Do not replace the commas in a text editor, and do not change your Windows list separator for one file.

Why did Excel remove the leading zeros from my codes?

Excel read the column as numbers when it opened the file directly, so 001 became 1 and 000123 became 123. Formatting the cells as Text afterwards does not bring the zeros back, because the original digits are already gone. Close the file without saving, reimport the untouched original with Data > From Text/CSV, and set the column to Text before loading.

Why do accented characters look like strange symbols?

The file's encoding does not match what Excel assumed. Reimport it with Data > From Text/CSV and set File Origin to UTF-8 (65001). If the file has no UTF-8 marker, Excel may need the choice made explicitly. Opening the file in a text editor and re-saving it with UTF-8 encoding is the other way to fix it.

Can I open a CSV file without Excel?

Yes. Upload it to Google Sheets with File > Import, open it in LibreOffice Calc, or use a browser-based CSV viewer that reads the file on your machine. For a bank export or a customer list, prefer a local option over uploading the file to a website you do not know, because the file holds real personal data.