JSON ↔ CSV Converter

How to use JSON ↔ CSV Converter

1. 1
   Choose conversion direction

   Select JSON → CSV to convert a JSON array to a spreadsheet-friendly format, or CSV → JSON to parse CSV rows into a JSON array.

2. 2
   Paste or type your data

   Enter your JSON array or CSV text into the input field. JSON must be an array of objects. CSV must have a header row.

3. 3
   Configure options

   Choose your delimiter (comma, semicolon, or tab), and toggle whether to include a header row. For nested JSON objects, enable the flatten option to collapse nested keys with dot notation.

4. 4
   Review the output

   The converted result appears in the output panel with row and column counts shown. Review it before downloading.

5. 5
   Download or copy

   Click Download to save the file as .csv or .json, or use the Copy button to copy the output to your clipboard.

Frequently Asked Questions

What JSON format is supported for JSON → CSV conversion?

The tool expects a JSON array of objects, where each object represents a row and its keys become the column headers. For example: [{"name":"Alice","age":30},{"name":"Bob","age":25}]. Nested objects are flattened using dot notation (e.g., address.city) when the flatten option is enabled.

Can I convert CSV files with different delimiters?

Yes. The tool supports comma (,), semicolon (;), and tab (\t) delimiters. Select the matching delimiter before pasting your CSV data. Semicolon-delimited files are common in European locales where commas are used as decimal separators.

Does the tool handle quoted fields with commas inside?

Yes. The CSV parser correctly handles RFC 4180 quoting — fields containing commas, newlines, or double quotes are wrapped in double quotes, and internal double quotes are escaped as "". For example: "Smith, John",30 is parsed as a single field.

What happens to missing fields in JSON → CSV?

The tool collects all unique keys across all objects in the array as column headers. If an object is missing a key that others have, that cell is left empty in the CSV output.

Is there a size limit for conversions?

There is no hard limit — the tool runs entirely in your browser. However, very large files (10MB+) may take a moment to process. All processing is local; no data is uploaded.

Related Tools