The JSON to CSV Converter transforms JSON arrays into comma-separated values and converts CSV data back to JSON. Features a live table preview, custom delimiter support, auto-delimiter detection, optional type inference (numbers, booleans, null), drag-and-drop file upload, a sample loader, and one-click download as a .csv file. Handles large datasets efficiently with no server processing.
Frequently Asked Questions
What JSON structures can be converted to CSV?
Arrays of objects with consistent keys work best. Keys become column headers and each object becomes a row. Nested objects are flattened automatically.
How are nested objects handled?
Nested objects are flattened using dot notation. For example, an address.city field becomes a column header named address.city.
Can I use a delimiter other than comma?
Yes. The tool supports comma, semicolon, tab, and pipe delimiters for compatibility with different spreadsheet applications and locales.
What is the difference between CSV and TSV?
CSV uses commas as separators; TSV uses tabs. TSV avoids ambiguity when data values themselves contain commas.