Developer tool

JSON to CSV

Turn a JSON array into a CSV spreadsheet.

Free Runs in your browser

About this tool

JSON to CSV turns an array of JSON objects into rows and columns you can open in Excel, Google Sheets or Numbers. Nested objects become columns like address.city.

How to use JSON to CSV

  1. Paste a JSON array.
  2. Choose the delimiter and flattening.
  3. Copy the CSV or download the .csv file.

Questions people ask

What if objects have different keys?

Every key found in any object becomes a column. Rows without that key get an empty cell.

How are commas and quotes inside values handled?

Values with the delimiter, quotes or line breaks are wrapped in double quotes, and inner quotes are doubled, as RFC 4180 describes.

Why does Excel show everything in one column?

Some regional settings expect a semicolon. Pick “Semicolon” as the delimiter and download again.

Guides for JSON to CSV

More developer tools

See all 24 →
CSV to JSONConvert CSV with headers into a JSON array. HTML Entity Encoder / DecoderEscape or unescape HTML entities like &. User Agent ParserSee your browser, OS and device from a user agent. Screen Resolution CheckerCheck your screen size, viewport and pixel ratio. HTTP Status CodesSearchable list of HTTP status codes and meanings. JSON FormatterBeautify, minify and validate JSON with error lines.
Esc