CSV and JSON converter
Convert CSV records to JSON and JSON records to quoted CSV.
Bookmark this page
Keep this page handy for next time.
- On a computer
- Press Ctrl + D, or Command + D on a Mac.
- On a phone or tablet
- Open your browser's menu or Share menu and look for Add Bookmark, Bookmark or Add to favourites.
A bookmark saves the page link. Save any tool results separately.
How to use this tool
- Choose the conversion direction.
- CSV input needs unique non-empty column headers; every value stays a string.
- JSON input must be an array of objects. Nested values become JSON text inside their CSV cells.
Things to know
- JSON-to-CSV uses the union of record keys. Missing values become empty cells.
- Each CSV input accepts up to 25 MiB, 100,000 data rows, 10,000 columns and 1,000,000 cells. Expanded tables also count empty cells.
- Generated CSV text is limited to 25 MiB in total, including all split files.
You might also need
More in data & csvCSV splitter
Split CSV data into smaller files while repeating the original headings.
CSV row filter
Keep CSV records matching text or numeric conditions in a selected column.
CSV deduplicator
Remove duplicate CSV records using all columns or selected key columns.
CSV pivot and aggregation
Group CSV records and calculate counts, sums, averages, minimums or maximums.
CSV sorter
Sort CSV records by a named column while retaining all row values.
JSON formatter and validator
Validate and format JSON without rounding large integers.
JSON and JSON Lines converter
Convert a JSON array to JSONL or combine JSON Lines into an array.
JSON and YAML converter
Convert between JSON and YAML while retaining large integer values.
JSON flatten and unflatten
Flatten JSON to JSON Pointer values and rebuild it without losing array types.