How to export Google Search Console data past the 1,000-row limit
The Performance report in Google Search Console has an Export button, but the file it gives you is cut off: Google's help page says the data is “truncated to 1,000 rows of representative examples”, and that larger sites typically have much more. If your site gets traffic from more than a thousand queries or pages, the export is missing most of them. Here are the ways around it.
Option 1: filter and export in pieces
- In the Performance report, add a filter, for example one country, one device or a page that contains
/blog/. - Export, change the filter, export again.
- Paste the files together in a spreadsheet.
It works for a few slices, but each export is still capped at 1,000 rows, and the pieces overlap or leave gaps unless you plan the filters carefully.
Option 2: the Search Console API
The Search Console API returns up to 25,000 rows per request and lets you page through results with startRow. Google recommends querying one day at a time and notes that the API exposes at most 50,000 rows per day per search type. To use it you need code, a Google Cloud project and OAuth credentials, or a tool that does that for you.
POST https://searchconsole.googleapis.com/webmasters/v3/sites/sc-domain%3Aexample.com/searchAnalytics/query
{"startDate": "2026-11-01", "endDate": "2026-11-01",
"dimensions": ["date", "query", "page"], "type": "web",
"rowLimit": 25000, "startRow": 0}
Option 3: aska GSC (no code)
- Install aska GSC and press Sign in with Google. Allow read-only access to Search Console.
- Pick your site and a period, tick query and page (and country or device if you need them) and Split by day.
- Press Export. aska GSC runs the day-by-day API queries, pages through every result and saves one CSV or Excel file.
Option 4: Bulk data export to BigQuery
Search Console can send data to BigQuery every day. It is the most complete source for very large sites, but it needs a Google Cloud billing account, SQL to read the data, and it only collects data from the day you turn it on.
What no export can give you
- Anonymized queries: rare queries are hidden everywhere, including the API.
- More than about 50,000 rows per day per search type through the API.
- Data older than 16 months, unless you saved it before Google deleted it.