How to use JSON to CSV
- Paste JSON or open a .json file. An array of objects works best.
- Pick the delimiter and how nested arrays should be written.
- Tick “Add BOM” if Excel shows accented characters incorrectly when you open the file.
- Download the .csv file or copy it straight into a spreadsheet.
About this tool
Columns are the union of all keys across all objects, in the order they first appear, so records with missing fields simply get empty cells. Nested objects are flattened with dot notation ({"address":{"city":"Paris"}} becomes an address.city column). Arrays can either spread into numbered columns (tags.0, tags.1) or stay as JSON text in one cell, which is easier to read back later.
Values that contain the delimiter, double quotes or line breaks are quoted according to RFC 4180, so the file opens correctly in Excel, Google Sheets, LibreOffice and database import tools. Excel on Windows assumes the legacy ANSI code page for CSV files unless the file starts with a UTF-8 byte order mark, which is what the BOM option adds.
If you paste a single object whose main content is one array (like {"results": [...]}), the tool converts that array. Very large integers are written exactly as in your JSON rather than being rounded.
Frequently asked questions
Why does Excel put everything in one column?
In locales where the comma is the decimal separator, Excel expects semicolons. Choose “Semicolon” as the delimiter, or import the file via Data → From Text/CSV.
Can I convert JSON Lines (one object per line)?
Wrap the lines in [ ] and separate them with commas to make a JSON array, then convert. The Find and Replace tool can add the commas with a regex.
Is there a size limit?
Files of tens of megabytes convert in a few seconds. The preview shows the first rows; the download contains everything.
Are my files and texts uploaded to a server?
No. The whole process runs inside your browser with JavaScript. Your files and texts never leave your device, which also means the tool keeps working if you go offline after the page has loaded.
Is this tool really free?
Yes. There is no sign-up, no daily limit, no watermark and no paid tier. The site is supported by advertising shown on the page, not by charging for the tools.