Free tool
GSC Export Analyzer
Paste a Search Console CSV to find striking distance queries, low-CTR rows and question-style queries.
How it works
What is the GSC Export Analyzer?
The GSC Export Analyzer is a free tool that reads a Google Search Console performance export. Paste the Queries or Pages CSV and it shows total clicks and impressions, CTR, impression-weighted average position, striking distance queries in positions 8 to 20, rows with high impressions and low CTR, and question-style queries.
How to use the GSC Export Analyzer
- In Search Console, open Performance, then Search results, and click Export, then Download CSV.
- Open Queries.csv or Pages.csv from the download and copy all of it.
- Paste it into the box, header row included.
- Set the minimum impressions a row needs to be listed.
- Work through the striking distance, low-CTR and question lists.
How do I export data from Google Search Console?
Open the Performance report, set the date range and any filters, click Export at the top right and choose Download CSV. You get a zip file with one CSV per tab: Queries, Pages, Countries, Devices, Dates and others.
Paste Queries.csv or Pages.csv here. The analyzer looks for the Clicks, Impressions and Position columns by name and uses the first other column as the query or page. The interface exports up to 1,000 rows per tab, so large sites see their top rows only.
What are striking distance keywords?
Striking distance keywords are queries where a page already ranks just outside the positions that get most clicks, so a modest improvement could move it into them. This tool lists rows with an average position from 8 to 20 and at least the number of impressions you set, sorted by impressions.
The 8 to 20 range is a common rule of thumb, not a Google definition, and different people draw the line differently. Treat the list as candidates. Check each query's page for search intent, depth and internal links before deciding it is worth the work.
How is average position calculated across rows?
Search Console reports an average position for each query. Averaging those numbers straight across rows gives a query with ten impressions the same weight as one with ten thousand. The analyzer weights by impressions instead: it multiplies each row's position by its impressions, adds the results, and divides by total impressions.
CTR is recomputed the same honest way, as total clicks divided by total impressions, instead of averaging the CTR column.
How does the tool find high-impression, low-CTR queries?
It groups rows in positions 1 to 3 and rows in positions 3 to 10, and computes the CTR of each group from your own export. A row is flagged when it has at least your minimum impressions and a CTR under half of its group's CTR. The two group CTRs are shown under the table.
This is a comparison inside your data, not a benchmark, since CTR by position varies a lot with the type of query and what else is on the results page. For flagged rows, look at the title and description first. The OpenGraph Viewer shows a page's title and description tags.
Why look at question-style queries?
Queries that start with who, what, how, why, can, does or similar words, or end in a question mark, ask for a direct answer. They are the queries most likely to be answered on the results page itself or by an AI assistant, and they tell you which questions your pages are already associated with.
Use the list to check that each question has a clear, short answer on the page under a matching heading. To see whether AI assistants name your brand, run the AI Brand Visibility Checker. For GA4 report exports, use the GA4 Export Analyzer.
Questions
- Why do the totals not match the Search Console chart?
- Search Console leaves rare queries out of the table for privacy, and the export stops at 1,000 rows. The sum of query rows is therefore lower than the totals above the chart.
- Can I paste the Pages export instead of Queries?
- Yes. Totals, weighted position, striking distance and low CTR all work for pages. The question list will usually be empty, since URLs are not questions.
- What minimum impressions should I set?
- It depends on the site and the date range. The default of 100 is only a starting point. Raise it until the lists are short enough to act on.
- How far back can I export Search Console data?
- The Performance report keeps 16 months of data, and you can export any range within that.
- Is the GSC 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.