> json | csv | convert <
// Convert between JSON and CSV formats instantly
JSON↔CSV Conversion
Convert JSON arrays to CSV and CSV back to JSON with a single click.
CSV Export
Download converted CSV files directly to your computer. Ready for Excel or Google Sheets.
Custom Delimiters
Choose from comma, semicolon, tab, or pipe delimiters. Supports all major CSV formats.
// ABOUT JSON TO CSV CONVERSION
How It Works:
JSON arrays of objects are converted to tabular CSV format by extracting all unique keys as column headers, then mapping each object's values into rows. CSV parsing follows RFC 4180, properly handling quoted fields, escaped quotes, and custom delimiters.
Example:
[{"name":"Alice","age":30}] → name,age\nAlice,30
Common Use Cases:
- >Export API response data to spreadsheets
- >Convert database JSON exports to CSV
- >Prepare data for data analysis tools
- >Import CSV data into JSON-based applications
- >Batch data format conversion
>> frequently asked questions
Q: What is the difference between JSON and CSV?
A: JSON (JavaScript Object Notation) is a hierarchical data format that supports nested objects and arrays. CSV (Comma-Separated Values) is a flat, tabular format where each row represents a record and columns are separated by a delimiter. JSON is more flexible, while CSV is simpler and widely supported by spreadsheets.
Q: How does the converter handle nested JSON objects?
A: Nested JSON objects and arrays are serialized as JSON strings within the CSV cell. For example, {"address":{"city":"NYC"}} becomes a quoted JSON string in the CSV output.
Q: How are special characters handled in CSV?
A: Values containing the delimiter character, double quotes, or newlines are automatically wrapped in double quotes per RFC 4180. Double quotes within values are escaped by doubling them (e.g., "" becomes """").
Q: Which delimiter should I use?
A: Comma is the most common delimiter and works with most applications. Use semicolons for European locales where commas are decimal separators. Tab-separated files (TSV) work well with copy-paste from spreadsheets. Pipe delimiters are common in Unix/Linux environments.
Q: Is the output compatible with Excel?
A: Yes, the generated CSV follows RFC 4180 standards and is fully compatible with Microsoft Excel, Google Sheets, LibreOffice Calc, and other spreadsheet applications. Use the Download button to save as a .csv file.