Free tool
JSON to CSV converter
Paste a JSON array, a wrapped API response or newline-delimited JSON and download a CSV. Nested fields become dot-path columns, so seller.name gets its own column. Your data stays in your browser.
How the conversion works
Finds the records
A top-level array is used as is. For an object, the converter looks for the list of records inside it, such as data, items, results or products.
Flattens nested fields
Objects become dot-path columns (price.amount, price.currency). Lists of plain values join into one cell with "; ". Lists of objects stay as JSON text in their cell.
Keeps every column
Columns are the union of every record's fields in the order they first appear, so a field that only some records have still gets a column.
Writes standard CSV
Cells with separators, quotes or line breaks are quoted (RFC 4180). Choose semicolons for spreadsheets set to a European locale.
Questions
Is my JSON uploaded anywhere?
No. The conversion runs in this page with JavaScript; the JSON and the CSV never leave your browser.
Can it read NDJSON or JSON Lines?
Yes. Paste one JSON object per line and each line becomes a row.
How large a file can it handle?
Tens of megabytes work in a current browser. The preview shows the first 50 rows; the download has all of them.
More free tools
-
Website data checker
Enter a URL to see the JSON-LD, embedded JSON, feeds, sitemap, robots.txt rules and llms.txt a crawler finds there.
-
JSON Schema generator
Paste sample records to get a JSON Schema, TypeScript interfaces and Pydantic models that cover every record.
-
robots.txt tester
Load or paste a robots.txt, pick a crawler and see whether each URL is allowed, with the rule and line that decides it.
-
Sitemap checker
Find a site's sitemap and check its URLs, child sitemaps, duplicates, escaping and lastmod dates against the sitemap protocol.
-
llms.txt generator
Enter a site to get a draft llms.txt from its home page, sitemap and page titles, ready to edit and publish.
-
Shopify store to CSV
Enter a Shopify store or collection to download its public products as CSV, one row per product or per variant.
Need the data itself, on a schedule?
CleanedWeb turns a website into a maintained REST API that returns structured records, with a versioned schema and repairs when the site changes.