Search Console Export Analyzer

Drop your Google Search Console export — ZIP, CSV or Excel — and get striking-distance keywords ranked by click potential, queries and pages with below-benchmark CTR, trends, countries, devices, clusters and questions. Everything is computed in your browser: the file goes nowhere.

Drop your Search Console export here or click to choose

The whole ZIP from “Export → Download CSV”, single CSV files, Excel (.xlsx) or a CSV from Google Sheets. Several files at once are fine.

Brand terms (comma-separated)

Min. impressions

Target position for potential

The file is read in your browser and is never sent to our server — we never see your queries or page URLs. We only keep an anonymous usage counter (how many files and rows).

Google Search Console export analyzer

The Search Console Performance report shows a thousand rows of queries but not where to start. This tool reads your export (the “Download CSV” ZIP, single CSVs, Excel or a Google Sheets CSV) and sorts it by value: striking-distance keywords in positions 8–20 ranked by click potential, queries and pages whose CTR is below average for their position, week-over-week trend, countries, devices, branded vs non-branded, clusters by shared words and question queries. Column headers are recognised in English, Russian, Ukrainian, Polish and other interface languages. The file never leaves your browser.

Striking distance: queries in positions 8–20 sorted by click potential

Below-benchmark CTR for queries and pages, with missed clicks

Daily chart, week over week, countries, devices, search appearance

Branded vs non-branded, word clusters, questions for FAQ

ZIP, CSV, Excel, Google Sheets; export every report to CSV

How to Use

In Search Console open Performance → Search results, pick a date range (3 months works well) and click Export → Download CSV
Drop the downloaded ZIP into the box — no need to unzip it
Start with the striking-distance and CTR-gap tables, then export the reports you need to CSV

FAQ

No. The ZIP is unpacked and the CSV or Excel files are parsed by JavaScript in your browser. Queries and page URLs are not sent anywhere; we only keep an anonymous counter of how many files and rows were processed.

Queries where a page already ranks at the bottom of page one or on page two (here: positions 8–20). They get impressions but few clicks, because CTR on page two drops to fractions of a percent. Moving up a few positions multiplies clicks, and it is cheaper than ranking a page from scratch.

Two reasons. Google hides anonymized (rare) queries — they count in site totals but not in the queries table. And the UI export is capped at 1,000 rows per table. If the ZIP includes the dates table, the tool shows what share of site clicks the exported queries cover.

It is an estimate from an industry-average CTR curve: impressions × (CTR at the target position − your current CTR). Ads, AI answers, maps and brand queries can shift real CTR several-fold, so use the number to compare queries with each other, not as a forecast. SEO Radar estimates more precisely, adjusting for your own site’s CTR and competitor strength.

No: that needs query + page pairs, and the UI export gives queries and pages as separate tables. Export the pairs via the API or Looker Studio and check them with the Keyword Cannibalization tool — or connect Search Console to SEO Radar, which detects cannibalization automatically.

How to export your data from Search Console

Open Search Console → Performance → Search results for your property.
Pick a date range. The last 3 months works well for finding opportunities: enough data, little seasonal noise. Use Compare mode for before/after checks.
Add filters if you need them (country, device, page) — they are saved in Filters.csv and shown in the summary.
Click Export in the top right and choose Download CSV (or Download Excel, or Export to Google Sheets).
Drop the downloaded ZIP into the box above. No need to unzip it.

The archive holds separate tables: queries, pages, countries, devices, search appearance, dates and filters. File names depend on your interface language, so the tool recognises each table by its column headers and contents rather than by file name. If you exported to Google Sheets, download the sheets you need via File → Download → CSV and drop them in together.

Export limits to keep in mind

1,000 rows per table. Queries and pages beyond row 1,000 are not in the file. For a large site, export section by section (page filter) or use the API.
Anonymized queries. Google hides rare queries for privacy. They count in site totals but are missing from the queries table, so query clicks almost always add up to less than the report total.
No query + page pairs. Queries and pages are exported separately, so this export cannot tell you which page ranks for which query, and it cannot reveal cannibalization.
The last 2–3 days are incomplete. A small dip at the end of the chart usually means the data has not fully arrived yet.

How to read the reports

Striking distance keywords (positions 8–20)

Queries where you already rank at the bottom of page one or on page two and get impressions. The table is sorted by potential: impressions × (CTR at the target position − your CTR). Average CTR by position comes from public industry studies: roughly 27% at position 1, 11% at position 3, 2–3% at positions 9–10 and under 1% on page two. It is a benchmark, not a promise, but it is a good way to decide which queries to push first.

CTR below benchmark

Top-10 queries where your CTR is less than half the average for that position. You have the ranking but not the clicks, so the problem is the snippet or the SERP itself. Check how the page looks in SERP Preview, whether the title answers the query, and whether ads, an AI answer or a competitor’s rich result sits above you. High CTR on your own brand queries and low CTR on other brands’ queries is normal.

Pages

Top pages by clicks show what your traffic depends on. Pages with many impressions and below-benchmark CTR are the first candidates for a title and description rewrite. Note that a page’s position in GSC is the average across all its queries, so it is coarser than a query position.

Trend, countries, devices

The daily chart and the “last 7 days vs previous 7” comparison show whether the site is growing or slipping. In countries and devices, look for imbalances: mobile CTR far below desktop often points to mobile UX issues or a truncated title.

Brand, clusters and questions

Enter your brand name and the tool separates branded from non-branded traffic — non-branded is what SEO actually earns. Clusters group queries by shared words: a large cluster with an average position beyond 10 suggests the topic deserves its own strong page. Question queries (how, what, why) are ready-made subheadings and FAQ entries.

What to do next

Take the 10–20 striking-distance queries with the highest potential and find the page that ranks for each (filter by query in GSC → Pages tab).
Strengthen that page: cover the query’s topic fully, add internal links from relevant pages, check the title and H1.
For low-CTR queries, rewrite the title and description and check the tags in Meta Analyzer.
If pages compete with each other, export query + page pairs and run them through the cannibalization checker.
After 2–4 weeks, export the same length of period again and compare, or spot-check single queries with the Google rank checker.

Doing this without manual exports

SEO Radar connects to Search Console once via Google OAuth (read-only) and runs this analysis for you — on all your data, not 1,000 rows. It finds pages in positions 6–20, estimates potential adjusted for your site’s real CTR and competitor strength, flags cannibalization, shows visits from ChatGPT, Perplexity, Gemini and Claude (with GA4 connected), and records positions and clicks before a promotion starts and after 30, 60 and 90 days. The analysis in Radar is free.