Data convertersFreeNo uploadNo sign-up
JSON to CSV Converter
Turn a JSON array into a CSV table for Excel or Google Sheets. Nested fields become their own columns.
Runs in your browser. Your data is never sent to a server.
How to use the JSON to CSV
Paste or upload JSON
Paste a JSON array of objects or drop a .json file. A single object or an object holding an array works too.
Check the table
Columns are built from all keys, and nested objects are flattened into names like user.email. Choose the delimiter you need.
Download the CSV
Copy the CSV or download it. Turn on the Excel option so special characters open correctly in Excel.
Why use this tool
APIs and exports often give you JSON, but spreadsheets, reports and many import tools want CSV. This JSON to CSV converter reads every record, collects all keys into columns, even when some records are missing fields, and writes one row per record.
Nested objects are flattened into dot notation, so {"user":{"name":"Ann"}} becomes a user.name column. Arrays of simple values are joined into one cell, and arrays of objects are numbered, such as items.0.price, so nothing is silently dropped.
Frequently asked questions
How do I convert JSON to CSV?
Paste your JSON or upload a .json file. The table preview shows the result, and you can copy the CSV or download it as a file.
What JSON structure does it accept?
An array of objects works best. A single object becomes one row, and if your JSON wraps the records in a property such as {"data":[…]}, the converter finds the array for you.
How are nested objects and arrays handled?
Nested objects are flattened with dots, for example address.city. Lists of simple values are joined with a separator, and lists of objects get numbered columns.
How do I convert JSON to CSV in Python?
With pandas: pd.json_normalize(data).to_csv("out.csv", index=False). json_normalize flattens nested objects the same way this tool does.
Are my files uploaded to a server?
No. formatmath converts files with code that runs inside your browser. Your files are never uploaded, stored or seen by us.
Is it free?
Yes. There is no watermark and no daily limit. An account is optional and only keeps a history of your conversions.