Turn CSV with a header row into a JSON array of objects
JSON to CSV Converter
Runs locally
Use JSON to CSV Converter
What it does
Convert a JSON array of objects into CSV with one column per key, for example to review IOC or takedown records in a spreadsheet.
It runs entirely in your browser: nothing you enter is uploaded.
Example
Two IOC records
[{"domain":"login.example.com","ip":"192.0.2.10","status":"reported"},{"domain":"verify.example.net","ip":"198.51.100.7","status":"offline","note":"same kit, new domain"}]domain,ip,status,note
login.example.com,192.0.2.10,reported,
verify.example.net,198.51.100.7,offline,"same kit, new domain"Gives four columns (domain, ip, status, note). The first row leaves note empty because only the second object has it, and that note is quoted because it contains a comma.
FAQ
How are the columns chosen?
Every key that appears in any object becomes a column, in the order first seen. Missing values stay empty, and cells containing a comma, a double quote or a line break are quoted with inner quotes doubled, as in RFC 4180.
What input does not work?
The top level must be an array, and a null item stops the conversion with an error. Nested objects are not flattened (they print as [object Object]) and arrays are joined with commas. Cells starting with =, +, - or @ are not escaped, so a spreadsheet may treat attacker-supplied values as formulas.
Is my data uploaded?
No. The CSV is built in your browser and nothing is sent.