CSV to JSON
Turn CSV rows into JSON objects, every value kept as written. Free, with no account or uploads.
Paste CSV to turn it into JSON
The first row names the keys. Every cell stays text, so codes and IDs keep their leading zeros.
More transformations
Sorting changes key order recursively, preserving array order. Repair can add or remove content; review its preview. Redaction matches exact property names, ignoring case, and does not guarantee every secret is removed.
Add valid JSON to explore its structure.
JSONPath: $.users[*].name, $..id, $.users[0:2], or $.users[?@.role == "editor"]. JSON Pointer: /users/0/id; ~1 means / and ~0 means ~. Values retain exact numeric text. Filters require safe numbers.
Object key order is ignored; arrays compare by position; numbers compare exactly. The patch transforms source into comparison, with at most 500 changes.
Add, remove, replace, move, copy and test are supported. Failures leave the source intact. Removing the root is rejected because it would leave no JSON document.
Draft-07, 2019-09 and 2020-12 (default). Email, URI and date-time format checks. Local $ref/$defs work; remote references are never fetched. No coercion, defaults or removed values. Up to 100,000 schema characters; operations stop after 20 seconds.
CSV/table view need an array of objects. CSV imports keep cells as strings. YAML aliases, merge keys, custom tags and non-string keys must be expanded or converted first. Types/schemas describe one sample and need review.
Source, comparison and schema text stay in this tab and clear on refresh. Files are not uploaded. The editor never runs pasted JavaScript. Cancel stops the worker without changing your source.
A little help along the way
Say what you want to do: make it readable (Edit, to format or repair), look through it (Explore), turn it into CSV or YAML (Convert) or compare two (Compare). The page says at once whether your JSON is valid. Under More options every workflow has its tab, with Query to select data and Schema to check a contract. Results stay separate until you choose Use result as source.
Questions people ask
- Why are numbers kept in quotes?
- Every cell stays text, so 0001 stays 0001 and a postcode or a date is not guessed or rounded. Change the types afterwards where you know what they should be.
- What does my CSV need?
- Commas between values and a first row of unique, non-empty column names. Every row must have as many cells as the header; quoted cells may hold commas and line breaks.
- How large a file can it convert?
- Up to 200 columns and 100,000 rows, within 5 million characters. Open the file with Open file or drop it on the page; it is read on your device.
This page is the JSON formatter, opened for this one job; every other tool it has is one press away. Each of its settings is explained on the JSON formatter's own page.
Keep going
Guides
- Convert CSV to JSON online without uploading it
- Is it safe to paste JSON into an online formatter?
- Why is my JSON invalid? Common errors and how to fix them
- How to convert JSON to CSV and open it in Excel
- Compare two JSON files, ignoring key order
- JSON formatter and validator online, free, no login
- JSONPath tester online, with examples and JSON Pointer
- Repair broken JSON online, with a preview