How to convert data between formats
- Paste your data into the left box, or press "Open file". The format is detected for you.
- Choose the format you want under "To". Adjust indent, delimiter, or other options if you need them.
- Copy the result, or download it as a file. "Swap input and output" moves the result to the left to convert back.
Tables (CSV, TSV, Markdown, HTML, SQL INSERT, and JSON Lines) need a list of records. If your JSON, XML, or YAML wraps the list in a single key, such as {"users": [...]}, the tool finds it. Nested values are flattened into columns such as address.city, and lists inside a record are kept as JSON text in one cell.
Supported conversions
Any of these formats can be converted to any other: JSON, YAML, CSV, TSV, XML, TOML, JSON Lines, Markdown table, HTML table, and SQL INSERT statements.
- JSON to YAML
- JSON to CSV
- JSON to TSV
- JSON to XML
- JSON to TOML
- JSON to JSON Lines
- JSON to Markdown table
- JSON to HTML table
- JSON to SQL INSERT
- YAML to JSON
- YAML to CSV
- YAML to TSV
- YAML to XML
- YAML to TOML
- YAML to JSON Lines
- YAML to Markdown table
- YAML to HTML table
- YAML to SQL INSERT
- CSV to JSON
- CSV to YAML
- CSV to TSV
- CSV to XML
- CSV to TOML
- CSV to JSON Lines
- CSV to Markdown table
- CSV to HTML table
- CSV to SQL INSERT
- TSV to JSON
- TSV to YAML
- TSV to CSV
- TSV to XML
- TSV to TOML
- TSV to JSON Lines
- TSV to Markdown table
- TSV to HTML table
- TSV to SQL INSERT
- XML to JSON
- XML to YAML
- XML to CSV
- XML to TSV
- XML to TOML
- XML to JSON Lines
- XML to Markdown table
- XML to HTML table
- XML to SQL INSERT
- TOML to JSON
- TOML to YAML
- TOML to CSV
- TOML to TSV
- TOML to XML
- TOML to JSON Lines
- TOML to Markdown table
- TOML to HTML table
- TOML to SQL INSERT
- JSON Lines to JSON
- JSON Lines to YAML
- JSON Lines to CSV
- JSON Lines to TSV
- JSON Lines to XML
- JSON Lines to TOML
- JSON Lines to Markdown table
- JSON Lines to HTML table
- JSON Lines to SQL INSERT
- Markdown table to JSON
- Markdown table to YAML
- Markdown table to CSV
- Markdown table to TSV
- Markdown table to XML
- Markdown table to TOML
- Markdown table to JSON Lines
- Markdown table to HTML table
- Markdown table to SQL INSERT
HTML table and SQL INSERT are output only.
Questions
Is my data uploaded?
No. Every conversion runs in your browser, so customer lists, API responses, and config files never leave your device.
How do I convert CSV to JSON, or JSON to CSV?
Paste the CSV, or open the file, and leave "To" on JSON. For the other way, paste the JSON and pick CSV. The tool detects commas, semicolons, and tabs. Nested JSON becomes columns with dotted names such as address.city.
How does YAML to JSON, XML to JSON, or TOML to JSON work?
The input is read into plain data (objects, lists, text, numbers) and written out in the format you choose. XML attributes appear with an @_ prefix, and text next to attributes is stored as #text, so converting back keeps them.
What happens when the input has a mistake?
You get the line and column of the problem for JSON, YAML, XML, TOML, and JSON Lines, or the row for CSV. Fix that spot and the result updates as you type.
Which formats can the tool detect?
With "From" on Auto-detect it recognizes JSON, JSON Lines, YAML, CSV, TSV, XML, TOML, and Markdown tables from the content or the file name. If a short snippet is guessed wrong, pick the format yourself.
Credits
Built on Papa Parse (MIT), js-yaml (MIT), fast-xml-parser (MIT), fast-xml-builder (MIT) and smol-toml (BSD-3-Clause). OneTooling is not affiliated with these projects.