Developer Tools
Convert JSON to CSV
Convert JSON arrays or objects to spreadsheet-ready CSV output.
Direct Answer
Use the JSON To CSV Converter when API data, exports, or structured records need to open in Excel, Google Sheets, BI tools, or import systems as rows and columns.
What Converts Cleanly From JSON to CSV
CSV is a flat, row-and-column format, so JSON to CSV conversion works best on an array of objects that share a similar flat structure, where each object becomes one row and each key becomes a column.
- An array of flat objects with consistent keys maps directly to rows and columns
- Column headers are generated from the union of keys across all objects
- Missing keys in some objects typically produce empty cells rather than errors
- A single JSON object, not an array, is usually converted into a single-row CSV
Where JSON Structure Gets Lost in CSV
Nested objects, arrays of arrays, and mixed data types do not have a natural CSV representation, so the converter has to make a decision that may not match what you expect.
- Nested objects are often flattened into dot-notation columns like address.city
- Arrays inside a field are usually joined into a single delimited string or JSON-encoded text
- Fields containing commas, quotes, or line breaks must be quoted and escaped per the CSV spec
- Deeply nested or irregular records may need reshaping before conversion produces a usable spreadsheet
Complete the Workflow
Use these sibling tools together as a focused workflow instead of treating each page as a one-off utility.
How to Use JSON To CSV
- Paste or type your content into the input box.
- The transformed result appears instantly in the result panel below.
- Click Copy result to copy the output to your clipboard.
- Download .txt saves the transformed text as a file.
- Reset clears everything and lets you start over.
Reference
| Feature | Details |
|---|---|
| Purpose | Transform pasted text into a cleaner or different format. |
| Input | Text, lines, lists, or copied content. |
| Result | Transformed text ready to copy or download. |
| Best for | Cleanup, formatting, list preparation, and copy-paste workflows. |
| Category | Developer Tools |
| Works on | Desktop, tablet, and mobile browsers |
Useful Related Tools
Frequently Asked Questions
How do I turn a JSON array into a spreadsheet?
Convert the JSON array of objects to CSV, then open the result directly in Excel or Google Sheets, since CSV is a format both understand natively. Each object in the array becomes one row, and each unique key across the objects becomes a column header.
What happens to nested JSON objects when converting to CSV?
CSV has no concept of nesting, so a nested object such as an address field with a city inside it is typically flattened into a column named address.city. If your converter does not flatten nested fields automatically, they may appear as a raw JSON string in a single cell instead, which is harder to filter or sort in a spreadsheet.
What happens to arrays inside JSON objects when converting to CSV?
An array value, such as a list of tags, has no direct CSV equivalent, so it is usually joined into one cell as a delimited string or serialized as a JSON string. Either approach loses the ability to filter on individual array items directly in spreadsheet software without further processing.
Why does my CSV have missing columns for some rows?
If the objects in your JSON array do not all have the same keys, the converter fills in the missing values as empty cells for objects that lack a given key, while still including that column in the header row based on objects that do have it. Check your source data if you expected every row to have a value for every column.
Why do some CSV values have extra quotes around them?
Any field containing a comma, a double quote, or a line break must be wrapped in double quotes per the CSV specification, or the file would be misread when opened elsewhere. Quotes inside the value itself are also escaped by doubling them, which is expected CSV behavior, not a conversion error.
Can I convert a single JSON object, not an array, to CSV?
Yes, a single object is typically converted into a two-row CSV: one header row of keys and one data row of values, or sometimes a two-column key-value layout depending on the tool. If you have many similar single objects, wrap them in an array first to get one row per object instead.
Why did my CSV import lose the original JSON data types?
CSV stores everything as plain text, so numbers, booleans, and null all become text values with no type information once converted. A number like 42 and a string like "42" look identical in CSV, so you will need to re-parse them explicitly when reading the CSV back into a program if types matter.
How do I handle a JSON field that already contains a comma when converting to CSV?
A correct CSV converter automatically wraps any field containing a comma in double quotes so spreadsheet software does not misinterpret it as a column separator. If you open the resulting file and see a field's comma splitting it into two columns, the CSV was not quoted properly and needs to be regenerated.