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

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.

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

Need JSON instead? Convert any file with CSV to JSON.

How to use it

  1. Choose what the file holds: orders, customers, products, blog posts, users, log events, nested data or Unicode text.
  2. Choose a size from 100 KB to 1 GB, or type a custom size. The file holds whole records and stays within it.
  3. 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