JSON to CSV & CSV to JSON Converter

Convert JSON arrays to CSV for Excel and Google Sheets, or CSV to JSON. Flattens nested objects, detects types and supports comma, semicolon, tab and pipe.

Runs 100% in your browser. Nothing you paste is uploaded.

JSON

CSV

About the JSON ↔ CSV

Export API data to a spreadsheet or import a spreadsheet into your app. Nested objects are flattened into dot-notation columns (address.city) and expanded back when converting CSV to JSON. Quoting, embedded commas and new lines are handled per RFC 4180.

Features

  • Flattens nested objects to dot columns
  • Union of all keys as header
  • RFC 4180 quoting
  • Comma, semicolon, tab or pipe delimiters
  • Number/boolean detection on import
  • Download as .csv

How to use it

  1. Choose the direction and delimiter.
  2. Paste JSON (an array of objects) or CSV with a header row.
  3. Download or copy the output.

Frequently asked questions

Excel shows everything in one column

Some locales use semicolons as the list separator. Choose Semicolon as the delimiter, or use Excel’s Data → From Text/CSV import.

Esc