JSON to CSV Converter
- , (comma)
- ; (semicolon)
- \t (tab)
How to Use
Paste a JSON array into the input. If the elements are objects, their keys become the CSV column headers; if they are primitives, they become a single-column table labeled "value". Choose a delimiter (comma, semicolon, or tab for TSV), toggle whether to include a header row, and optionally force every field to be quoted. The CSV output updates in real time and can be copied with one click.
What Is CSV
CSV (Comma-Separated Values) is a plain-text tabular format widely accepted by spreadsheets (Excel, Google Sheets, Numbers), databases, and data-analysis tools. Each line is a row; cells are separated by a delimiter (usually a comma). Cells that contain the delimiter, a quote, or a newline are wrapped in double quotes, and internal quotes are escaped by doubling them. This implementation follows RFC 4180.
Conversion Behavior
Keys are unioned across all rows, so missing keys produce empty cells rather than errors. Nested objects and arrays are stringified as JSON ({"x":1}) inside a single cell — if you need flattened columns, pre-process the JSON first. null and undefined become empty cells. Numbers and booleans are emitted as their literal string form. The tool rejects mixed arrays that combine primitives and objects.
Common Use Cases
- Exporting API responses into spreadsheet-ready CSV for business users.
- Transforming JSON logs into CSV for data analysis in Excel or Pandas.
- Preparing JSON data for import into databases or ETL pipelines that expect CSV.
- Quick ad-hoc conversion during debugging to compare records at a glance.
- Generating sample CSV files from API fixtures for testing.
Tips
- Choose the semicolon delimiter when exporting for European locales that use comma as the decimal separator.
- Tab delimiter produces TSV, which is also accepted by Excel and avoids quoting for most content.
- Toggle 'Quote every field' when downstream consumers expect RFC 4180 strict mode.
- Omit the header row when concatenating multiple CSVs that already share a single header elsewhere.
- Nested objects are stringified as JSON inline — run the data through a flattening step first if you need proper columns.
Privacy
All JSON parsing and CSV encoding happens in your browser. Your data is never sent to any server or stored anywhere.