JSON to CSV
Structured data out, spreadsheet in. The circle of enterprise life.
Input
Output
What this does
DEVS: Flattens an array of objects to CSV via PapaParse. Nested objects get dot-notation keys. Client-side only.
Paste a JSON array of objects, get CSV. Object keys become column headers. Values become rows.
Common use cases
Getting API data into a spreadsheet. You pulled JSON from an endpoint and now someone wants it in Excel.
Creating reports from structured data. JSON is great for machines. CSV opens in every spreadsheet app on earth.
Things to know
Works best with an array of flat objects (same keys, primitive values). Nested objects get flattened with dot notation. Inconsistent keys across objects are handled by unioning all keys into the header row.
Privacy
Conversion happens entirely in your browser. Your JSON stays local.