Is data uploaded to a server?

No. JSON and CSV parsing runs entirely in your local browser JavaScript thread.

Why are my columns shifted in Excel?

The file probably uses a different delimiter from the one Excel expects. Try Semicolon or Tab and download again.

Are ZIP codes with leading zeros kept?

Yes. Values like 02134 stay as text when converting CSV to JSON.

Can I open the CSV in Google Sheets?

Yes. Download the file and import it, or paste the CSV into a sheet and use Split text to columns.

JSON to CSV / CSV to JSON

Convert structured JSON arrays into CSV spreadsheets and parse CSV text tables into formatted JSON datasets in-browser.

Convert

Delimiter

Your text 289 chars · 5 lines

Result 3 rows

id,name,category,stock,price
101,Swiss Card,Hardware,45,29.99
102,Precision Knife,Cutlery,18,49.5
103,Tool Sharpener,Accessories,90,14

How to use JSON to CSV / CSV to JSON

Select JSON to CSV or CSV to JSON mode.
Paste your data or load sample records.
Copy the converted output or download as .csv / .json.

About JSON to CSV / CSV to JSON

Convert a JSON array of objects to CSV for spreadsheets, or turn CSV back into JSON. Choose comma, semicolon, tab, or pipe delimiters, and copy or download the result. Values containing commas, quotes, or line breaks are handled correctly in both directions.

JSON to CSV

Each object becomes a row and every key found in any object becomes a column, so objects with different fields still line up. Nested objects and arrays are written as JSON text inside their cell.

Cells that contain the delimiter, quotes, or line breaks are wrapped in quotes so Excel and Google Sheets open the file correctly.

CSV to JSON

The first row is used for the field names. Quoted cells may contain commas, line breaks, and doubled quotes. Plain numbers become JSON numbers, while values with leading zeros such as ZIP codes and phone numbers stay as text so the zeros are not lost.

Excel in many European locales saves CSV with semicolons; choose Semicolon as the delimiter for those files.

Common uses

API data to spreadsheets: Open an API response in Excel or Google Sheets.
Spreadsheets to apps: Turn a sheet export into JSON for code or a CMS import.
Test fixtures: Create JSON test data from a simple table.
Data clean-up: Switch delimiters between tools that expect different formats.

Questions about JSON to CSV / CSV to JSON

Is data uploaded to a server?: No. JSON and CSV parsing runs entirely in your local browser JavaScript thread.
Why are my columns shifted in Excel?: The file probably uses a different delimiter from the one Excel expects. Try Semicolon or Tab and download again.
Are ZIP codes with leading zeros kept?: Yes. Values like 02134 stay as text when converting CSV to JSON.
What happens to nested objects?: Nested objects and arrays are written as JSON text inside their CSV cell.
Can I open the CSV in Google Sheets?: Yes. Download the file and import it, or paste the CSV into a sheet and use Split text to columns.

More tools like JSON to CSV / CSV to JSON

Comments

Questions, ideas, or a bug in JSON to CSV / CSV to JSON? Let us know.