JSON ↔ CSV

Convert between JSON and CSV formats

JSON Input1 lines • 58 chars
CSV Output0 lines • 0 chars

About JSON to CSV Converter

1What is it?

Convert JSON arrays to CSV spreadsheet format and vice versa. This tool is perfect for developers and data analysts who need to move data between web applications and spreadsheet software like Excel or Google Sheets. It handles nested objects, arrays, and various data types intelligently, making data migration smooth and painless.

2Use Cases

  • Export API data to Excel or Google Sheets for analysis
  • Import spreadsheet data into web applications
  • Migrate data between different database formats
  • Create reports from JSON API responses
  • Prepare bulk import files for CRM systems
  • Convert analytics data for visualization tools
  • Transform log data for spreadsheet analysis

3Examples

JSON array to CSV

Input

[{"name":"John","age":30},{"name":"Jane","age":25}]

Output

name,age
John,30
Jane,25

CSV to JSON

Input

name,email
John,john@test.com

Output

[{"name":"John","email":"john@test.com"}]

?Frequently Asked Questions

What JSON structure works best for CSV conversion?

Arrays of flat objects work best, like [{"name": "John", "age": 30}, ...]. Each object becomes a row, and properties become columns. Nested objects and arrays are converted to JSON strings within the CSV cell.

Can I choose a different delimiter than comma?

Yes! You can select from comma (,), semicolon (;), tab, or pipe (|) as your delimiter. Semicolon is common in European regions where comma is used as decimal separator.

How does it handle special characters?

Values containing the delimiter, quotes, or newlines are automatically wrapped in double quotes. Existing quotes are escaped by doubling them, following the CSV RFC 4180 standard.

What happens to nested JSON objects?

Nested objects and arrays are converted to JSON strings in the CSV. For example, {"address": {"city": "NYC"}} becomes a cell containing "{\"city\":\"NYC\"}".

Is there a row limit for conversion?

No hard limit. The tool processes data in your browser, so it depends on available memory. Typically, files with hundreds of thousands of rows work fine on modern devices.