Home › Spreadsheets & Data › JSON to CSV
CSV

JSON to CSV

Flatten a JSON array into CSV.

✓ Free✓ No watermark
Advertisement
  1. 1Upload
  2. 2Settings
  3. 3Download

How to use JSON to CSV

Add your file (or type your content) using the box above.
Adjust the options if you want something different from the defaults.
Click the button, then download your result.

About JSON to CSV

JSON is hierarchical, while a CSV file is a flat table, so conversion works best when your data is a list of similar objects. Each object becomes a row, and the keys become the column headings. The result opens in Excel, Google Sheets or any database import tool.

Nested data needs a decision. An object inside an object is usually flattened into columns with names like address.city, and an array can be joined into a single cell or split into extra rows. Records that lack a key simply leave that cell empty. If your JSON is deeply nested, flatten or simplify it first for a cleaner spreadsheet.

How it works: the tool reads a JSON array of objects, collects the keys to build the header row, and writes one CSV line per object. The result opens in Excel, Google Sheets or any database import tool.

Step by step: 1) paste or add your JSON; 2) convert; 3) review the columns; 4) download the CSV. If the JSON is invalid, fix the reported syntax problem, such as a missing quote or trailing comma, and try again.

Realistic limits: CSV is flat and JSON is not. Nested objects and arrays do not map neatly onto columns, so deeply nested data may appear as text inside a cell or need to be flattened first. Objects that lack some keys leave blank cells. Very large JSON files depend on your device memory.

Typical uses: exporting API responses for analysis in a spreadsheet, sharing data with colleagues who do not read JSON, or preparing a database import.

Preparing the JSON: the cleanest input is a flat array where every object has the same keys, such as a list of products with name, price and stock. If your API wraps the list inside another object, copy only the array part. Numbers, booleans and text all become plain cell values, and null becomes an empty cell.

After export: open the CSV in a spreadsheet and check that long numbers such as phone numbers or IDs have not been shortened or changed to scientific notation by the program; importing them as text avoids that. If you see JSON text inside a cell, that field contained a nested object, and flattening it before conversion will give separate columns.

Tips for better results

  • Validate your JSON first; a missing bracket will stop the conversion.
  • Use consistent keys across records to avoid sparse columns.
  • Check dates and long numbers after opening in a spreadsheet, which may reformat them.
  • For the reverse, use CSV to JSON.
  • Use an array of similar objects for the cleanest table.
  • Flatten nested structures before converting if you need separate columns.
  • Use CSV to JSON to go back.