Free tool
GA4 Export Analyzer
Paste a GA4 report CSV to see totals, top rows, share of total and high-volume rows with weak engagement.
How it works
What is the GA4 Export Analyzer?
The GA4 Export Analyzer is a free tool that summarizes a CSV exported from a Google Analytics 4 report. Paste the file, comment lines included, and it detects the numeric columns, totals them, ranks the top rows by the metric you choose with each row's share of the total, and flags high-volume rows with weak engagement or conversion.
How to use the GA4 Export Analyzer
- In GA4, open a report and export it with Share this report, Download file, Download CSV.
- Open the file, copy everything and paste it into the box.
- Choose the metric to rank rows by.
- If the export has a rate column, choose which one to compare.
- Read the totals, the top rows and the flagged rows.
How do I export a report from GA4?
Open the report, click the share icon at the top right, choose Download file, then Download CSV. The file starts with a few lines that begin with # and hold the report name and date range, followed by a header row and the data.
Paste the whole thing. The analyzer skips the # lines and blank lines. If the file holds more than one table, it reads the largest one, and it ignores a row labelled total or grand total so the sums are not doubled.
What does the GA4 Export Analyzer calculate?
It treats a column as numeric when at least 80 percent of its cells are numbers, allowing for thousands separators, percent signs and currency symbols. Count columns such as views, users and key events are summed. Rate columns such as engagement rate are recognized by their name or a percent sign and are never summed.
You pick one metric, and it lists the ten largest rows with each row's share of the total. Fields with commas inside quotes, such as page titles, are parsed correctly.
How does it find high-volume, low-engagement rows?
When the export has a rate column, the tool flags rows whose volume is at or above the median row and whose rate is worse than the export's average, weighted by the metric you chose. For bounce rate, worse means higher; for engagement or key event rates, lower.
This is a relative comparison inside your own data, not an industry benchmark. A flagged page is one that gets attention and holds less of it than your other pages do. Whether that is a problem depends on what the page is for.
What is engagement rate in GA4?
Engagement rate is engaged sessions divided by sessions. GA4 counts a session as engaged when it lasts longer than 10 seconds, includes a key event, or has at least two page or screen views. Bounce rate in GA4 is the opposite: the share of sessions that were not engaged.
A page with many views and a low engagement rate is worth opening. Check that it answers the query that brings people in; the Readability Checker and the Heading Checker are quick first looks.
What are the limits of analyzing an export?
The totals are sums of the rows you pasted. If the report was cut off at a row limit, they are totals of those rows, not of the property. Users cannot be added across rows without double counting people who appear in several, so a summed user column overstates unique users.
Numbers are read in the English format, with a dot for decimals. For questions an export cannot answer, such as ordered funnels or cohorts, query the raw data with the BigQuery GA4 Query Library. For Search Console exports, use the GSC Export Analyzer.
Questions
- Which GA4 reports can I paste?
- Any standard report exported as CSV: pages and screens, traffic acquisition, landing pages, events and others. A header row plus rows of numbers is all it needs.
- Can I paste data copied from Google Sheets?
- Yes. Cells copied from a spreadsheet are separated by tabs, and the parser switches to tabs when the first line has tabs and no commas.
- Why is the total for users higher than GA4 shows?
- Because a person who visited three pages is counted on three rows. GA4 deduplicates users in its totals; a sum of rows cannot.
- Why was a column not detected as numeric?
- Fewer than 80 percent of its cells parsed as numbers. Durations written as text, or decimals written with a comma, are the usual cause.
- Is the GA4 Export Analyzer free?
- Yes, with a free spyc.ai account. It runs entirely in your browser, so nothing you type or paste is sent to a server.
Analytics Tools
More in Analytics Tools
GA4 Event Generator
Pick a GA4 recommended or custom event, add parameters, and copy the gtag snippet and dataLayer push.
Generate eventGA4 Measurement Protocol Builder
Build a GA4 Measurement Protocol request: JSON body, collect and debug URLs, and a curl command.
Build requestGTM dataLayer Generator
Write dataLayer.push code for GA4 ecommerce and custom events, with the GTM variables to create.
Generate dataLayerReady when you are
Before your next buyer asks AI about you, ask AI about yourself
One check, four engines, about twenty seconds. We show you the answers before we ask for anything.