TL
Tool Lab
💰Donate
💰Donate

JSON to CSV

Convert JSON to CSV

JSON Input (Array)
CSV Output
About This Tool
The JSON to CSV Converter transforms a JSON array of objects into CSV (Comma-Separated Values) format. It collects all unique keys across every object in the array and uses them as column headers. Objects missing a key produce an empty cell for that column.
Values containing the delimiter, quotes, or newlines are automatically quoted per RFC 4180. Supports comma, tab, and semicolon delimiters. Useful for exporting API responses into spreadsheets that can be opened in Excel or Google Sheets.
How to Use
  1. Choose your preferred delimiter: comma, tab, or semicolon.
  2. Paste a JSON array into the left panel or click Sample.
  3. Click the → CSV button to convert.
  4. Click Copy to copy the CSV output to your clipboard.
Use Cases
Export REST API JSON responses to CSV for Excel or Google Sheets. Convert database query results to spreadsheets for analysis. Transform JSON data dumps into a format accessible to non-technical team members. Convert data formats when legacy systems require CSV instead of JSON.
FAQ
  • What JSON structure is required? — The input must be an array of objects: [{"key": "value"}, ...]. Single objects or arrays of primitives are not supported.
  • What if objects have different keys? — All unique keys across all objects are collected as columns. Objects missing a key produce an empty cell for that column.
  • How are special characters handled? — Values containing the delimiter, quotes, or newlines are automatically wrapped in double quotes per RFC 4180.