Download a sample CSV file of any size
Choose the data and the size, then download. Every file has a header row and one row per record of realistic data, made on your device.
- Header row, UTF-8
- Nothing is uploaded
- 100 KB to 1 GB
- Free, no sign-up
Download a sample CSV file in the size you need, from 100 KB to 1 GB, to test an import, a spreadsheet or a data pipeline. Each file has a header row and one row per record of realistic data: orders, customers, products, blog posts, users or log events. Nested fields become columns such as customer.address.city. To turn a CSV into JSON, use CSV to JSON.
What people use these files for
- Test an import
Check how your database, spreadsheet or ETL tool reads quoted fields, dates and many columns.
- Check an upload limit
Pick a size just under or over your limit to see how your form or API responds.
- Try a spreadsheet
See how Excel or Google Sheets handle thousands or a million rows.
- Benchmark a pipeline
Time a load with 100 MB, 500 MB or 1 GB of rows, the same file every run.
Need JSON instead? Convert any file with CSV to JSON.
How to use it
- Choose what the file holds: orders, customers, products, blog posts, users, log events, nested data or Unicode text.
- Choose a size from 100 KB to 1 GB, or type a custom size. The file holds whole records and stays within it.
- Click Generate and download, or Open in GigaJSON instead to look inside it.
Private, and made for big files
This tool runs in your browser, in a background worker: the file is made on your computer and never uploaded, and nothing is kept after you leave. Files up to 1 GB are written in pieces, so the page keeps responding. 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.
Questions
What does the CSV look like?
Comma-separated, with a header row, UTF-8 text and CRLF line breaks. Fields with commas, quotes or line breaks are quoted. Nested objects become dotted columns, and lists inside a row are written as JSON text.
Where can I get a large CSV file for testing?
Here. Pick a size up to 1 GB and the kind of data, and the file is made in your browser. There is nothing to sign up for.
Will Excel open it?
Yes, but Excel shows at most 1,048,576 rows. The page shows about how many rows a file holds before you make it. Google Sheets has its own cell limit, so use small files there.
Is the file the same every time?
Yes. The same size and data always give the same file.
Is anything uploaded?
No. The file is made in your browser and saved from there. Nothing is kept after you leave.
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