How to convert ga4 / mixpanel json export to csv
- Step 1Export from the analytics platform — GA4: Reporting API JSON. Mixpanel: /export endpoint NDJSON. Amplitude: bulk export ZIP (extract to NDJSON).
- Step 2Drop the JSON or NDJSON in — Auto-detect handles arrays and JSON Lines. Force-pick NDJSON for very large event files.
- Step 3Leave flattening on — event_params, user_properties, and event_data nesting become dot-notation columns.
- Step 4Open in Excel or load to a notebook — Excel for ad-hoc filtering; pandas read_csv for deeper analysis or charting.
Frequently asked questions
How are GA4 nested params handled?+
event_params is an array of {key, value} objects in GA4 BigQuery export. Flattening renders that array as a JSON literal — pre-pivot in BigQuery if you want one column per parameter.
Can I run this on a 1 GB Amplitude export?+
Browser memory is the practical limit. For multi-gigabyte files, split the NDJSON with the CSV Row Splitter approach (or shell split -l) and convert each chunk.
Will the file leave my machine?+
No. Conversion is fully client-side — analytics data and any PII inside it never reach JAD Apps servers.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.