Guides · Updated November 17, 2026

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

  1. In the Performance report, add a filter, for example one country, one device or a page that contains /blog/.
  2. Export, change the filter, export again.
  3. 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)

  1. Install aska GSC and press Sign in with Google. Allow read-only access to Search Console.
  2. Pick your site and a period, tick query and page (and country or device if you need them) and Split by day.
  3. Press Export. aska GSC runs the day-by-day API queries, pages through every result and saves one CSV or Excel file.
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

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

More guides