DATA / PROCESSED LOCALLY

JSON to CSV

Make an array of records spreadsheet-ready.

↗

Input

0 charactersUTF-8 text

Processed locally · No uploads

How it works

Paste your content or open a supported local file.
Choose your settings, then preview or process it.
Copy or download the result. Clear your work when finished.

A few useful details

CSV needs a header row. CSV → JSON keeps values as strings to preserve IDs and leading zeroes. JSON → CSV accepts an array of records, serialises nested values, and prefixes formula-like cells for safer spreadsheet opening.

Inputs are limited to 1 MB; text comparison is limited to 100,000 characters per side. File contents are not saved between visits.

A PRACTICAL GUIDE

When to use JSON to CSV

Convert a non-empty JSON array of records into CSV for a spreadsheet or import workflow. Fields from all records become columns, including optional properties. Nested objects and arrays become JSON text in a cell rather than multiple expanded columns.

Records with an optional city

JSON:
[{"id":"001","name":"Adhi"},{"id":"002","name":"Maya","city":"Udupi"}]

CSV:
id,name,city
001,Adhi,
002,Maya,Udupi

Missing or null fields become empty cells. Spreadsheet software may reinterpret IDs; import identifier columns as text when needed.

Frequently asked questions

Can I convert a single object?

Wrap it in an array, such as [{"name":"Adhi"}]. The tool requires a non-empty array of objects with record fields.

What happens to nested data and large IDs?

Nested data becomes JSON text inside cells. Numbers are parsed with JavaScript precision, so large IDs should already be strings before conversion.

Why does a cell start with an apostrophe?

Formula-like values are prefixed to reduce spreadsheet formula execution risk. Review the CSV before importing it into a system where exact cell text matters.

Still need a hand? Contact the maintainer.