What is a CSV file?

A CSV (Comma-Separated Values) file is a plain-text way of storing tabular data — rows of records separated by line breaks, with each column separated by a comma. The format dates back to the early 1970s and is still the lingua franca of data interchange: every spreadsheet, database, analytics tool and programming language speaks CSV. If the format itself is new to you, our complete guide to the CSV format covers the history, the RFC spec and the common gotchas.

Because a CSV file is just text, you don't need specialised software to open it — any text editor, any spreadsheet app, or any modern web browser can read it. The catch: raw text is not very useful for humans. You want the columns lined up, the ability to sort and search, and maybe a chart. That's what an online CSV viewer does.

Here's a tiny example:

name,age,city
John,25,New York
Mary,30,London
Koji,41,Tokyo

That's a valid CSV. Drop it in the box above and you'll see a clean 3-row table in under a second.

3 ways to open a CSV file

Option 1: Open it online (recommended)

The fastest and safest way to open a CSV on any device is an online viewer that processes the file locally. Drop your file on CSV Viewer Online and you get an interactive table instantly — sort, filter, edit cells, generate charts, or convert to Excel or JSON. Nothing is uploaded: the parsing happens in your browser with JavaScript, so the file never leaves your machine.

This also sidesteps the most common CSV headaches — Excel silently mangling leading zeros (ZIP codes, product SKUs), reformatting dates to your locale, or guessing the wrong delimiter. A purpose-built viewer renders the data as it is.

Option 2: Open it with Excel or Google Sheets

Excel is the default on Windows and Numbers is the default on macOS. Google Sheets works on any device with a browser and a Google account. These tools open CSVs fine, with three caveats worth knowing. (Got the reverse problem — an .xlsx workbook you want as CSV? Jump to the Excel to CSV converter.)

• They auto-format: dates, numbers with leading zeros, long IDs, scientific notation.
• They're slow on big files: Excel's practical ceiling is around 1 million rows per sheet, and it's sluggish long before that.
• Google Sheets requires upload: your file is copied to Google's servers.

To open a CSV in Excel: File → Open → pick the file. To open in Sheets: File → Import → Upload.

Option 3: Open it with a text editor

Notepad (Windows), TextEdit (Mac) and VS Code all open CSV files — but you get the raw text, not a table. This is useful when you need to inspect the exact bytes of the file (for encoding issues or to spot a broken row) but unhelpful for anything else.

How to open a CSV file on different devices

Open CSV on Mac

Drop the file onto csv-viewer.online in Safari, Chrome or Firefox. If you prefer a desktop app, double-click the file and it will open in Numbers by default; right-click → Open With → Microsoft Excel if you have Office installed.

Open CSV on Windows

Drag the file into Edge, Chrome or Firefox on csv-viewer.online. Or double-click to open in Excel (the default). Windows 11 users can also pin the viewer as a PWA for one-click access.

Open CSV on Linux

LibreOffice Calc handles CSVs well. For a lighter-weight, browser-only approach drop the file onto csv-viewer.online in Firefox or Chromium — no package install required.

Open CSV on iPhone or iPad

iOS Safari supports file uploads. Open csv-viewer.online, tap Upload, and pick the file from Files or iCloud. The viewer is fully responsive so you can scroll, sort and inspect rows on a phone.

Open CSV on Android

Same flow: open csv-viewer.online in Chrome, tap Upload, grant access, done. The table supports pinch-zoom, horizontal scrolling, and a sticky header row.

Why open CSV files online instead of with software?

Common issues when opening CSV files

My CSV file shows garbled characters (encoding issue)

If accents come out as é instead of é, you've hit an encoding mismatch. The file is probably UTF-8, but your viewer is guessing Windows-1252. CSV Viewer auto-detects encoding and also exposes an override if you need to force it.

My CSV file opens all in one column (delimiter issue)

In many European locales (France, Germany, Netherlands…) CSV means “semicolon-separated”, not comma-separated. Excel respects your system locale, so a French user opening an English CSV may see every row crammed into column A. Drop the file in CSV Viewer and the delimiter is auto-detected; you can also pick comma, semicolon, tab or a custom character.

My CSV file is too large to open in Excel

Excel caps each sheet at 1,048,576 rows, and it struggles well before that. A browser-based viewer with virtualized rendering handles multi-million-row files without loading them all into the DOM. Try it with your file.

I can't open a CSV file without internet

Once you load csv-viewer.online the first time, the page works offline for the current tab — all parsing is local. If you need truly offline access, open your CSV in VS Code (free), LibreOffice (free) or Numbers.

Frequently asked questions

Can I open a CSV file without Excel?

Yes. CSV files are plain text, so any web browser can open them through a free online CSV viewer like this one. You do not need Excel, Numbers or any other spreadsheet software installed.

Is it safe to open a CSV file online?

With CSV Viewer it is — your file never leaves your device. Parsing happens locally in your browser with JavaScript, so the data is not uploaded to any server. Avoid online viewers that require an upload if your CSV contains sensitive information.

How do I open a CSV file on Mac?

The fastest way is to drop the file into your browser on csv-viewer.online. Numbers and Excel can also open CSV files, but they may auto-format numbers, dates and leading zeros in ways you did not expect.

How do I open a CSV file on Windows?

Either double-click the file (Excel will open it by default) or drag it into your browser on csv-viewer.online. The browser method preserves the original formatting and works even when Excel is not installed.

Why does my CSV file show garbled characters?

That is an encoding mismatch — the file is probably UTF-8 but your viewer is treating it as Windows-1252 (or vice-versa). CSV Viewer auto-detects the encoding and renders accents and special characters correctly.

Why does my CSV open all in one column?

Your CSV probably uses semicolons (common in European locales) or tabs as separators instead of commas. CSV Viewer auto-detects the delimiter, and you can also override it manually.

What is the biggest CSV file I can open?

Because rendering is virtualized, files with hundreds of thousands of rows open smoothly on a modern laptop. The practical ceiling depends on your available RAM — Excel typically caps at ~1 million rows, the browser has no such limit.