What JSON shape is expected?

An array of flat objects; keys become the CSV header row.

JSON to CSV Converter

Convert a JSON array of objects to CSV in your browser. Download instantly, nothing uploaded.

By AbraCalc Editorial Team · Reviewed by AbraCalc Methodology Review · Last reviewed: 2026-06-26 2 sources

JSON (array of objects)

Built with PapaParse (MIT), self-hosted.

Embed this tool on your site

<iframe src="https://abracalc.com/app/json-to-csv/" width="100%" height="640" style="border:1px solid #e6e1f0;border-radius:12px" loading="lazy"></iframe>

Cite this tool

APA

AbraCalc. (2026). JSON to CSV Converter [Online calculator]. Retrieved from https://abracalc.com/app/json-to-csv/

BibTeX

@misc{abracalc-json-to-csv, author = {AbraCalc}, title = {JSON to CSV Converter}, year = {2026}, howpublished = {\url{https://abracalc.com/app/json-to-csv/}} }

Did this tool answer your question?

How to use this tool

Paste a JSON array of objects.
Convert.
Download the CSV.

Convert a JSON array of objects to CSV in your browser. Download instantly, nothing uploaded.

How it works

This tool converts a JSON array of objects into CSV format, ready to open in Excel, Google Sheets, or any data tool. It runs entirely in your browser so your data stays private.

Paste a valid JSON array into the input. The tool reads all unique keys across every object to build the column headers, then outputs one CSV row per object. If an object is missing a key, that cell is left blank.

This is useful when you receive data from an API or database in JSON format and need to analyze or share it in a spreadsheet. It is also a quick way to preview JSON data in a tabular format.

The result can be downloaded as a .csv file or copied directly to the clipboard. The output uses standard CSV quoting, so values containing commas or quotes are handled correctly.

Worked example

Export API response data to a spreadsheet

Copy the JSON array returned by your API endpoint.
Paste it into the JSON to CSV tool's input field.
Confirm the column headers detected match your expected keys.
Click Convert to generate the CSV.
Click Download and open the file in Excel or Google Sheets.

A CSV file with one header row and one data row per JSON object, ready for analysis.

Common mistakes to avoid

Passing a JSON object instead of a JSON array — the tool needs the outer [ ] brackets.
Expecting deeply nested objects to expand automatically; flatten them first.
Forgetting that all values become strings in CSV; numeric precision or boolean values may need attention downstream.

Key terms

JSON array: A list of values enclosed in square brackets [ ]; each element here is an object with key-value pairs.
Column union: When objects have different keys, the tool collects all unique keys to form the full set of columns.
CSV quoting: Wrapping a field in double quotes so that commas or newlines inside the value do not break the row structure.

Frequently asked questions

What JSON shape is expected?: An array of flat objects; keys become the CSV header row.