JSON to CSV converter
Turn an array of objects into a spreadsheet, and a spreadsheet back into JSON.
Input
Result
The result will appear here.Your runs
Only runs that cost points are saved.
Sign in to keep a history of your runs.
An API returns an array of objects and somebody needs it in a spreadsheet — or a colleague sends a CSV export that has to go back into a request body. This converts both ways, quoting and escaping the way RFC 4180 requires, so a value containing a comma, a quote or a newline still lands in one cell rather than shifting every column after it by one.
How it works
- Conversion runs in your browser on PapaParse, the CSV parser most JavaScript tooling uses.
- Column headers come from the union of keys across all objects, so rows with missing fields still line up.
- Reading a CSV, numeric and boolean-looking cells are converted to real JSON values rather than left as strings.
Where your data goes
Nowhere. This tool runs entirely in your browser: the text you paste is processed by the page and is never transmitted to a server or written to a log.
When a run costs points, a one-line summary is saved to your own history so you can find it again. The summary records the shape of the run — sizes, counts, the values you looked up — never the content you pasted.
What it costs
Free up to 50.0 KB per run without an account. Past that, a run costs 1 points and is saved to your history.
Points come from signing up, checking in daily, commenting and completing your profile.
See how points workCommon questions
- What happens to nested objects?
- A cell holds one value, so a nested object is written as its JSON text. If you need nested fields as separate columns, flatten the data before converting.
- Why does Excel mangle my Chinese characters?
- Excel guesses the encoding of a bare CSV and often guesses wrong. Import the file explicitly as UTF-8 rather than double-clicking it, or open it in Numbers or Google Sheets, which both assume UTF-8.
- Can I use a semicolon or tab separator?
- Yes, both are offered. Semicolon-separated files are the norm in locales where the comma is the decimal separator.
The open-source behind it
This tool runs on mholt/PapaParse, released under MIT. If you need the same behaviour inside your own program, that is the library to reach for.
mholt/PapaParseAlso known as
- json to csv
- csv to json
- convert json to excel
- json array to csv
- csv converter