Why This Tool Exists
Google Analytics Query Explorer is a powerful free tool for building custom GA data queries. However, Google removed the ability to export results directly to Excel or CSV โ leaving analysts with a raw JSON response and no easy way to get that data into a spreadsheet.
What is Google Analytics Query Explorer?
Google Analytics Query Explorer is the preferred tool for analysts who need to access and extract data directly from Google Analytics. Available at ga-dev-tools.google/ga4/query-explorer/, it allows you to build fully custom reports by selecting your own dimensions and metrics, giving you precise control over the data you extract โ far beyond what the standard GA4 interface offers.
How to Export GA Query Explorer Data to Excel
Since the native Excel export was removed, the easiest workflow is: run your query in Query Explorer โ copy the JSON response โ paste it into this converter โ click download. Your data is formatted into a clean spreadsheet with proper column headers and rows. No code required.
Privacy & Security
All conversion happens locally in your browser using JavaScript. Your analytics data is never sent to any server. This is especially important for analytics data which may be confidential or commercially sensitive.