How to export all Search Console queries to Excel
Queries are the most useful part of Search Console and the part the Export button cuts hardest. This guide shows how to get every query the API returns into one Excel workbook, with the totals per query already summed.
1. Choose the period
Use full weeks or months for reports. The most recent 2–3 days are not final yet.
2. Choose the detail
- Query only: one row per query with totals for the period. The smallest file.
- Query + page: which URL ranks for which query. Good for content audits.
- Split by day: daily rows, to chart trends or rebuild any period later.
3. Export with aska GSC
- Sign in with Google in aska GSC and pick the site.
- Tick Query (and Page if you want it), choose the period and tick Excel.
- Press Export.
The workbook has a Data sheet with every row, plus summary sheets: Queries (clicks and impressions summed, CTR recomputed, position averaged by impressions), Pages, Dates, and Query x Page when both are selected. An About sheet records the site, period and data notes.
aska GSC is a browser extension for exactly this: sign in with Google (read-only), pick a site, press Export, get every row as CSV or Excel. Get aska GSC · Pricing
Reading the numbers
- Summed query clicks are usually a bit lower than the chart total, because anonymized queries are hidden.
- Position is an average; a query at 8.5 may sit on page one on mobile and page two on desktop. Add the device dimension to see it.