Drop your Search Console ZIP
Read in your browser. Never uploaded.
How it works.
You need access to the site in Google Search Console. The whole thing takes about a minute.
Export from Search Console
Open Performance → Search results, pick a date range, then choose Export → Download CSV. Google gives you one ZIP file.
Drop the ZIP above
No need to unzip it. Your browser reads the Queries and Pages tables. Nothing is uploaded.
Work down the list
Keywords are sorted by estimated extra clicks. Filter, change the position range, then download a CSV or copy a Markdown table.
What it finds.
Every number comes from your own export, so you can check it against Search Console.
Keywords close to the top
Queries at positions 4–20 with real impressions. These are searches where Google already shows your page.
The size of each win
Extra clicks are estimated from your site's own click-through rate at each position, not an industry average.
Pages to work on first
Switch from Queries to Pages to see which URLs sit just off the top spots across everything they rank for.
Questions.
What are striking distance keywords?
Searches where your site already ranks just outside the top results, usually positions 4 to 20. Google already considers your page relevant, so a small improvement can move it to where most clicks happen. They are also called low-hanging fruit keywords.
Is my Search Console data uploaded?
No. The export is read and analyzed in your browser and is never sent to our server. It is saved in your browser so it survives a refresh, and “Clear my data” removes it.
How are the extra clicks worked out?
The tool builds your site's own click-through rate for each ranking position from the export. For every keyword it takes the rate three places higher, multiplies it by the keyword's impressions and subtracts today's clicks. The result is capped at about double the current clicks. It is an estimate, not a promise.
Why is the list shorter than my Queries report?
Search Console's export keeps the top 1,000 queries and hides rare ones for privacy. By default the tool also skips keywords with very few impressions, because their average position isn't reliable. Lower “Min. impressions” to see more.
Can I change the position range?
Yes. The default is 4 to 20. Set 11 to 20 to see only page-two keywords, or 4 to 10 for keywords already on page one.
What should I do with the list?
Start at the top. Check that the page answers the search fully, put the keyword in the title and a heading where it reads naturally, and link to the page from related pages on your site. Switch to Pages to see which URLs to work on first.
Related tools.
They read the same export, so a file you've loaded here opens there too.
GSC Export Analyzer
/tools/gsc-export-analyzer/Drop a Google Search Console export. See what's growing, what's slipping, and why.
LiveFree02Feed-to-Page Checker
/tools/feed-to-page-checker/Check that a product page matches its Merchant Center feed and explains what shoppers need to know.
Live1 free auditHear what your data isn't saying.
One email a week with the findings, experiments and tools we ship.