CSVJSON ↔ CSV
Loading...
CSV (Comma-Separated Values) is the most widely used tabular data format for database exports, spreadsheets, and log files. This tool converts CSV to a JSON array or exports a JSON array to CSV. JSON→CSV conversion supports nested object flattening, and you can configure delimiters (comma, semicolon, tab, pipe) and whether to include a header row.
How to Use
- 1Select direction
Choose the 'CSV → JSON' or 'JSON → CSV' tab.
- 2Enter data
Paste your CSV or JSON array data on the left, or click 'Load Example' to load sample data.
- 3Configure options
Set the delimiter and header row option. In JSON→CSV mode, enabling flatten nested objects automatically converts {a:{b:1}} into an a.b column.
- 4Review and copy
In CSV→JSON mode, switch between table view and JSON view. Use the copy button to copy the result to clipboard.
Tips
- 💡Convert CSV exported from Excel or Google Sheets to JSON to use it directly as API input.
- 💡European CSV files often use semicolons (;) instead of commas as the delimiter.
- 💡Enable flatten nested objects in JSON→CSV mode to export complex structures as flat CSV.
- 💡All conversions run in your browser — no data is ever sent to a server.
FAQ
- Q. What is the difference between CSV and TSV?
- A. CSV uses commas as delimiters; TSV uses tabs. TSV avoids quoting issues when data contains commas, but CSV is more widely supported by spreadsheets and data tools.
- Q. How are commas and quotes inside values handled?
- A. Per RFC 4180, a field containing commas or quotes is wrapped in double quotes. Internal double quotes are escaped by doubling them: "He said, ""Hello""".
- Q. What types are used when converting CSV to JSON?
- A. All CSV values are strings by default. The tool can optionally auto-convert values that look like numbers to number type and true/false to boolean type.