JSON to CSV Converter
CV-02Paste a JSON array of objects and get CSV with one column per key and one row per object, ready to open in Excel. Nested values are written as JSON text inside the cell.
Runs in your browser. Nothing is uploaded.
JSON
CSV
How to use it
- Paste your JSON array into the input box, or open a .json file (up to 5 MB).
- Choose the delimiter: comma, semicolon, tab or pipe.
- Leave Protect formulas on if the CSV will be opened in a spreadsheet.
- Check the result, then copy it or download it as a .csv file.
How JSON becomes rows and columns
Each object in the array becomes a row. The columns are every key that appears in any object, in the order they were first seen, so objects with different keys still line up and missing values are left empty. A null becomes an empty cell. Numbers and true or false are written as they are. A single object, not in an array, becomes one row. An array of arrays becomes plain rows with no header. Cells are quoted when they contain the delimiter, a quote, a line break or leading or trailing spaces.
Nested objects and arrays
CSV is flat, and this converter does not spread nested data into extra columns such as address.city. A nested object or array is written as JSON text inside one cell, for example ["math","code"] in a tags column, quoted so the commas stay inside the cell. If you need each nested field in its own column, flatten the JSON first. A top-level object becomes one row; other top-level values are rejected.
Opening the file in Excel and protecting formulas
This tool writes a .csv file, not an .xlsx workbook, and Excel opens CSV files directly. Spreadsheets can run text that starts with = + - or @ as a formula. With Protect formulas on, which is the default, such text gets a leading apostrophe so it stays text; the apostrophe may show in the cell when Excel opens the file. Plain numbers stored as text, like -5, are left alone. Turn it off if you want the values written exactly as they are. Semicolon or tab delimiters help when your spreadsheet expects them.
Error messages and what to do
| Message | What it means | Fix |
|---|---|---|
Input is not valid JSON: Expected ',' or '}' at line 1, column 7 | The JSON could not be parsed. The part after the colon is the parser's message with the line and column where it stopped; this one means a comma is missing. | Fix the JSON at that position, or run it through the JSON Formatter first. |
Input is not valid JSON: Expected a string key at line 1, column 8 | An object key is not in double quotes, or there is a trailing comma before }. | Put the key in double quotes or remove the trailing comma. |
Input is not valid JSON: Unexpected end of input at line 1, column 6 | The JSON is cut off where a value was still expected. | Add the missing value and the closing } or ]. |
Input is not valid JSON: Unexpected data after the end of the JSON value at line 2, column 1 | There is more than one JSON value, for example JSON Lines with one object per line. | Put the objects into one array, separated by commas, inside [ and ]. |
Expected an array of objects or an array of arrays. | The JSON is valid but the rows are plain values, such as [1,2,3] or ["a","b"], which have no columns to build. | Wrap each value in an object, for example [{"value":1}]. |
Mixed arrays and objects are not supported. | Some rows are objects and some are arrays, so the converter cannot decide on columns. | Make every row an object, or every row an array. |
Questions people ask
How do I convert JSON to CSV?
Paste a JSON array of objects into the input box and the CSV appears. Keys become the header row and each object becomes a row. Pick a delimiter if you do not want commas, then copy or download the .csv file. It runs in your browser.
How do I convert JSON to Excel?
This tool produces a CSV file, which Excel opens directly, rather than an .xlsx workbook. Paste the JSON, download the .csv and open it in Excel. Keep Protect formulas on so text starting with = + - or @ is not run as a formula.
What happens to nested JSON when I convert it to CSV?
Nested objects and arrays are not flattened into extra columns. Each one is written as JSON text inside a single cell, quoted so its commas stay in the cell. To get one column per nested field, flatten the JSON before converting.
What does Protect formulas do when converting JSON to CSV?
It adds a leading apostrophe to text that starts with =, +, - or @, so a spreadsheet does not run it as a formula. The apostrophe may show in the cell. Strings that are plain numbers, like -5, are left alone. It is on by default; untick it to write values unchanged.
Can I use semicolons or tabs instead of commas?
Yes. The delimiter list offers comma, semicolon, tab and pipe. Cells containing the chosen delimiter are wrapped in quotes. Use a semicolon or tab when your spreadsheet or import tool expects it.
Is my JSON uploaded when I convert it to CSV?
No. The conversion runs in your browser and nothing you paste is sent to a server. A share link keeps your input after the # in the address, which browsers do not send. There is no sign-up and no ads.
About this tool
Columns are the union of every key, in the order first seen. Nested values are written as JSON text inside the cell. "Protect formulas" adds a leading apostrophe to text that starts with =, +, - or @ so spreadsheets do not run it as a formula.