JSON to CSV

Convert JSON arrays of objects into CSV format with custom delimiters, nested object flattening, and download.

JSON to CSV

Convert JSON arrays into CSV format with delimiter and flattening options

Characters: 0
Options

Paste a JSON array above and click "Convert"

What is a JSON to CSV Converter?

A JSON to CSV converter is a tool that transforms a JSON array of objects into comma-separated values (CSV) format: the universal tabular data format supported by Excel, Google Sheets, databases, and data analysis tools. JSON is great for APIs and web apps, but when you need to analyze data in a spreadsheet or import it into a database, CSV is the standard format.

CodeHelper's JSON to CSV Converter handles nested objects (flattening them with dot notation), custom delimiters, proper CSV escaping for values containing commas or quotes, and generates a downloadable .csv file.

Key Features

  • Auto Column Detection: Extracts all unique keys from the JSON array as CSV columns.
  • Flatten Nested Objects: Converts nested objects into flat columns using dot notation (e.g., address.city).
  • Custom Delimiters: Choose comma, semicolon, or tab as the field separator.
  • Proper Escaping: Values containing delimiters, quotes, or newlines are properly escaped.
  • Download CSV: Export the converted data as a .csv file.

How to use the JSON to CSV Converter

  1. Paste your JSON array of objects into the input.
  2. Configure delimiter and flattening options.
  3. Click Convert to generate the CSV output.
  4. Copy or download the result.

Whether you are exporting API data for analysis, preparing database imports, or converting logs to spreadsheet format, this free tool converts JSON to CSV in seconds.

Frequently Asked Questions

How do I convert JSON to CSV for Excel?

Paste the JSON array, click Convert and download the .csv file. The download includes a UTF-8 byte order mark, so Excel opens accented characters correctly instead of guessing the encoding. If your Excel uses a semicolon as list separator, pick Semicolon as the delimiter before converting.

How are nested JSON objects converted to CSV columns?

With Flatten nested objects enabled, each nested property becomes its own column using dot notation: an address object with a city field becomes an address.city column. Arrays and, with flattening disabled, whole objects are written as JSON text inside the cell.

Can I convert a JSON API response that wraps the data in an object?

Yes. If you paste an object that contains a single array of objects, such as a response shaped like data: [ ... ] or results: [ ... ], the converter unwraps that array automatically. A single plain object becomes a one row CSV.

What happens when objects in the array have different keys?

The columns are the union of every key found in the array, in the order they first appear. Rows that lack a key get an empty cell, so the output stays rectangular and imports cleanly into spreadsheets and databases.

Are commas, quotes and line breaks inside values handled?

Yes. Any value containing the delimiter, a double quote or a line break is wrapped in double quotes, and quotes inside it are doubled, following RFC 4180. Spreadsheet applications and CSV libraries read the result without manual fixes.

Related

toolJSON FormatterProfessional JSON formatter with tree view, diff compare, schema validation, and syntax highlighting.toolJSON ↔ YAML ConverterConvert JSON to YAML and YAML to JSON with auto-detection, syntax highlighting, and format indicators.toolJSON DiffCompare two JSON objects and instantly see what was added, removed, or changed. Semantic key based diff that ignores property order, runs entirely in your browser.toolJSON to Zod, Go and PydanticConvert JSON into a Zod schema, a Go struct, or a Pydantic model with automatic type inference, nested types, and array detection. Free, runs entirely in your browser.

Free forever, no ads, no tracking. Support the project