CleanCSV

Convert JSON to CSV or Excel

Turn JSON files into a table: arrays of objects, nested fields, API responses and NDJSON all become clean CSV or Excel.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

JSON to CSV converter

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your JSON file here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Drop a .json, .jsonl or .ndjson file into the tool above.

  2. 2

    Records are found automatically, even inside an API response such as {"data": [...]}, and nested objects are flattened into columns.

  3. 3

    Check the columns in the preview, then download as CSV, Excel or TSV.

Supported JSON shapes

An array of objects (the most common), an array of arrays whose first array holds the headers, a single object, an object that wraps the records in a property such as data, results or items, and newline-delimited JSON (NDJSON or JSON Lines) with one object per line.

Nested data

Nested objects become dotted column names, so {"address": {"city": "Paris"}} turns into an address.city column. Arrays are kept as JSON text in a single cell, for example ["a","b"], so no information is lost. Every key that appears in any record gets a column, in the order it first appears.

From API to spreadsheet

Save an API response as a .json file, drop it here and you have a spreadsheet in seconds. Download it as Excel to share, or as CSV to import elsewhere.

Frequently asked questions

What if records have different keys?

All keys from all records become columns. Records without a key get an empty cell.

Is there a size limit?

JSON files up to 50 MB and 250,000 records.

Can I convert the CSV back to JSON?

Yes, use the CSV to JSON converter.