CSV ↔ JSON Converter

Convert CSV data to JSON or JSON arrays back to CSV. Supports custom delimiters, quoted fields, and automatic type inference.

CSV Input

FAQ

What CSV format is supported?▼

RFC 4180-compliant CSV. Fields with delimiters or quotes must be quoted with double-quote characters. Doubled double-quotes represent a literal quote.

Does JSON to CSV support nested objects?▼

Nested objects are converted to strings. For deeply nested data, flatten your JSON before converting.

Can I change the delimiter to semicolon?▼

Yes. Use the delimiter selector to switch between comma, semicolon, tab, and pipe separators.

Frequently Asked Questions

Does the CSV parser handle quoted fields?

Yes. The parser is RFC 4180-compliant and correctly handles quoted fields containing commas, newlines, or escaped double quotes.

What delimiters are supported?

Comma (,), semicolon (;), tab, and pipe (|) are supported. You can also specify a custom delimiter character.

Can I convert JSON back to CSV?

Yes. The tool works bidirectionally — paste JSON arrays of objects to get CSV output, or paste CSV to get a JSON array. Array keys become column headers.

What is CSV?

CSV (Comma-Separated Values) is a plain-text format for tabular data. Each line represents one row; values within a row are separated by a delimiter — usually a comma, though semicolons and tabs are also common. The first row typically contains column headers.

name,age,city
Alice,30,London
Bob,25,New York

CSV is universally supported by Excel, Google Sheets, databases, and virtually every data processing tool. Its simplicity and human-readability make it the most common format for exchanging tabular data between different systems.

CSV vs JSON: Which Should You Use?

FeatureCSVJSON
Data structureFlat table (rows × columns)Nested / hierarchical
Native data typesAll strings (no types)String, number, boolean, null, array, object
Spreadsheet support✅ Native in Excel / Sheets❌ Requires conversion
REST API exchange⚠️ Limited✅ Standard
File size (tabular data)SmallerLarger (repeated keys)

Common CSV Use Cases

  • Data exports — CRM, e-commerce, and analytics platforms export orders, customers, and reports as CSV for analysis in spreadsheet tools.
  • Database imports — Bulk-load thousands of records into MySQL, PostgreSQL, or SQLite using native CSV import commands.
  • API integration — Convert CSV to JSON before sending tabular data to REST APIs that require JSON payloads.
  • Machine learning datasets — CSV is the standard format for ML training data in Python (pandas, scikit-learn, TensorFlow).
  • Configuration and seed data — Pre-populate application databases from CSV files instead of hardcoding values.