Overview
Switch between CSV → JSON and JSON → CSV with a single click and get live output as you type. The CSV parser correctly handles quoted fields containing commas and doubled-quote escapes (""), so real-world exports from Excel, Google Sheets, or a database dump won’t break the conversion. Converting CSV to JSON also infers types automatically - "true"/"false" become booleans and numeric-looking cells become numbers - so you get usable JSON instead of a wall of strings. Runs entirely client-side, so spreadsheet exports never leave your machine.
Best for: Converting a spreadsheet export into API-ready JSON
How to use this tool
- Pick a direction. Switch between CSV → JSON and JSON → CSV with a single click.
- Paste your data. Drop in a CSV export or a JSON array - quoted fields and escaped commas are handled correctly.
- Check the type inference. When converting CSV to JSON, "true"/"false" and numeric-looking cells become real booleans and numbers.
- Copy or swap. Grab the converted result, or use swap to feed the output straight back in as new input.
Why use this tool
Real CSV parsing, not split(",")
Correctly handles quoted fields containing commas and doubled-quote escapes from Excel or Sheets exports.
Automatic type inference
Booleans and numbers convert to their real JSON types instead of staying as strings.
Works in both directions
One tool instead of two - no need to find a separate converter depending on which way you’re going.
Spreadsheet exports stay private
Conversion happens locally, so exported rows never pass through a third-party server.
Frequently asked questions
Fields wrapped in double quotes can safely contain commas or line breaks - the parser only treats a comma as a column separator when it’s outside an open pair of quotes, matching standard CSV escaping rules.
When converting CSV to JSON, the tool inspects each cell: "true" and "false" become real booleans, and text that parses cleanly as a number becomes a JSON number. Everything else is kept as a plain string.
An array of objects. The converter scans every object in the array to build the full set of column headers, so objects with missing fields just produce an empty cell for that column instead of causing an error.