CalculatorsConvertersDeveloperTextAll toolsDirectory
Submit your tool Sign in
Theme
Home/Answers/Data
How-to

How do I convert JSON to CSV?

Short answer

Paste a JSON array of objects into a browser-based converter and it writes one CSV row per object, with the keys as the header. The conversion happens on your own device, so API responses and database dumps are never sent to a server.

Flat objects convert cleanly, nested ones need a plan

CSV is a flat format, so an array of objects with simple values maps perfectly: keys become columns, objects become rows. Nested objects and arrays do not have a single natural CSV shape, so they are typically flattened into dotted column names or serialized into a cell. Knowing that up front saves confusion when the output looks different from the input.

The fastest route from API response to spreadsheet

The most common reason to do this is getting JSON from an API or a log into Excel or Google Sheets. A client-side converter turns the payload into CSV instantly in the browser, and because nothing is uploaded you can safely feed it real production responses that contain user data or internal identifiers.

Step by step

  1. Paste the JSON. Paste a JSON array of objects into the converter.
  2. Convert locally. The tool builds the CSV in your browser, keys become the header row.
  3. Download the CSV. Copy the CSV or download it and open it in any spreadsheet.

Frequently asked questions

Is the JSON sent anywhere?

No. The conversion runs entirely in your browser, nothing is uploaded.

What about nested objects?

Nested structures are flattened or serialized into a cell, since CSV itself is a flat format.

Can I open the result in Excel?

Yes. The output is standard CSV, which Excel, Google Sheets and Numbers all open directly.

Related answers