Convert JSON to XML or CSV
Paste JSON and turn it into well-formed XML or a CSV file for Excel and Google Sheets. Set the root element or the delimiter, then copy or download. Free and processed in your browser.
ทุกอย่างทำงานภายในเบราว์เซอร์ของคุณ ข้อมูลของคุณจะไม่ถูกอัปโหลดไปยังเซิร์ฟเวอร์ของเรา
XML or CSV
Switch between XML output and CSV output from the same JSON input.
Spreadsheet ready
Nested data is flattened into columns so Excel and Google Sheets open the file cleanly.
Private by design
Conversion runs in your browser. Your data is never uploaded.
Why use our JSON to XML and CSV Converter?
Private and secure
Exports and API data stay on your device. Nothing is uploaded, stored or logged.
Control over the output
Set the XML root name or pick comma, semicolon, tab or pipe for CSV.
Handles nested JSON
Nested objects become dotted columns in CSV and nested elements in XML.
Free forever
No sign-up and no limits. Download data.xml or data.csv in one click.
Free Online JSON to XML and JSON to CSV Converter
This free JSON to XML converter and JSON to CSV converter turns API responses and data exports into formats that other systems and spreadsheets understand. Use the CSV output to open JSON in Excel or Google Sheets, or the XML output for feeds, SOAP style services and legacy imports. It needs no sign-up and runs in your browser.
How to convert JSON to CSV
- Paste a JSON array of objects, for example a list of users or products.
- Select CSV and choose the delimiter that your spreadsheet expects.
- Click Convert. The first row holds the column names.
- Copy the text or download
data.csvand open it in Excel or Google Sheets.
How to convert JSON to XML
Select XML, enter a root element name such as products and click Convert. Object keys become element names, lists repeat the element for every item, and special characters in text are escaped, so the result is well-formed and indented. Keys with spaces or symbols are adjusted to valid XML names.
Flattening nested JSON
CSV is flat, JSON is not. To bridge the gap, nested objects are flattened using dot notation, so {"address":{"city":"Paris"}} becomes a column named address.city. Lists of simple values are joined with semicolons, and lists of objects are kept as JSON text in the cell.
Tips for clean conversions
- Validate first. The input must be strict JSON, so check it with the JSON formatter and validator.
- Use consistent keys across objects. Missing keys simply become empty cells.
- If Excel shows everything in one column, switch the delimiter to semicolon or tab.
- Prefer simple key names with letters, digits and underscores for the cleanest XML.
More free developer tools
After converting, tidy the markup with the XML formatter, or shrink output files with the minify and beautify tool. For database exports, the SQL formatter keeps queries readable. Need to encode a payload for a URL or an email? Use URL encode or Base64 encode, and check the size of your text with the character counter.
Explore all the free utility tools on DailyOnWeb for coding, text, generators and everyday tasks.
คำถามที่พบบ่อย (FAQ)
เครื่องมือที่เกี่ยวข้อง
JSON Formatter
Format, validate and minify JSON online with clear error messages and line numbers.
XML Formatter
Beautify, validate and minify XML in your browser.
Minify and Beautify Code
Minify or beautify JavaScript, CSS and HTML code online. Shrink files or make them readable.
SQL Formatter
Beautify SQL queries with clean indentation and uppercase keywords.