Learn · Data
Common JSON to CSV Mistakes
JSON can represent nested objects, arrays, optional fields, and mixed shapes. CSV expects rows and columns. Most conversion problems come from that mismatch.
Nested objects do not become perfect columns automatically
A simple array of objects converts cleanly. Deep objects, arrays inside rows, and records with different shapes usually need cleanup first. Decide whether nested values should be flattened, summarized, or left out before expecting a spreadsheet-friendly result.
Missing keys create empty cells
If one object has email and another object does not, the CSV will still include the email column and leave that row empty. That is normal, but it can look like data loss if you were expecting every row to have the same fields.
Arrays need a rule
Arrays can be joined into one cell, expanded into multiple rows, or converted before import. Pick the rule that matches the destination. A spreadsheet for review may accept joined values; an import system may require one row per item.
Preview before export
Always check the first rows and headers before downloading. If headers look wrong, fix the JSON shape before converting again.
Convert JSON
Use JSON to CSV for object arrays and spreadsheet handoffs.
Clean CSV first
Read Clean CSV Before Import if the next step is an upload.
Before you convert data files
Data converters are most reliable when the source file is clean before conversion. Check headers, repeated records, delimiters, blank rows, and unexpected nested fields. A converter can preserve structure, but it cannot know the meaning of unclear source data.
Before using the export in another system, compare a few rows against the source file. Look for shifted columns, empty fields, escaped quotes, and values that should stay as text, such as IDs or postal codes. Small cleanup before conversion prevents larger import mistakes later.
- Keep headers unique and stable.
- Preview row counts before using the export elsewhere.
- Save the original file before cleaning or converting it.
After downloading the result, open it once before using it in a client send, upload form, website, or archive. This final check catches format support issues, unexpected file size changes, missing characters, clipped media, or page-order mistakes while the original file is still available.
If the output will be reused, note the settings that produced it. That makes the next export easier to repeat and reduces guesswork when another file needs the same treatment.