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
- Open a .csv or .tsv file, drop it on the page, or paste CSV.
- The rows appear as a table, with the header line as column names. Sort or filter a column, or use Find.
- 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.
| Tool | Most it holds | What happens to a bigger file |
|---|---|---|
| GigaJSON | Files up to 1 GB, any number of rows that fits in memory | The page says the file is over the limit and opens nothing |
| Excel | 1,048,576 rows by 16,384 columns per sheet | Rows past the limit are left out, with a warning |
| Google Sheets | 10 million cells per spreadsheet, across all its sheets | The 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
- JSON FormatterIndent with 2 or 4 spaces, sort keys
- JSON ValidatorLine and column of the first error
- JSON MinifierRemove whitespace, see the bytes saved
- JSON RepairFixes quotes, commas, comments, AI output
- JSON Schema GeneratorA JSON Schema from examples
- JSON Schema ValidatorCheck JSON against a schema
- JSON Token CounterCount tokens, select data, compare JSON and TOON
- JSON EditorTree and code editing, undo and history
- Large JSON ViewerTree, table and search for huge files
- JSON Lines ViewerJSONL and NDJSON logs as a table
- JSON Log ViewerCount and filter JSON Lines logs
- Large CSV ViewerCSV files too big for Excel, up to 1 GB
- JSON VisualizerThe data as a graph, PNG and SVG export
- JSON DiffChanges between two documents
- JSON Path FinderClick a value, copy its path
- JSONPath TesterJSONPath, JMESPath and jq, live
- JMESPath PlaygroundJMESPath, for AWS CLI queries too
- jq PlaygroundReal jq in your browser
- JSON to CSVNested objects become dotted columns
- JSON to ExcelAn .xlsx sheet, numbers kept as numbers
- CSV to JSONDelimiters detected, 007 stays 007
- JSON to XML@keys become attributes
- XML to JSONRSS feeds, sitemaps, SOAP responses
- JSON to YAMLReadable YAML, ambiguous strings quoted
- YAML to JSONAnchors and multiple documents
- JSON Lines to JSONNDJSON or JSONL into one array
- JSON to JSON LinesA JSON array as one record per line
- JSON to TOONConvert JSON to TOON, with token counts
- JSON to MermaidA flowchart or class diagram, drawn
- JSON SplitterCut a big file into parts, or sample it
- JSON to TypeScriptInterfaces inferred from your data
- JSON to GoGo structs with json tags
- JSON to RustRust structs that derive serde's Serialize and Deserialize
- JSON to PythonPython dataclasses with type hints
- JSON to JavaJava classes with getters and setters
- JSON to C#C# classes with System.Text.Json attributes
- JSON to KotlinKotlin data classes
- JSON to SwiftSwift structs that conform to Codable, with CodingKeys
- JSON to DartDart classes with fromJson and toJson
- JSON to ZodZod schemas with TypeScript types inferred from them
- JWT DecoderHeader, payload and expiry, locally
- JSON EscapeText to a JSON string and back
- Sample JSON FilesDownload test JSON, 100 KB to 1 GB
- Sample JSON Lines FilesDownload test NDJSON, one record per line
- Sample CSV FilesDownload test CSV, 100 KB to 1 GB
- Sample XML FilesDownload test XML, 100 KB to 1 GB
- Sample GeoJSON FilesPoints, lines and polygons, up to 1 GB
- Sample Nested JSONRecords 8 levels deep, up to 1 GB
- Sample Unicode JSON13 scripts, emoji and escapes
- Sample API ResponsesJSON:API, HAL, GraphQL, pages, errors
- Large JSON File GeneratorTest data from 100 KB to 1 GB