Skip to content
Tool Dock

JSON to CSV

Turn a JSON array into a CSV you can open in Excel or Google Sheets.

Options

Input

Waiting for input

Output

or press ⌘/Ctrl + Enter
  • Runs in your browser
  • Nothing is uploaded
  • Free, no sign-up

How to use it

  1. Paste a JSON array of objects, or an object that contains one.
  2. Choose the separator (comma for most tools, semicolon for Excel in many European locales).
  3. Run it and download the CSV or copy it.

Why Tool Dock

  • FastEverything runs on your own device, so there is no queue and no waiting for uploads.
  • PrivateYour files and text never leave the browser. Close the tab and they are gone.
  • Batch friendlyDrop several files at once and download each result, or all of them together.

Questions

How are nested objects handled?

With flattening on, nested keys become dotted column names such as address.city, and array items become address.0, address.1. Turn it off to keep nested values as JSON text in one cell.

What if objects have different keys?

The column list is the union of every key, in the order first seen. Missing values are left empty.

Excel shows everything in one column. Why?

Your Excel expects a semicolon. Choose ';' as the separator, or use Excel's Data → From Text import and pick the comma.

All tools