🔄 JSON to CSV / CSV to JSON Converter
Convert between JSON and CSV formats with nested object flattening, custom delimiters, and flexible options.
Last updated: November 8, 2026 · By the BoltQuickTools team
Moving data between JSON and spreadsheets
An API gave you JSON and someone needs it in Excel, or a colleague sent a CSV and your code expects objects. This page converts in both directions, and the details below tell you which values change on the way.
Direction, delimiter and headers
- Choose the JSON to CSV or CSV to JSON tab.
- Set Delimiter: Comma, Semicolon, Tab or Pipe. It must match your data when reading CSV.
- Include headers writes a header row when producing CSV. When reading CSV, it means "the first row holds column names". Untick it and columns are named
column_1,column_2and so on. - Quote all fields wraps every CSV value in double quotes, apart from null or missing ones.
- Paste your data to convert at once, or press Convert after typing or changing an option. Copy Output copies the result, and Download saves it as
output.csvoroutput.json.
JSON to CSV
[{"id":1,"name":"Lee, Ann","address":{"city":"Oslo","zip":"0150"},"tags":["a","b"]},
{"id":2,"name":"Sam \"Z\"","active":false,"note":null}]
becomes, with the note "2 rows, 7 columns":
id,name,address.city,address.zip,tags,active,note
1,"Lee, Ann",Oslo,0150,"[""a"",""b""]",,
2,"Sam ""Z""",,,,false,
Nested objects flatten with dots, arrays stay as JSON text in one cell, and columns are the union of keys across all rows.
CSV to JSON guesses your types
Values that look like numbers, booleans or null get converted. This input:
zip,qty,price,active,note,big
00501,1e3,0x10,true,null,12345678901234567890
produces:
[
{
"zip": 501,
"qty": 1000,
"price": 16,
"active": true,
"note": null,
"big": 12345678901234567000
}
]
The leading zeros of the ZIP code are gone, the long ID has lost precision, and there is no option to turn this off. If you have such columns, restore them afterwards or use a tool that lets you set column types.
Other things that do not round-trip
- A JSON array of plain values has no columns.
[1,2,3]outputs only blank lines and reports "3 rows, 0 columns". An array of strings is split by character position, under headers 0, 1 and so on. - JSON
nulland missing keys both become empty cells, and empty cells return as"", not null. - Empty objects vanish.
{"a":{},"c":1}has no column fora. - A cell holding an array only turns back into an array if at least one header contains a dot. With the headers
id,tagsthe value stays a string like"[\"a\",\"b\"]". - Any header with a dot is nested on the way back, so
v1.2becomes{"v1":{"2":...}}. If columnsaanda.bboth exist, thea.bvalue is lost. - With the wrong delimiter you get a single column:
a;bread with Comma stays as one key. Changing the delimiter does not re-run the conversion, so press Convert again. - Duplicate headers keep only the last value in each row.
Spreadsheet and input questions
Why do accented letters look wrong in Excel?
The downloaded CSV is UTF-8 without a byte-order mark, and some Excel setups assume another encoding when opening such a file directly. Use Excel's text import and choose UTF-8.
My Excel puts everything in one column. What now?
Regions that use a comma as the decimal separator often expect semicolons. Convert again with Semicolon selected.
Are quoted commas and line breaks inside cells handled?
Yes, in both directions. A quoted "x,1" stays one value, and a line break inside quotes stays inside the cell.
What about a single JSON object?
It is treated as one row. A bare number or string is rejected with "JSON must be an array of objects or a single object."
To inspect a CSV as a table first, open the CSV Viewer. If your JSON will not parse, the JSON Formatter points to the error, and the JSON guide covers the format's rules.