Back to the blog

Files

Reading a large CSV file.

A CSV of up to a million rows opens in your browser, shown a screen at a time, its separator found by itself; nothing is uploaded.

By 2 min read

The CSV and Excel viewer: a table of towns sorted by population, with a search box and a download as CSV or Excel

Spreadsheet programs stop at about a million rows; many web viewers stop far sooner.

A screen at a time.

Only the rows on screen are drawn, so even a large file scrolls smoothly.

The separator.

Commas, semicolons, tabs and bars are found by themselves, and the page says which it used; quoted cells keep their commas.

Finding rows.

Type words to keep only the rows that hold them, ignoring capitals and accents.

Further reading

Topics: csv viewer · open large csv · csv file viewer · view csv online · csv reader

A little less theory. A little more doing.

Try it on your own terms, with a free browser tool.

Try the tool