Text
CSV to JSON Converter
Convert tabular data between CSV and JSON in both directions, with delimiter options and proper quote handling.
What is CSV to JSON Converter?
CSV and JSON are the two most common ways to move tabular data around, and converting between them comes up constantly: export CSV from a spreadsheet and feed it to an app that speaks JSON, or take JSON from an API and open it in Excel.
The thing that usually breaks naive converters is quoting. A CSV cell may contain the delimiter itself if it is wrapped in double quotes — "Hanoi, Vietnam" is a single value despite the comma. Splitting the raw string on commas fails on the very first row that does this.
This tool parses CSV to RFC 4180: quoted cells, escaped double quotes and newlines inside cells all handled correctly. The reverse direction adds quoting where needed. Comma, semicolon, tab and pipe delimiters are supported — semicolon is common in files exported from European locale settings of Excel.
How to use
- Choose the direction: CSV to JSON or the reverse.
- Pick the delimiter that matches your file. If everything ends up in one column, you almost certainly picked the wrong one.
- Paste your data into the box. The result appears below with a record count.
- Click Swap to feed the result back through the opposite direction.
Frequently asked questions
Why does my Excel file use semicolons?
Because Excel picks its delimiter from your operating system's regional settings. Where a comma is the decimal separator — most of Europe and much of Asia — Excel switches to semicolons to avoid ambiguity.
Will cells containing commas break?
No, provided they are wrapped in double quotes as the CSV standard requires. The parser also handles doubled double-quotes for escaping, and newline characters inside a quoted cell.
What if my JSON records have different keys?
The tool collects every key appearing in any record to build the column list, not just those in the first record. Records missing a key get an empty cell.
How large a file can it handle?
A few megabytes is routine. At tens of megabytes the browser slows down, since both the input and the output are held in memory — use a command-line tool at that scale.