CSV / TSV ⇄ JSON Converter

About this tool

Convert headered CSV / TSV into a JSON array, or turn a JSON array back into CSV/TSV. Choose the delimiter (comma or tab) and whether to wrap every value in double quotes (default: CSV without extra quoting). Malformed CSV/TSV reports the error location. Formula protection can be enabled for files intended for spreadsheets. All processing happens entirely in your browser (no data is sent).

CSV / TSV ⇄ JSON Converter

The first-row header becomes object keys when converting to JSON.

—

Common uses

  • Prepare tabular data for APIs.
  • Turn JSON responses into shareable CSV/TSV.
  • Move data between spreadsheets and JSON.

How to use

  1. Paste CSV/TSV or JSON into the input area.
  2. Select the desired format (CSV or TSV) and whether to quote all values.
  3. Press CSV/TSV → JSON or JSON → CSV/TSV to convert. Enable formula protection only if you intend to open the output in a spreadsheet.

CSV/TSV supports double-quoted fields, doubled quotes, line breaks within quotes and CRLF/LF/CR line endings. Invalid quotes, mismatched column counts and duplicate or empty headers stop conversion. JSON values are strings.

Formula protection applies only to JSON → CSV/TSV. It prefixes potentially formula-like cells with a tab and encloses them in double quotes. It changes values (even numbers such as negatives may become text), so it is off by default. Results depend on the spreadsheet and how the file is saved. Leave it off for automated processing or exact round trips.

UTF-8 BOMs and CRLF endings from Excel-style exports are removed automatically.

Example

CSV → JSON

name,age
Alice,20
Bob,25

Result:

[
  { "name": "Alice", "age": "20" },
  { "name": "Bob", "age": "25" }
]