How to Convert JSON to CSV (and Back)

JSON is the language of APIs; CSV is the language of spreadsheets. So the moment you want to open API data in Excel or Google Sheets, filter it, chart it, or hand it to a non-developer — you need it as CSV. Converting a JSON array of objects into neat CSV rows by hand is tedious and fragile; a converter does it in one step, both directions.

Why convert JSON to CSV

• Spreadsheets — open, sort, filter, and chart the data in Excel or Sheets.
• Sharing — hand data to colleagues who don't work in JSON.
• Imports — many tools and CRMs accept CSV uploads, not JSON.
• Quick analysis — a flat table is easier to scan than nested JSON.

What converts cleanly

The ideal input is an array of objects with the same keys — each object becomes a row and each key becomes a column. Nested objects and arrays are flattened or joined so they still fit a single cell, and the reverse conversion turns a CSV back into a JSON array for feeding into code or an API.

Step-by-step: convert with ToolsGravity

1. Open the JSON ↔ CSV Converter and paste your JSON.
2. Get the CSV output — headers from the keys, one row per object.
3. Copy or download the CSV and open it in your spreadsheet app.

What it looks like

This JSON:

[
  { "name": "Ada", "role": "Engineer" },
  { "name": "Grace", "role": "Designer" }
]

becomes this CSV:

name,role
Ada,Engineer
Grace,Designer

Tips

• Keep keys consistent. Objects with different keys produce a patchy table — normalise the data first for clean columns.
• Mind nested data. Deeply nested JSON flattens into long column names or joined values; simpler input gives tidier CSV.
• Heading to docs instead? If you want a table for a README rather than a spreadsheet, convert to a Markdown table next.

Summary

Converting JSON to CSV bridges the gap between APIs and spreadsheets — turning an array of objects into a clean table you can open, filter, and share. Keep your keys consistent for the best results, and use the two-way ToolsGravity JSON ↔ CSV Converter in your browser.