{Formatiq}
Formatiq / Converters / CSV ⇄ JSON Converter

CSV ⇄ JSON Converter

Client-sideNo sign-upFree

Convert CSV to JSON or JSON to CSV in either direction, in your browser.

How this tool works

1

Pick a direction

Switch between CSV → JSON and JSON → CSV with a single click.

2

Paste your data

Drop in a CSV export or a JSON array - quoted fields and escaped commas are handled correctly.

3

Check the type inference

When converting CSV to JSON, "true"/"false" and numeric-looking cells become real booleans and numbers.

4

Copy or swap

Grab the converted result, or use swap to feed the output straight back in as new input.

Quick facts

Category
Converters
Best for
Converting a spreadsheet export into API-ready JSON
CSV
JSON
[ { "id": 1, "name": "Formatiq", "active": true }, { "id": 2, "name": "Codebeautify, Inc.", "active": false } ]
✓ 2 row(s), 3 column(s)
In-content slot

About this tool

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.

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.

Related tools

JSON to CSV Converter

Convert a JSON array or object into CSV, ready to open in a spreadsheet.

CSV to TSV Converter

Convert CSV to TSV or TSV to CSV in either direction, with proper quoted-field handling.

Image Compressor

Compress JPG, PNG, or WebP images entirely in your browser, with a quality slider and download.

Timezone Converter

Convert a date and time across major timezones at once, from UTC to Sydney.

Explore more free tools

Formatters, converters, validators, and generators - all free and running entirely in your browser.

Browse more tools