Offgrid Studio logo Offgrid Studio

Tools / Search Console CSV Analyzer

Find the keywords Search Console is quietly handing you.

Drop in a Performance export and see which queries and pages are one push away from page one, which have a title problem, and which get impressions but zero clicks.

Your file never leaves this tab. The CSV is read and analysed by JavaScript in your browser. There is no upload, no account and no server involved — you can switch off your Wi-Fi after the page loads and it still works.

How each report works

  • Quick wins — average position 4–15 with real impressions. These already rank; better titles, internal links or a tighter section often move them up. Sorted by impressions.
  • Low CTR — position 1–10 but the click rate is under half of a rough benchmark for that position. Usually a title or meta description problem, not a ranking problem.
  • Zero clicks — shown often, never clicked. Either the snippet isn't earning the click or the query's intent doesn't match the page.
  • Top by clicks — what is working now, so you know what not to break.

The CTR benchmark is a rough industry average (about 28% at position 1, 15% at 2, 11% at 3, falling to roughly 2.5% at 10) — treat it as a pointer, not a rule. Branded queries and rich results skew it. Position is impression-weighted, as Search Console reports it.

Works with English and Traditional/Simplified Chinese column headers. Comma, semicolon and tab-separated files are detected automatically. Built by Offgrid Studio, the same people who make the privacy-first iPhone apps on our home page.