Skip to content
M2TOOLKIT

Popular tools

Menu

JSON to CSV Converter

Turn a JSON array into a spreadsheet-ready CSV file.

  • Free
  • No sign-up
  • Runs in your browser

Everything you type is processed in your browser. Nothing you enter is sent to our servers or stored by us.

How to use the JSON to CSV Converter

  1. Paste your JSON array into the left box, or open a file.
  2. Adjust the options if you need to.
  3. Copy the CSV or download it as a file.

What does this tool do?

Each object in the array becomes a row and each key becomes a column. Objects with different keys are merged, so no data is lost. Nested objects are flattened into dot-notation columns like address.city, and short lists are joined with semicolons.

Values containing commas, quotes or line breaks are quoted correctly, following the CSV standard (RFC 4180), so Excel and Google Sheets open the file cleanly.

Why use it?

  • Analyse API data in a spreadsheet.
  • Share data with non-technical colleagues.
  • Choose comma, semicolon or tab delimiters.

Example

[{"name":"Ada","address":{"city":"London"}}] becomes:
name,address.city
Ada,London

Privacy

Everything you type is processed in your browser. Nothing you enter is sent to our servers or stored by us. There's no account to create and nothing to install.

Frequently asked questions

Excel puts everything in one column. Why?

Some regional settings (common in Europe) expect semicolons. Choose the semicolon delimiter and download again.

Last reviewed by the M2Toolkit team.

Helpful guides

Other tools people use alongside the json to csv converter.