JSON ⇄ CSV

How it works

This tool converts in both directions between a JSON array of objects and CSV. Going from JSON to CSV, the first row holds the column names, taken from every key that appears in the objects, even when they do not all share the same keys. Cells that contain the delimiter, quotes or line breaks are wrapped in quotes as RFC 4180 requires, so Excel, Google Sheets or any CSV reader can open them without breaking rows.

Going from CSV to JSON, each row becomes an object whose keys are the headers. If you turn on Detect numbers and booleans, values such as 42, 3.5, true or false are converted to their type instead of staying as strings, which saves a step when the JSON goes straight into an API call or a test fixture. If the file has an unclosed quote, you will see the line where it starts.

You can pick comma, semicolon or tab as the delimiter. Semicolon is the usual choice for spreadsheets set up in Spanish, Portuguese and other locales where the comma is the decimal separator.

The conversion happens entirely in your browser, so you can paste exports with customer or production data and they never leave the tab.

Examples

[{"id":1,"name":"Ana","city":"Santiago"},{"id":2,"name":"Luis","city":"Lima, Perú"}]

id,name,city
1,Ana,Santiago
2,Luis,"Lima, Perú"

id;name;active
1;Ana;true
2;"Luis ""Lucho""";false

[
  { "id": 1, "name": "Ana", "active": true },
  { "id": 2, "name": "Luis \"Lucho\"", "active": false }
]

Frequently asked questions