CSV Viewer Options: What Opens 1M+ Rows Free

Two numbers decide which CSV viewer you need

Most guides list five ways to open a CSV and leave it there. A list on its own is not much help, because the routes are not interchangeable: some of them will refuse your particular file.

Two numbers settle it. The first is how many rows, or cells, the tool accepts. The second is whether the file is uploaded to someone else's server, and that matters the moment the data is confidential.

Work out those two before you pick an interface. A viewer you like is no use if it truncates your file at a million rows, and a fast converter is the wrong answer for a customer list you are not allowed to send anywhere.

What each route accepts, and where the file goes

Route	Size limit	File uploaded	Shows a table
Browser CSV viewer	Varies by tool — sakuttoAI reads the first 100,000 rows and shows 500	No	Yes
Excel	1,048,576 rows × 16,384 columns	No	Yes
Google Sheets	10 million cells or 18,278 columns	Yes	Yes
Text editor	No stated limit	No	No
VS Code	No stated limit	No	No, unless an extension adds one

Excel stops at 1,048,576 rows

Microsoft publishes the number: one worksheet holds 1,048,576 rows by 16,384 columns. A CSV larger than that does not fail loudly. It opens, fills the sheet, and leaves the remainder behind.

That silence is the danger. Someone who scrolls to the bottom sees a last row and reasonably assumes it is the last row of the file.

Two smaller limits trip people up as well. One cell holds 32,767 characters, and a column can be no wider than 255. Long free-text fields such as survey answers and pasted log lines hit those before the row count matters.

Google Sheets counts cells, not rows

Sheets allows up to 10 million cells or 18,278 columns, and Google says the same limits apply to CSV imports. That second clause is the one to remember, because it removes the guesswork about whether an import is treated differently.

Counting cells rather than rows changes which files fit. At ten columns wide, you get a million rows. At fifty, the same allowance runs out at 200,000.

The trade-off is that the file is uploaded to Google. For ordinary data, that is unremarkable, and Sheets gives you sorting and filtering at no cost. For anything covered by a confidentiality obligation, the second number decides instead.

A browser CSV viewer sends nothing

A viewer that runs inside the page reads the file with the browser's own file reader, so the data never travels. For confidential material, nothing else about the tool matters as much.

It also removes the install step. There is nothing to download, and the same page opens in Safari on a phone just as it does on a desktop.

What limits it is your own device rather than a published number. A large file is held in memory, so an old phone gives up sooner than a laptop does.

A text editor opens anything but shows no table

Notepad, TextEdit and VS Code will open a CSV of any size your machine can hold, because they treat it as plain text. No row limit applies, and nothing is uploaded.

The cost is that you see commas rather than columns. That is useful for one job — checking whether the delimiter is right, or whether a stray quotation mark broke a row — and close to useless for reading data. Reach for an editor to diagnose a file, then open it properly somewhere else.

Pick by row count first, then by confidentiality

Start with the size of the file, because that eliminates routes outright rather than making them less pleasant. A file of 30,000 rows opens anywhere, and the choice really does come down to taste; a file of two million opens almost nowhere.

If the file fits under 10 million cells and is not confidential, Google Sheets is the most capable free option, and it sorts and filters without setup. If it is confidential, use a viewer that runs in the browser, whatever the size. Past Excel's row limit, only a narrow file still fits in Sheets, and for anything wider the honest answer is to split it or query it rather than open it.

If the file will not display correctly at all, the problem is usually the encoding rather than the size. Garbled characters mean the file was written in one encoding and is being read as another, and converting it restores the text without altering a single value.

Summary

Choose a CSV viewer by arithmetic, not by preference. Count the rows, decide whether the file may leave your machine, and only then look at which interface you like.

The two published limits to remember are 1,048,576 rows for Excel and 10 million cells for Google Sheets. Both come from the vendors themselves, and both are worth rechecking before you plan around them.