GSC Performance CSV Analyzer
Google Search Console shows how your site performs in search — but its web interface makes it hard to spot the keywords sitting just off page one. Paste your Performance export below and this free analyzer totals your clicks and impressions, ranks your top queries, and surfaces striking-distance keywords.
Everything runs in your browser — your CSV never leaves your device. Works with Query exports and Page exports.
Your Search Console Summary
Top 10 by clicks
Striking distance — positions 11–20
These queries are on page 2 of Google. A small improvement can move them onto page 1, where most clicks happen.
High impressions, low CTR
Queries with above-median impressions and below-average CTR — Google shows them often, but searchers rarely click. A better title or description may help.
How It Works
The analyzer reads your Performance export — the same CSV Search Console produces — and works out four things. Totals: total clicks, total impressions, average CTR (total clicks ÷ total impressions) and average position, weighted by impressions so the queries Google shows most often count most. Top 10 by clicks: the queries already bringing you traffic. Striking distance: queries in positions 11–20, sorted by impressions. High impressions, low CTR: queries with above-median impressions but below-average CTR, where a better title or description could win more clicks from the visibility you already have. A SERP preview tool shows how the improved title and description will look in Google.
The CSV parser handles the quirks of real exports: quoted fields that contain commas, escaped quotes, and Windows line endings. Rows with missing or non-numeric values are skipped and counted, so one bad row never breaks the analysis. Everything happens in your browser — the file is never uploaded.
Worked Example
Five rows — mortgage calculator (120 clicks, 4,000 impressions, position 8.2), salary calculator uk (45, 1,500, 12.4), bmi calculator (30, 9,000, 3.1), loan calculator (12, 800, 15.7) and tip calculator (8, 400, 22.0) — give 215 total clicks and 15,700 total impressions, an average CTR of 1.37% and an impressions-weighted average position of 6.4. Striking distance: salary calculator uk (12.4) and loan calculator (15.7). High impressions, low CTR: bmi calculator — 9,000 impressions but only 0.33% CTR, well below the 1.37% average.
How to Use This Tool
Export your data from Search Console, paste or upload it, and click Analyze CSV.
- Export from Search Console. Open Performance, pick a date range (28 days is a good start), choose the Queries or Pages tab, then Export → Download CSV.
- Paste or upload the CSV. Open the file, copy everything including the header row, and paste it into the box — or use the file upload instead. The analyzer detects Query and Page exports automatically.
- Click Analyze CSV. Totals, the top 10, striking-distance queries and high-impression, low-CTR queries appear below. Rows with missing values are skipped and counted.
- Act on striking distance first. Queries in positions 11–20 are the closest wins: improve the page's title, answer the query more directly, or add an internal link from a stronger page.
- Fix low-CTR titles next. A query with thousands of impressions and a CTR below your average is usually a title-and-description problem, not a ranking problem.
Re-export after a few weeks and compare — position changes take time to show up, so judge by the trend, not a single day. To project where the trend leads, an SEO traffic forecast calculator turns today's sessions into a month-by-month projection.
Tips and Practical Advice
- Use a 28-day range. Shorter ranges are noisy; a full month smooths out weekday and weekend swings in search behaviour.
- Compare like with like. A branded query (your own site name) will always have a much higher CTR than a generic one — judge low-CTR rows against other non-branded queries.
- Position is an average. A query at position 12.4 ranks on page 1 for some searches and page 2 for others — the average hides that spread, so treat striking distance as a shortlist, not a verdict.
- Your data stays yours. The analyzer never uploads the CSV. If you work with client data, that privacy is the point — paste freely.
Frequently Asked Questions
How do I export a Performance CSV from Google Search Console?
Open Google Search Console, go to Performance, choose the date range and the Queries or Pages tab, then click Export in the top right and choose Download CSV. The file has columns for Query (or Page), Clicks, Impressions, CTR and Position — paste its contents into the box above or upload the file.
Is my Search Console data uploaded anywhere?
No. The CSV is parsed entirely in your browser with JavaScript — nothing is sent to a server, stored, or shared. You can even disconnect from the internet after the page loads and the analyzer still works.
What are striking-distance keywords?
Queries ranking in positions 11–20 — the top of page 2 of Google. They already get impressions, so a small improvement (a better title, a clearer answer, an internal link) can move them onto page 1, where most clicks happen. This analyzer lists them sorted by impressions, so the biggest opportunities come first.
Why is my average position different from Search Console?
This analyzer calculates an impressions-weighted average position, which gives more weight to queries Google shows most often — the standard way to summarize position across many queries. Search Console shows a simple average in some views and rounds its numbers, so small differences are normal.
Can I analyze a Pages export too?
Yes. The analyzer detects which export you pasted from the header row: a Query column means a Queries export, a Page or URL column means a Pages export. Totals, top 10, striking distance and low-CTR tables work the same either way.
Last updated: