Google Search Console CSV to Dashboard
Search Console's own UI sorts one column at a time and caps what you see on screen. Once you've exported the CSV, sorting queries by impressions instead of clicks, or spotting pages with high impressions but a poor CTR, is a two-second pivot instead of scrolling through the UI.
Step 1: Export From Search Console
Open the Performance report, set your date range, and click Export → Download CSV. Every tab (Queries, Pages, Countries, Devices, Dates) shares the same shape: a label column (Top queries or Top pages) plus Clicks, Impressions, CTR, and Position.
Step 2: Pick a View
Queries by Impressions
Upload Queries.csv and Pivot Table opens sorted by impressions, useful for finding high-visibility queries with a weak position.
Pages by Clicks
Upload Pages.csv for the same breakdown at the page level.
Find CTR Outliers
Flag queries or pages whose CTR is unusually low relative to their position, classic "rewrite this title" candidates.
Compare Two Periods →
Diff this month's export against last month's to see which queries gained or lost impressions.
Frequently Asked Questions
Where does this CSV come from?
In Search Console, open the Performance report, pick a date range, and click Export → Download CSV. It downloads a zip with separate files per tab (Queries.csv, Pages.csv, Countries.csv, Devices.csv, Dates.csv), each sharing the same Clicks/Impressions/CTR/Position columns.
Why does the export stop at 1,000 rows?
That's a Search Console export limit, not a limit of this tool. For a full query list beyond 1,000 rows you'd need the Search Console API; everything below works on whatever the CSV export gives you.
Comparing multiple exports over time?
Dataset Diff highlights exactly what changed between two CSV snapshots.
Open Dataset DiffTurn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.