How to export more than 1,000 rows from Search Console
By Jake Marsh · Updated
To export more than 1,000 rows from Search Console, use the Search Console API instead of the Export button, which stops at 1,000. In Google Sheets, install Queryledger, open Extensions > Queryledger > Open Queryledger, tick the property on the Report tab, choose Query and Page under Dimensions, leave Row limit at 0, and click Pull into a new tab. Queryledger keeps paging until the API has no more rows.
Where the 1,000-row limit comes from
Google's own guide to Search Console performance data says the user interface exports at most 1,000 rows. The Search Analytics API returns up to 25,000 rows per request and, with paging, up to 50,000 rows per day per site per search type. Queryledger reads through the API and requests the next page until Google stops sending rows.
Steps
- Open Extensions > Queryledger > Open Queryledger.
- Tick one or more properties under Properties. Several properties come back in one table with a Property column.
- Pick the dates. Last 28 days and Last 3 months match the Search Console defaults; Everything Google still has (16 months) pulls the full window.
- Choose Dimensions. Query and Page together give one row per query per page. Add Date for a row per day.
- Add filters if you only want part of the site: Page contains
/blog/, or Query matches regex^how. - Leave Row limit at 0 and set a Tab name, or leave it automatic.
- Click Pull into a new tab.
Getting the most rows
| To get | Do this |
|---|---|
| More queries per page | Pull a shorter date range, or one search type at a time |
| Every page, even with few clicks | Use Page as the only dimension; fewer dimension combinations means fewer rows dropped |
| One section in depth | Filter by Page contains the folder |
| Several sites in one table | Tick each property; each counts as one trial use |
Two things the API never returns, in any tool: anonymized queries (searches Google keeps private) and rows beyond 50,000 per day per search type. For a site that needs more than that, Google's Bulk data export to BigQuery is the tool.
What it costs
Queryledger's free trial covers 30 uses or 14 days, whichever comes first, with no card needed. A use is one property in a pull, one comparison, or one backup's daily run that adds data, and the whole 16-month backfill counts as one. After that it's $49 a month or $492 a year per Google account, or $149 a month for a team plan that covers everyone at your company's domain. Install it from the Queryledger page.
Queryledger: Search Console Backups & Reports
Search Console data in Google Sheets, with daily backups that keep your history past 16 months $49 a month or $492 a year per Google account.
Questions
Is the data the same as in the Search Console report?
It comes from the same source through Google's API, with dates in Pacific Time like Search Console. Totals for a query-level table can be lower than the report's chart because anonymized queries are left out of query rows.
Can I export Search Console data for several websites at once?
Yes. Tick several properties and the rows land in one table with a Property column.
Can I include the last few days?
Tick Include fresh data (last 2-3 days, may still change). Without it, pulls use final data only.
How long does a big pull take?
It depends on how many rows Google returns. Queryledger requests the pages for several properties in parallel and retries when Google asks it to slow down.
More Queryledger guides
- How to keep Search Console data longer than 16 months
- How to compare Search Console data year over year in Google Sheets
More Google guides
- How to create barcodes in Google Sheets (Rowcode)
- How to create a PDF for each row in Google Sheets (PickMerge)
- How to share only part of a Google Sheet (Rowsplit)
- How to print 5160 address labels from Google Sheets (Labelyard)