Skip to main content
DevStackKit
All tools

JSON to CSV

Convert JSON to CSV online. Nested objects become dot-path columns, arrays can be indexed or joined, and you pick the columns. Private.

More options

JSON

Stays in your browser

CSV

The result appears here after you press Convert.

Shortcuts: Ctrl+Enter run · Ctrl+Shift+C copy result · / search (use ⌘ on Mac)

Next steps

Done here? Use the Send to… menu on the result to carry it on to CSV Viewer, CSV to JSON or CSV to Markdown Table.

Free Online JSON to CSV

Paste JSON and get a CSV file you can open in Excel or Google Sheets. Nested data is flattened into columns such as address.city, and you choose which columns to keep. It gives developers a quick browser-based way to solve a focused json to csv task before moving the result into a project.

How to use JSON to CSV

Paste your data into the box on the left, or open a file, then press Convert. The input should be a list of objects (or a single object). Each object becomes one row and every key becomes a column.

Common mistakes

  • Pasting JSON that is a single number or text: CSV needs a list of objects or one object.
  • Expecting numbers with leading zeros to survive in Excel: it may drop them when it opens the file.

Frequently asked questions

How is nested JSON turned into columns?
Each nested key becomes a column named by its path, so {"address": {"city": "London"}} gives a column address.city. Lists become address.0, address.1 or one joined cell, as you choose.
What if the objects have different keys?
The columns are the union of every key found. Rows that lack a key get an empty cell.
Can Excel open the result?
Yes. Download the file and open it in Excel or Google Sheets. If your region uses semicolons between columns, choose Semicolon in the options.
Is my data uploaded anywhere?
No. The conversion runs in your browser and nothing you paste or open is sent to a server.
How do I use this json to csv tool?
Use the interactive controls above; processing stays in your browser and the result is intended as a practical starting point for development work.

More Formatters & Parsers

JSON ParserCheck if JSON is valid and see it neatlyJSON Schema ValidatorCheck data follows the rules you setJSONPath TesterPick values out of JSON with a pathXML/XSD ValidatorCheck XML is valid and follows a schemaJSON ↔ TOML ConverterSwitch config files between JSON and TOMLURL ParserBreak a web link into its partsQuery String ParserRead the ?a=1&b=2 part of a linkREST API TesterSend API requests and see the response

View all Formatters & Parsers tools →