What is JSON to CSV conversion?
JSON (JavaScript Object Notation) is the standard API response format — arrays of objects with named fields. CSV (Comma-Separated Values) is the universal spreadsheet format that every analysis tool, BI dashboard, and legacy system can import. Converting between them is a daily task for data engineers, analysts, and backend developers: export JSON from an API, import it into a spreadsheet, or take a CSV export and feed it to a service that expects JSON. This tool uses the PapaParse library for robust, RFC 4180-compliant parsing of both formats.
How to use this tool
- 1 In JSON → CSV mode, paste a JSON array of objects — the field names become column headers.
- 2 In CSV → JSON mode, paste CSV with a header row — each row becomes an object.
- 3 Change the delimiter to semicolon, tab, or pipe if your CSV uses a non-standard separator.
- 4 Use the swap button to move converted output back into the input for further conversion.
Frequently asked questions
What JSON shape is supported?
An array of flat objects where each object represents a row and each key represents a column. Nested objects and arrays are not flattened — they will appear as JSON strings in the CSV cell.
What happens to different delimiters?
Change the delimiter selector before converting. The output uses the selected delimiter, and CSV → JSON uses the same delimiter for parsing. Autodetection is not used — always set the delimiter explicitly.
Are quoted fields handled correctly?
Yes. PapaParse correctly handles quoted fields, escaped quotes (doubled ""), newlines inside quoted cells, and fields that contain the delimiter character.
Is PapaParse a server library?
No — it is loaded from jsDelivr CDN and runs entirely in your browser. No data is sent to a server.
Is my data sent anywhere?
No. Conversion runs locally using PapaParse in your browser.