Skip to main content
SiteIndex
DeveloperReady to use

JSON to CSV

Convert JSON arrays into CSV tables for easy import into spreadsheets and data tools.

Guide

Interactive workspace

No account required
JSON to CSV

Enter a JSON array of objects, a single object, NDJSON (one object per line), or a wrapped API response whose property holds the array. Nested objects flatten to dot-notation columns by default; turn flattening off to keep them as JSON text in a single cell. Missing fields become empty cells; null is written as null. Files are read locally, not uploaded.

Neutralising prefixes cells that start with = + - @ with an apostrophe so spreadsheets treat them as text, not formulas.

How to use it

  1. Paste a JSON array, single object, NDJSON, or wrapped array response.
  2. Choose delimiter, nested-object flattening, array handling, and formula neutralisation options.
  3. Review the CSV and copy or download it. Keep formula neutralisation enabled for untrusted spreadsheet data.
What is JSON to CSV?

Convert JSON arrays into CSV tables for easy import into spreadsheets and data tools.

How it works

Read a JSON array, single object, NDJSON, or wrapped array response. Field names define CSV columns. Nested-object flattening and formula neutralisation are enabled by default; array representation and other export options are configurable.

Example input and expected output

Input

[{"name":"alpha","details":{"x":1}}]

Expected output

"name","details.x"
"alpha","1"
Common uses
  • Export object rows with different sets of fields into a common table.
  • Preserve nested details as JSON strings within CSV cells.
Limitations
  • CSV does not retain JSON types; review missing and null cells for your import workflow.
  • Formula neutralisation is enabled by default but can be disabled. Review untrusted data and spreadsheet import settings.
  • JavaScript JSON numeric precision applies before CSV serialization.
Frequently asked questions
What happens to nested objects and arrays?
Nested objects are flattened into column paths by default. You can turn flattening off to keep nested JSON in cells and choose how arrays are represented.
Which input shape is supported?
JSON arrays of objects, single objects, NDJSON, and wrapped responses containing an array are supported. Review validation messages for unsupported row shapes.
How are missing fields and null represented?
A missing property produces an empty cell; an explicit JSON null produces the text null. CSV does not retain JSON types, so text null is not distinguishable from a null value without a separate schema.
Are commas, quotes, and line breaks preserved?
Yes. Headers and values are quoted, internal quotes are doubled, and row separators use CRLF. Quoted cells may contain line breaks.
Can I open untrusted CSV in a spreadsheet?
Formula-like strings are neutralised by default. Keep that option enabled, review the data, and import untrusted values as text where possible; spreadsheet behavior varies.

Related tools

CSV to JSON
Parse CSV data into structured JSON arrays and objects for quick app, API, and spreadsheet workflows.
JSON Formatter
Validate, format, minify, copy, and download JSON with a quick browser-based parser.
XML Formatter
Pretty-print and validate XML with readable indentation, cleanup, and error feedback.
JSON to YAML
Transform JSON into YAML for configuration files, deployments, and readable structured data.
YAML to JSON
Convert YAML into JSON with validation and instant browser-side output for API and config workflows.