JSON to CSV

• CSV to JSON
• CSV to Excel
• CSV Viewer
• CSV Tools

This free JSON to CSV converter runs in your browser. Paste or upload a JSON array of objects (or a single object), and get CSV with nested keys flattened using dot notation. Choose your delimiter, then download the CSV file or copy it to the clipboard.

• Flatten nested objects: Nested keys become columns like address.city or user.profile.name. Arrays and dates are converted to strings.
• Array of objects or single object: Feed a JSON array of objects (e.g. API response) or one object; both are converted to CSV with a header row from the keys.
• Custom delimiter: Choose comma (default), semicolon, tab, or pipe so the CSV works in Excel, regional locales, or downstream tools.
• Paste or upload: Paste JSON directly into the text area or upload a .json file via drag-and-drop or file picker.
• Download and copy: Download the result as a .csv file or copy the CSV to the clipboard in one click.
• Quoted fields: Values that contain the delimiter, quotes, or newlines are automatically quoted in the CSV output.
• Client-side and private: Conversion happens in your browser; nothing is sent to a server.

CSV is widely supported by spreadsheets, databases, and ETL tools. Converting JSON to CSV lets you open API or app data in Excel, Google Sheets, or import it into other systems.

• Spreadsheets: Open the CSV in Excel or Google Sheets for viewing, filtering, or sharing with others who don’t work with JSON.
• Import and ETL: Many databases and data pipelines accept CSV. Flattened columns (e.g. user.name) keep structure in a single table.
• No server: Conversion runs in your browser, so sensitive or large data never leaves your device.

Your JSON is parsed and each object is flattened so nested keys become dot-separated column names. All unique keys across all objects form the header row; each object becomes one row, with missing keys left empty.

• Parse JSON: The tool parses the pasted or uploaded JSON. A single object is treated as one row; an array of objects becomes one row per element.
• Flatten: Nested objects are flattened with dot notation (e.g. {"a":{"b":1}} becomes column "a.b" with value 1). Arrays and Date objects are stringified.
• Build CSV: The header row is the union of all keys (sorted for consistency). Each row is built from the flattened object; values that need quoting are quoted.
• Download or copy: Download the CSV file or copy it to the clipboard. All processing is client-side.

These options control how the CSV is built.

• Delimiter: Comma is the default and standard for CSV. Semicolon is common in European locales; tab produces TSV; pipe is often used in data pipelines. Choose what your target app expects.
• Flattening: Nested objects are always flattened with dot notation. There is no option to keep nested structure; the result is a single flat table with one column per key path.

Match the delimiter to where the CSV will be used.

• Comma (,): Default and most common. Use for generic CSV, imports, and most spreadsheets in English locales.
• Semicolon (;): Common in European locales where comma is the decimal separator. Use when opening in Excel in such regions.
• Tab (\\t): Use for tab-separated values (TSV) or when pasting into tools that expect tabs.
• Pipe (|): Often used in data pipelines and ETL. Use when your downstream system expects pipe-delimited files.

Powered by browser APIs and client-side processing.