Paste a JSON array and convert it to a CSV file instantly. Browser-based — your data never leaves your device.
This JSON to CSV converter turns a JSON array of objects into a clean, spreadsheet-ready CSV file in real time — paste your data, pick a delimiter, and copy or download the result without a single byte ever leaving your browser.
JSON is the native format of almost every modern API, database export, and web service, but spreadsheets, accounting packages, and data-analysis tools usually expect tabular CSV. Converting by hand is tedious and error-prone, especially when objects have inconsistent keys or contain commas, quotes, and line breaks that need escaping. This tool reads your array, collects every unique key across all objects to build the header row, and lines each record up underneath it. Values are escaped to the RFC 4180 standard automatically, so fields containing the delimiter, double quotes, or newlines are wrapped and quoted correctly — the output opens cleanly in Excel, Google Sheets, Numbers, and any database import wizard. People use it to:
You stay in control of the format: choose a comma, semicolon, tab, or pipe delimiter, force every field to be quoted, and include or drop the header row. A live counter shows the exact row and column totals so you can sanity-check the conversion at a glance. Everything runs locally in JavaScript — nothing you paste is uploaded, stored, or logged, so even sensitive customer or financial data stays entirely on your own device.
[{"name":"Alice","age":30}]) into the input box..csv file.The input must be a JSON array of objects (e.g. [{"a":1},{"a":2}]). All keys from all objects are collected as column headers. Missing keys produce empty cells.
Nested objects and arrays are stringified as JSON text in the cell. If you need flat columns from nested data, flatten your JSON before converting.
No — conversion happens entirely in your browser using JavaScript. Your JSON data never leaves your device.
CSV is a flat, tabular format, so each object in the array becomes one row and each key becomes a column. If your data is a single object, wrap it in square brackets to make a one-element array. A bare value or an object at the root will show an error, because there are no records to lay out as rows.
When a value is itself an object or array, it is written into the cell as compact JSON text rather than being expanded into extra columns. This keeps the data intact in a single field. If you would rather have separate columns for nested properties, flatten the JSON first so every value sits at the top level of each object.
Yes. You can switch the delimiter between comma, semicolon, tab, or pipe to match what your target program expects, and untick Include header row if you only want the data. There is also a Quote all fields option that wraps every value in double quotes, which some strict importers require.
Yes. Fields containing commas, quotes, or line breaks are escaped to the RFC 4180 standard, so spreadsheets parse them correctly. If Excel does not split a comma file into columns automatically, pick the semicolon delimiter, which many European locales expect, or use the Data import wizard to choose the separator manually.