Skip to the tool
GigaJSON Large CSV Viewer
All tools
Format and check
View and query
Convert
JSON to code
Encode and decode
Sample files
Guides Open GigaJSON

Large CSV Viewer

Open CSV files up to 1 GB as a table you can sort, filter and query. Nothing is uploaded.

Drop a CSV file here
.csv or .tsv, up to 1 GB · read on this device
or · commas, semicolons and tabs
Table and tree: up to 1 GB (512 MB by default)Excel, for comparison: 1,048,576 rowsjq: 20 MB

Open a CSV file with millions of rows, up to 1 GB, in your browser. Excel stops at 1,048,576 rows and Google Sheets at 10 million cells, so a large export or log often won't open in either. Here the file becomes a table you can scroll to the last row, sort, filter and search, and Query runs JSONPath or JMESPath over every row. Commas, semicolons and tabs are detected from the header line. Nothing is uploaded. To turn the file into JSON, use CSV to JSON. Need a big file to try? The sample CSV files go up to 1 GB.

How to open a large CSV file

  1. Open a .csv or .tsv file, drop it on the page, or paste CSV.
  2. The rows appear as a table, with the header line as column names. Sort or filter a column, or use Find.
  3. Use Query for JSONPath or JMESPath across all the rows, or "Open in GigaJSON" to edit the data or export it as JSON, Excel or XML.

A CSV reader that keeps files on your device

This tool runs in your browser, in a background worker: nothing you paste or open is uploaded, and nothing is kept after you leave. Input is limited to 128 MB. Processing runs in a background worker. Already loaded features keep working if your connection drops. Loading another tool or jq for the first time needs a connection. When one tool isn't enough, GigaJSON opens your data with a tree, a table, JSONPath/JMESPath/jq queries, transforms, diff and history.

Large CSV files in Excel, Google Sheets and here

The spreadsheet limits come from Microsoft's and Google's own documentation, checked on 9 November 2026. The GigaJSON numbers are our own measurement on a Core i5 laptop.

ToolMost it holdsWhat happens to a bigger file
GigaJSONFiles up to 1 GB, any number of rows that fits in memoryThe page says the file is over the limit and opens nothing
Excel1,048,576 rows by 16,384 columns per sheetRows past the limit are left out, with a warning
Google Sheets10 million cells per spreadsheet, across all its sheetsThe import fails

Large CSV viewer questions

How do I open a CSV file that is too big for Excel?

Open it here. Excel shows at most 1,048,576 rows and drops the rest, while this viewer reads every row of a file up to 1 GB. The file is read on your computer, in a background worker, so the page keeps responding while it loads.

How long does a large CSV file take to open?

On our Core i5 laptop, the table showed after 5.6 seconds for a 150 MB file, 21 seconds for 500 MB and 43 seconds for 1 GB (2.5 million rows). CSV is read by a scanner written in JavaScript, so it takes about twice as long as JSON of the same size. The page keeps responding while it loads.

How large a CSV file can it open?

Up to 1 GB, depending on your computer's memory. The default limit is 512 MB; for bigger files, choose 1 GB in Preferences → Largest document, or confirm when the page asks. A 1 GB CSV file needs about 4 GB of free memory.

Which CSV formats does it read?

Comma, semicolon and tab separated files, with or without quotes. Quoted fields can hold commas, quotes ("" inside quotes) and line breaks. The first line is the header. Plain numbers and true/false become values, while text such as 007, +5 or 1.10 stays as written, so IDs keep their zeros and versions their digits.

Can I search or query the rows?

Yes. Filter a column in the table, use Find for any text, or Query for JSONPath and JMESPath, which work on the whole file. jq works on files up to about 20 MB.

Is my data uploaded?

No. The tool runs in your browser, in a background worker. Nothing you paste or open goes to a server, and nothing is kept after you leave the page.

Can I edit the file?

Not here: the viewer is read-only and keeps nothing after you leave. "Open in GigaJSON" opens the rows in the JSON editor, where you can change values, transform the data and export it as CSV, JSON, Excel or XML.

All tools