How to convert json to csv for google sheets import
- Step 1Drop the JSON file in — Arrays, NDJSON, and single objects are accepted; auto-detect picks the parser.
- Step 2Pick comma delimiter — Sheets' File →’ Import expects comma-separated, even with regional formatting set elsewhere.
- Step 3Open Google Sheets — In a target sheet, choose File →’ Import →’ Upload →’ select the .csv.
- Step 4Choose append or replace — Append for incremental loads; Replace data at selected cell for fresh imports.
Frequently asked questions
Why doesn't Sheets just import JSON?+
Google Sheets has no built-in JSON importer outside Apps Script. CSV is the supported path.
Can I paste the CSV directly into a cell?+
Yes — copy the CSV text, click cell A1, then Edit →’ Paste special →’ Paste values only. Use the tab delimiter for cleanest cell distribution.
Will Sheets parse dates?+
Sheets auto-recognises common ISO dates. If a date column is being misread, format the column as Plain text first, then re-import.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.