JSON to CSV converter New
Turn a JSON array into a table you can sort and filter, and download it as CSV for Excel or Google Sheets. Converts CSV back to JSON too.
Convert JSON, YAML, XML and CSV online
Need a YAML configuration as JSON, an XML feed as CSV or a spreadsheet export as JSON? Paste it, pick the format you need and copy the result.
Runs in your browser. Nothing is uploaded.
Loading the data converter…
How to use the data converter
-
Paste your data or open a file. Toolbox recognises the format.
-
Choose the format to convert to, with options such as the indentation or the CSV separator.
-
Copy the result or download it as a file.
Frequently asked questions
How is XML converted to JSON?
Elements become keys, attributes get an @ in front of their name and text next to child elements is kept under #text. An element that occurs more than once becomes a list. Converting the JSON back gives the same XML.
What happens with nested data in CSV?
CSV is a flat table. Nested objects become columns with dotted names, such as address.city, and lists are written as JSON text in a cell. Converting that CSV back to JSON rebuilds the nesting.
Related tools
-
-
JSON formatter New
Format, validate and minify JSON, and explore it in a collapsible tree with a filter for keys and values. Errors are shown by line and column.
-
JSON to TypeScript New
Generate TypeScript interfaces or types from a JSON example, with nested objects, arrays, optional keys and union types. Copy them in one click.
-
JSONPath tester New
Query JSON with JSONPath: select fields, filter arrays on conditions and sort the results. Includes examples and a cheat sheet.