What is the ArrayKit JSON to CSV converter?

It is an in-browser tool that converts a JSON array of flat objects (or a single object) into a CSV with a header row you can copy or download as data.csv.

How do I convert a JSON array with different keys per object to CSV?

Just paste the array. ArrayKit collects the union of all keys across every object for the header, and any row missing a key gets an empty cell in that column.

What happens to nested objects and arrays during conversion?

Nested values are JSON-stringified into a single cell and a warning is shown. CSV works best with flat objects, so flatten them first for cleaner results.

Can I open the CSV result in Excel or Google Sheets?

Yes. Click the .csv button to download data.csv, then open it in Excel, Google Sheets, or Numbers as a comma-separated file.

Does the converter quote values that contain commas or quotes?

Yes. Any value with a comma, double quote, or newline is wrapped in quotes and inner quotes are doubled, following standard CSV escaping rules.

Is my JSON uploaded anywhere when I convert it to CSV?

No. This JSON to CSV conversion runs entirely in your browser, so your data never leaves your device and nothing is sent to a server.

JSON to CSV

Convert an array of flat JSON objects to CSV.

Your JSON is parsed and converted to CSV locally in your browser, and nothing is uploaded to a server.

Need readable, validated JSON first? Try the JSON Formatter.

About JSON to CSV

This json to csv converter turns an array of flat JSON objects into a comma-separated CSV file with a header row, ready to open in a spreadsheet. The columns are built from the union of every object's keys, so rows with missing fields still line up correctly, and any value containing commas, quotes, or newlines is safely quoted per CSV rules. It is handy for developers exporting API responses, QA engineers turning test fixtures into a sheet, and analysts who need to convert json to csv for Excel, Google Sheets, or Numbers. Paste a single object or a full json array to csv and the result updates instantly. Everything is processed locally in your browser, so even large payloads stay on your machine and nothing is uploaded to a server.

Features

Converts an array of flat JSON objects, or a single object, into CSV
Generates a header row from the union of all keys across every row
Aligns rows with missing keys by leaving those cells empty
Safely quotes and escapes values containing commas, quotes, or newlines
JSON-stringifies nested objects and arrays into a cell, with a clear warning
Live conversion as you type, with inline parse-error messages
Copy the CSV to your clipboard or download it as data.csv in one click

How to use the JSON to CSV

Paste your JSON array of flat objects into the input box.
Review the live CSV output on the right and check for any warning banner.
Fix any parse or structure errors shown beneath the input if they appear.
Click Copy to grab the CSV, or use the .csv button to download data.csv.
Open the downloaded file in Excel, Google Sheets, or Numbers.

Example

Input

[ { "id": 1, "name": "Ada" }, { "id": 2, "name": "Linus, Jr" } ]

Output

id,name
1,Ada
2,"Linus, Jr"

Values with commas are automatically quoted in the CSV output.

Common errors & troubleshooting

You pasted a single object instead of an array and expected multiple rows. — A lone object converts to one data row. Wrap multiple records in an array, like [ {...}, {...} ].
Error: every item must be a flat object, found a non-object row. — Remove strings, numbers, or arrays from the top-level list so each item is a plain object.
A warning says some values were nested objects or arrays and were JSON-stringified. — Flatten nested fields into top-level keys before converting if you want clean, readable CSV cells.
Error: expected an array of objects (or a single object). — Top-level primitives like a bare number or string cannot become rows. Provide an object or an array of objects.
Excel splits a multi-line cell across rows. — The converter quotes newline values correctly. Ensure your spreadsheet imports the file as CSV rather than fixed-width text.

Frequently asked questions

What is the ArrayKit JSON to CSV converter?: It is an in-browser tool that converts a JSON array of flat objects (or a single object) into a CSV with a header row you can copy or download as data.csv.
How do I convert a JSON array with different keys per object to CSV?: Just paste the array. ArrayKit collects the union of all keys across every object for the header, and any row missing a key gets an empty cell in that column.
What happens to nested objects and arrays during conversion?: Nested values are JSON-stringified into a single cell and a warning is shown. CSV works best with flat objects, so flatten them first for cleaner results.
Can I open the CSV result in Excel or Google Sheets?: Yes. Click the .csv button to download data.csv, then open it in Excel, Google Sheets, or Numbers as a comma-separated file.
Does the converter quote values that contain commas or quotes?: Yes. Any value with a comma, double quote, or newline is wrapped in quotes and inner quotes are doubled, following standard CSV escaping rules.
Is my JSON uploaded anywhere when I convert it to CSV?: No. This JSON to CSV conversion runs entirely in your browser, so your data never leaves your device and nothing is sent to a server.

Related tools

JSON Formatter — Beautify, minify and validate JSON with error locations.
JSON Viewer — Text + collapsible tree viewer with expand/collapse and node paths.
JSON Tree Viewer — Explore JSON as a collapsible, typed tree.
JSON to TypeScript — Generate TypeScript interfaces from a JSON sample.
JSON to Code — Generate Go, Rust, Python, Java, Kotlin, C# and TypeScript types from JSON.
YAML ↔ JSON — Convert YAML to JSON and back.
Mock Data Generator — Generate fake JSON data — names, emails, UUIDs, dates and more.