How to Open a CSV File

What is a CSV file?

A CSV (Comma-Separated Values) file is a plain-text format that stores tabular data — like a spreadsheet, but readable in any text editor. Each line in the file is one row, and fields within a row are separated by commas. The first row is usually the header.

CSV is the lingua franca of data. Almost every database, analytics platform, e-commerce store and API supports it for import/export. The trade-off: a CSV stores only values. There are no formulas, no formatting, no multiple sheets — just rows and columns of text.

Tip: If you only need to view or share data, CSV is enough. If you need formulas or styling, convert it to Excel (.xlsx).

How to open a CSV file (5 ways)

The right method depends on what you want to do with the data. Here are the five most common options, ranked from fastest to most powerful.

1. Open a CSV file online (fastest)

The viewer at the top of this page opens any CSV instantly. Drop your file in, search and filter rows, and inspect column headers — all in your browser. Nothing is uploaded, so it’s safe even for sensitive data. This is the quickest way if you just need to see what’s in the file.

2. Open a CSV file in Excel

Double-click the .csv file. If Excel is installed, it opens automatically. If columns look squashed or jumbled, use Excel’s import wizard instead:

1. Open Excel and create a blank workbook.
2. Go to Data → From Text/CSV (or Data → Get Data → From File → From Text/CSV).
3. Pick your file. Excel previews it and lets you choose the delimiter (comma, semicolon, tab) and encoding (UTF-8 recommended).
4. Click Load.

The import wizard avoids the most common Excel-CSV problem: locale-mismatched delimiters. If your locale uses semicolons but the file uses commas, double-clicking ruins it.

3. Open a CSV file in Google Sheets

1. Go to sheets.new to start a new sheet.
2. Click File → Import → Upload and select your CSV.
3. Choose Replace spreadsheet and tick Convert text to numbers, dates and formulas if you want auto-typing.
4. Click Import data.

Google Sheets handles CSV encodings well and works on any device with a browser. Best when you need to share or collaborate.

4. Open a CSV file in Numbers (Mac)

On macOS, double-click the file or right-click → Open With → Numbers. Numbers is more forgiving than Excel with delimiters but slower on large files (> 50K rows). For anything bigger, use the online viewer above or LibreOffice Calc.

5. Open a CSV file in a text editor

Any plain-text editor — VS Code, Notepad, TextEdit, Sublime — will open a CSV. You’ll see the raw text with commas separating values. This is the best way to debug a broken CSV: you can spot encoding issues, stray quotes and inconsistent delimiters at a glance.

Why won’t my CSV open correctly?

If your CSV opens but everything looks wrong, one of these four issues is almost always the cause:

The delimiter doesn’t match your locale

In the US and UK, CSVs use commas. In France, Germany, Spain and most of Europe, Excel expects semicolons. Open the file in a text editor — if you see semicolons but Excel is jamming everything in one column, that’s why. Fix it with our free CSV delimiter converter.

The encoding is wrong

CSVs containing accents (é, ñ, ü), emoji, or non-Latin scripts must be saved as UTF-8. If you see strings like café rendered as café or Düsseldorf as Düsseldorf, the file is being read as Latin-1 but is actually UTF-8 (or vice versa). Re-save it in UTF-8 from a text editor.

Quotes and commas inside fields aren’t escaped

If a field contains a comma (e.g. "Smith, John") it must be wrapped in double quotes. Many spreadsheets export this correctly, but hand-written CSVs often don’t — leading to extra columns appearing partway through the file.

Line endings are inconsistent

CSVs from old Mac systems use \r (CR). Windows uses \r\n (CRLF). Unix/Linux uses \n (LF). Most modern tools handle all three, but some legacy importers choke. If only the first row appears, this is likely the cause.

CSV file format explained

The CSV format is defined loosely by RFC 4180, but in practice rules vary. Here’s what to expect:

• One record per line, terminated by a line break.
• Fields separated by a delimiter — typically a comma, but semicolons, tabs and pipes are common too.
• Optional header row as the first line, naming each column.
• Quoted fields for values containing the delimiter, line breaks, or quote characters. A literal quote inside a quoted field is escaped as "".
• UTF-8 encoding is the modern default, though older files may use Windows-1252 or Latin-1.

An example minimal CSV:

name,age,city
Ada Lovelace,36,London
"Smith, John",42,"New York, NY"
Linus,54,Helsinki

CSV vs Excel (.xlsx): which should you use?

Use CSV when moving data between systems. Use Excel when humans need to read or work with it. You can convert between them in seconds with JSON → Excel or by saving as the desired format.

Related tools

Frequently asked questions

• How do I open a CSV file?

  The fastest way is to drop the file into the viewer above — it opens instantly in your browser. You can also open CSV files in Excel, Google Sheets, Numbers (Mac) or any plain-text editor.

• What program opens CSV files by default?

  On Windows, double-clicking a .csv file usually opens it in Excel if Office is installed. On Mac, it opens in Numbers.

• Why does my CSV file open in one column?

  Excel uses your system locale's list separator. If the file uses commas but Excel expects semicolons (or vice versa), every row collapses into a single cell.

• Can I open large CSV files?

  Yes — the viewer above handles files up to ~100 MB smoothly. Excel caps at 1,048,576 rows.

• Is my file uploaded anywhere?

  No. The CSV is parsed locally in your browser using JavaScript. The file never leaves your device.

• How do I open a CSV with special characters (é, ñ, ✓)?

  Save or export the file as UTF-8. If your CSV looks garbled, the file is likely Latin-1 or Windows-1252 — re-save it as UTF-8 in a text editor.

• What's the difference between CSV and Excel (.xlsx)?

  CSV is plain text — only values, separated by commas. Excel files are zipped XML containing formatting, formulas, multiple sheets and cell types.