🔄 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

  1. Choose the JSON to CSV or CSV to JSON tab.
  2. Set Delimiter: Comma, Semicolon, Tab or Pipe. It must match your data when reading CSV.
  3. 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_2 and so on.
  4. Quote all fields wraps every CSV value in double quotes, apart from null or missing ones.
  5. 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.csv or output.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

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.