JSON to CSV Converter
Convert JSON arrays to CSV format. Handles nested objects by flattening keys. Configure delimiter and download. Quick way to get API responses into Excel or Google Sheets.
Discover More Free Tools
How to Use This Tool
- Paste your JSON array data into the input field.
- Click 'Convert' to transform the JSON into CSV format.
- Preview the CSV output and verify the column alignment.
- Copy the CSV data to paste into Excel, Google Sheets, or save as a .csv file.
Related Tools
CSV to JSON Converter
Convert CSV data to structured JSON. Auto-detects headers and generates either an array of objects or a column-based structure. Handles quoted fields and different delimiters.
Base64 Encoder/Decoder
Encode text to Base64 and decode Base64 back to readable text. Works with standard Base64 and URL-safe variants. Quick way to embed data in URLs or decode API responses.
Image to Base64
Convert any image to a Base64 data URI string. Drag and drop, get the encoded string with the correct MIME type prefix. Copy directly into CSS or HTML.
Frequently Asked Questions
What format should my JSON be in?
Your JSON should be an array of objects where each object represents a row. For example: [{"name":"John","age":30},{"name":"Jane","age":25}]. Nested objects are flattened into columns.
Can I convert nested JSON to CSV?
Yes. Nested objects and arrays are automatically flattened. Nested keys are joined with dots (e.g., 'address.city' becomes a column name) to create a flat CSV structure.
What delimiter does the CSV use?
The converter uses commas as delimiters by default. If your data contains commas, values are properly quoted to prevent formatting issues.
Can I use this with API data?
Yes. If your API returns JSON array data, simply copy the response and paste it into the converter. This is commonly used to export API results to spreadsheets for analysis.
Does this tool handle nested JSON objects?
Our JSON to CSV converter flattens nested objects using dot notation (e.g., user.name). Arrays within objects are converted to comma-separated strings. Each top-level object becomes a CSV row.