CSV ↔ JSON Converter

About the CSV ↔ JSON Converter

Turn CSV with a header row into a JSON array of objects, or turn a JSON array of objects into CSV. Quoted fields, commas inside quotes, doubled quotes, Windows line endings and a leading byte-order mark are handled.

When converting to CSV, the columns are the union of the keys found across all objects, so objects with different keys still line up.

How to use it

1. Choose CSV to JSON or JSON to CSV.
2. Paste your data; for CSV the first row must be the header row.
3. Check any warning shown, then Copy Output or Download the result.

Worked example

CSV to JSON direction, indented with two spaces.

name,age
Ada,36
Linus,54

[
  {
    "name": "Ada",
    "age": "36"
  },
  {
    "name": "Linus",
    "age": "54"
  }
]

Common mistakes and gotchas

• CSV has no types, so every value comes out as a string: 36 becomes "36". Convert numbers and booleans in your own code if you need them.
• Nested objects and arrays do not fit in a flat CSV cell, so they are written as JSON text inside the cell.
• A cell that starts with =, +, - or @ gets a leading apostrophe on export so spreadsheets do not run it as a formula.
• Repeated column headers would overwrite each other as keys, so the converter renames duplicates and reports it.

Frequently asked questions