How to convert CSV to JSON and JSON to CSV
Convert a simple CSV table into JSON records or such records back into a table.
What to prepare
You can add: CSV, TSV, JSON. The allowed size and number of files are indicated on the tool page.
Procedure
Add files
Add CSV, TSV or JSON. For JSON, you need a list of records like [{"name":"Anna"},{"name":"Ivan"}]. The values inside the entries should be simple, without other lists or entries.
Select settings
Select a direction and column separator. For CSV → JSON, you can specify column names and types. If titles are not specified, they are taken from the first row of the CSV. If you specified them yourself, the first line is considered data.
Click the button
Read the terms of processing and confirm your consent. Click “CSV/TSV ↔ JSON” and wait until it’s ready. If an error appears, read the message and check the file, text, or settings.
Save and check
Click "Download" on the finished result. Open the result and compare the number of records and field names. In JSON -> CSV, check empty cells for missing values and header order.
Tool Options
Some fields appear after selecting a mode. The default settings are shown here; They are subject to change on the website.
- Direction
Make JSON records from a CSV or TSV table, or make CSV from JSON records.
- Separator
A character between columns, such as a comma or semicolon. Select the one used in the file.
- Headings separated by commas (empty = first line)
Column names separated by commas, without repetitions. If left blank, titles are taken from the first row of the CSV.
- Column types
Column types in order separated by commas: text - text, number - number, bool - true or false. If left unfilled, the values will remain as text.
Good to know
Column names should not be repeated. The tool does not turn complex nested JSON records into a flat table. To store leading zeros, use the text type.
Frequently asked questions
Where is the processing performed?
The file or text is sent to the server for processing. Before starting, read the terms and conditions on the tool page and agree to it. Download the finished result before the expiration date indicated on the page.
What to do if the result is not suitable?
Take the original file or text and try other settings in the steps above. Compare the new result with the previous one. The original files on your device remain unchanged.