Developer/CSV ↔ JSON Converter

CSV ↔ JSON Converter

Convert between CSV and JSON with custom delimiters. 100% local.

100% LOCALAuto delimQuoted fieldsBidirectionalNo limits
Delimiter:
CSV Input82 chars
JSON Output
Output will appear here
Data Source & Legal Disclaimer
Effective: 2026
Sources: Browser-side processing (no external API)

This tool runs 100% in your browser. All computation happens locally on your device — your input is never uploaded to any server. Results are for reference only.

See all data sources & update policy →

CSV rows vs JSON tree — what conversion really means — illustrated

CSV is a flat table: one header row names the columns, every following line is one record with the same fields. JSON is a nestable tree: objects can hold objects and arrays, so it can express repeats, nesting and blank fields that a grid cannot. Converting CSV → JSON turns each row into an object keyed by the header; JSON → CSV flattens those objects back into rows. When a JSON field nests deeper, its path becomes part of the column name so nothing is lost.

Table ↔ Object list
CSV — flat gridnamelangAliceJSBoPYJSON — array of objects{ name: "Alice", lang: "JS" }{ name: "Bo", lang: "PY" }header → key, cell → valueWhen JSON nestsuser.addr.city → col "user.addr.city"tags[] → flattened with row index

Three rows × three columns map cleanly to an array of three objects. runtimes, units and modes are straight 1:1 — that is the entire job of the converter, done locally.

A contact list across two formats

The same three contacts, kept as a grid in CSV and as objects in JSON.

  1. Header becomes keys:Every CSV column name turns into a JSON property on each row object
  2. Rows become objects:Each data line is one object — the array is the whole table
  3. Blank & repeated cells:Empty cells map to null; JSON covers them with key/undefined naturally
  4. Reversing it:JSON → CSV flattens the array back to rows — dotted paths flatten nested structures
↩ Back to converter

To convert CSV to JSON: paste your CSV data or upload a file — the tool parses it and outputs clean JSON with auto-detected headers. Reverse conversion also supported.

FreeToolHub CSV to JSON Converter is a free browser-based tool that converts between CSV and JSON formats, no signup, no upload.

About this tool

What is this tool?

Convert CSV to JSON and back. Auto-detects comma, tab, semicolon delimiters. Handles nested quotes. 100% browser-based, free.

Auto delimQuoted fieldsBidirectionalNo limits

What Is the CSV ↔ JSON Converter?

This converter transforms CSV data into JSON arrays and JSON back into CSV, with the delimiter intelligence that real files demand: comma, tab, and semicolon delimiters are auto-detected, which rescues European exports where semicolons separate fields and the decimal comma lives inside them. Quoted fields containing commas, embedded quotes, and newlines parse correctly per RFC 4180, headers become JSON keys, and a type-inference pass turns numeric and boolean-looking fields into real numbers and booleans instead of strings. Conversion runs entirely in the browser, so customer exports and internal reports never upload anywhere.

Who Should Use This Tool?

Developers feed spreadsheet exports into APIs and databases that want JSON, without writing a one-off script every time. Data analysts move report data into visualization and notebook tools that prefer JSON structures. Product managers inspect a CSV a partner sent without opening a spreadsheet app. Anyone working with international exports benefits from the delimiter and decimal-comma handling, and anyone with sensitive lists — customer data, financial exports — gets the privacy of a purely local conversion.

How Does It Work?

(1) Paste CSV or use the file picker; the delimiter auto-detects, overridable manually if detection guesses wrong. (2) The first row is treated as headers and becomes JSON object keys. (3) Convert to JSON: each row becomes an object, quoted fields unwrap safely, and values that look numeric or boolean convert to native types. (4) In the reverse direction, paste a JSON array of objects; the union of keys forms the header row, values quote as needed, and you choose the output delimiter. Both directions preview instantly and support copy or file download.

Why Does CSV Parsing Break on Commas and Quotes?

CSV looks trivial until values contain the delimiter itself. The RFC 4180 answer is quoting: a field containing a comma wraps in double quotes, and a literal quote inside doubles up as "". Naive parsers that split on every comma shred addresses like "Portland, OR" into two fields; this converter implements the full quoting rule, so embedded commas, quotes, and even newlines inside quoted fields survive round-trips. Regional settings add the second trap: many European locales export semicolon-delimited CSV with comma decimals, so a file from a German Excel build is not broken — it is just speaking a different dialect, which auto-detection handles. When converting back to CSV for a specific consumer, match its dialect deliberately: Excel in the US expects commas, much of the EU expects semicolons, and systems loading via pandas accept either once declared.

Frequently Asked Questions

How does it handle CSV files with commas inside quoted fields?

It uses a proper CSV parser that respects RFC 4180 quoting rules. Fields wrapped in double quotes can contain commas, newlines, and quote characters (escaped as ""). This handles Excel exports, Google Sheets downloads, and database dumps correctly—unlike simple comma-split approaches that break on embedded commas.

Can it convert nested JSON to flat CSV and back?

Yes. When converting JSON to CSV, it flattens nested objects using dot notation (e.g., user.address.city becomes a column header). When converting CSV to JSON, you can choose between array-of-objects format or key-value pairs. Auto-detection handles comma, tab, and semicolon delimiters.

Other names for this tool

This tool is also known by these tasks — each link opens the same tool with a focused guide:

Related tools

Joke of the Day
Sep 6

What do you call a crab that plays baseball?

100% Free, Forever

Keep Tools Free for Everyone

No paywalls, no signups, no data sold. Built by a solo developer who believes useful tools should be accessible to everyone.

Support me on Ko-fi— keep tools free

100% of proceeds go towards hosting & building more free tools.