MUTools

Other

CSV to JSON Converter

CSV to JSON Converter is a free, two-way csv json converter that turns CSV tables into JSON and converts JSON back to CSV. It handles both directions — "CSV → JSON" and "JSON → CSV" — and updates the result in real time as you type, so there is no convert button to press. No install and no signup required.

Conversion mode
Input CSV delimiter
Output JSON format

Drop a CSV / JSON / JSONL file here

or

Supported: .csv .tsv .json .jsonl (up to 10MB)

JSON output
Results will appear here as you type.

Everything you enter is processed in your browser and is never sent to a server.

About CSV to JSON Converter

CSV to JSON Converter is a free, two-way csv json converter that turns CSV tables into JSON and converts JSON back to CSV. It handles both directions — "CSV → JSON" and "JSON → CSV" — and updates the result in real time as you type, so there is no convert button to press. No install and no signup required.

In the CSV to JSON direction, the converter detects the header row and treats the first line as field names (keys), infers types so that numbers, booleans, and null are converted automatically, and lets you pick the delimiter from comma, tab, semicolon, or pipe. Paste a CSV or TSV exported from Excel and convert it straight into a JSON array of objects. Besides a standard JSON array, you can output JSONL (one record per line), which makes csv to jsonl conversion and logging workflows easy.

In the JSON to CSV direction, an array of objects is written out as CSV. The columns are built from the union of every object's keys, so no column is dropped even when records have different fields. Nested objects and arrays are stored in cells as JSON strings. With selectable output delimiters and an optional UTF-8 BOM (Excel-compatible), it fits Excel CSV and JSON workflows and any json to csv export.

Every CSV and JSON you enter is processed in your browser and is never sent to an external server, so it is safe for files containing internal or personal data. Runs entirely in your browser.

How to use

  1. Choose "CSV → JSON" or "JSON → CSV" under "Conversion mode" at the top.
  2. Type or paste your CSV / JSON / JSONL into the input field, or drag and drop a file to load it. The result updates in real time.
  3. For CSV → JSON, toggle "Header row", "Type inference", the delimiter, and the JSON format (array / JSONL) as needed.
  4. For JSON → CSV, set the output delimiter and toggle "Excel-compatible (with BOM)" as needed.
  5. Use "Copy" or "Download" to grab the result. To try other data, clear the input field first.

Use cases

  • Export JSON data from an API response to CSV and open it in Excel or Google Sheets to review and summarize (json to csv).
  • Convert a CSV exported from Excel into JSON to use as seed data for a frontend or a mock (Excel CSV to JSON).
  • Convert CSV to JSONL (one record per line) for logging platforms or data processing pipelines (csv to jsonl).
  • Format a tab- or semicolon-delimited CSV / TSV into JSON with field names to inspect its contents.
  • Turn type inference off to keep leading zeros in postal codes or phone numbers while converting between CSV and JSON.

Notes

  • All conversion runs in your browser; your input data is never sent to an external server.
  • For CSV → JSON, "Auto-detect" estimates the delimiter (comma, tab, semicolon, etc.). If the result is unexpected, set the delimiter explicitly.
  • With "Type inference" on, numbers, booleans, and null are converted automatically. To keep leading zeros (for example a postal code like "0123"), turn it off and keep the values as strings.
  • When "Header row" is off, the first line is treated as data and each row is output as an array.
  • For JSON → CSV, the header is built from the union of every object's keys. Nested objects and arrays are output in cells as JSON strings.
  • For CSV opened in Excel, enable "Excel-compatible (with BOM)" to prevent garbled characters. Line breaks are written as CRLF.
  • Conversion continues even when rows have inconsistent column counts, and a warning is shown next to the result.

FAQ

Is the CSV or JSON I enter sent to a server?
No. All conversion happens entirely in your browser, so it is safe to use for csv json conversion of internal data or files containing personal information.
How do I prevent garbled characters in Excel for JSON → CSV?
Enable "Excel-compatible (with BOM)". The CSV is written with a UTF-8 BOM, so non-ASCII text opens correctly in Excel.
Does it support JSONL (one record per line) for input and output?
Yes. For CSV → JSON you can choose "JSONL" as the output format. For JSON → CSV the input is auto-detected as JSONL when applicable, so both csv to jsonl and jsonl to csv conversion work.
What happens when I convert nested JSON to CSV?
Nested objects and arrays are output as JSON strings directly in their cells. Because CSV is a flat, tabular format, nested structures are kept as text.
Leading zeros in postal codes and phone numbers disappear.
When "Type inference" is on, those values are read as numbers and the leading zero is lost. Turn type inference off to keep every value as a string.