How does the tool avoid API timeouts on long date ranges?

Any date range longer than 30 days is split into 7-day chunks and fetched batch by batch, with a progress bar and running row count. The batches are concatenated at the end, so the final CSV still covers the full range in one file.

Is there a row limit?

The tool itself sets no cap; it keeps fetching until the API returns no more rows. It warns if the running total passes roughly 1 million rows mid-fetch and again above 500,000 rows before CSV generation, because very large exports can hit browser memory limits. For big sites, split exports into monthly or quarterly ranges.

How do I get the query position analysis chart?

Select both the query and date dimensions before fetching. The tool then counts unique queries per month in position bands 1-3, 4-10, 11-20 and 20+, shows a stacked bar chart, and offers a separate query analysis CSV. If either dimension is missing, the analysis is skipped.

What permission does the Google sign-in ask for?

The OAuth flow requests the https://www.googleapis.com/auth/webmasters scope, which is the full Search Console scope rather than Google's separate read-only variant. The tool only ever reads data, and tokens are held in the Streamlit session rather than being stored anywhere.

Why does the date range stop at 16 months?

Google Search Console only retains 16 months of performance data, so the longest preset is Last 16 Months (480 days). Requesting older dates via the custom range returns nothing.

Back to Tools

GSC Data Exporter

Use cases

Exporting full keyword data for analysis in Excel or Python Building historical keyword tracking across long date ranges Analysing query position distribution over time Feeding complete GSC data into other SEO tools

Export complete Google Search Console data without the 1,000 row limit.

Automatically batches requests in 7-day chunks to prevent API timeouts on large date ranges.

Includes query analysis showing monthly distribution across position ranges (1-3, 4-10, 11-20, 20+).

Memory-optimized for datasets exceeding 100,000 rows with automatic category type conversion.

Streamlit App GSC Data

Platform

Browser-based (no installation required)

Input

Google Search Console access

Output

GSC data CSV with performance metrics

Launch App View Source

Features

Unlimited data extraction (bypasses 1,000-row limit)
Auto-batching in 7-day chunks for large date ranges
Search types: web, image, video, news, discover, googleNews
Query position analysis with stacked bar visualisation
Memory optimisation for datasets over 100,000 rows
Large dataset warnings for 500k+ rows

How to use

1 Sign in with Google via OAuth (full webmasters scope)
2 Select property and search type
3 Choose date range (7 days to 16 months, or custom)
4 Select dimensions: page, query, country, date, device
5 Include query and date dimensions for the position analysis chart
6 Download CSV with real-time batch progress

Frequently asked questions

How does the tool avoid API timeouts on long date ranges?: Any date range longer than 30 days is split into 7-day chunks and fetched batch by batch, with a progress bar and running row count. The batches are concatenated at the end, so the final CSV still covers the full range in one file.
Is there a row limit?: The tool itself sets no cap; it keeps fetching until the API returns no more rows. It warns if the running total passes roughly 1 million rows mid-fetch and again above 500,000 rows before CSV generation, because very large exports can hit browser memory limits. For big sites, split exports into monthly or quarterly ranges.
How do I get the query position analysis chart?: Select both the query and date dimensions before fetching. The tool then counts unique queries per month in position bands 1-3, 4-10, 11-20 and 20+, shows a stacked bar chart, and offers a separate query analysis CSV. If either dimension is missing, the analysis is skipped.
What permission does the Google sign-in ask for?: The OAuth flow requests the https://www.googleapis.com/auth/webmasters scope, which is the full Search Console scope rather than Google's separate read-only variant. The tool only ever reads data, and tokens are held in the Streamlit session rather than being stored anywhere.
Why does the date range stop at 16 months?: Google Search Console only retains 16 months of performance data, so the longest preset is Last 16 Months (480 days). Requesting older dates via the custom range returns nothing.

Want me to run this for you?

I run this tool as a managed service, or build something custom around your data. You get the insights without touching the code.

Book a Call

GSC Question FinderAppSearch Console

Extract question-based keywords from Search Console using regex pattern matching.

Striking Distance FinderAppSearch Console

Find quick-win keywords ranking positions 5-19 that are missing from your on-page content.

Top Traffic Pages FinderScriptSearch Console

Identify your highest-traffic pages from Search Console data with performance metrics.

GSC Chart VisualiserScriptSearch Console

Visualise Google Search Console data with interactive Altair charts.

GSC Folder AnalyserAppSearch Console

Analyse Search Console data by URL folder structure.

Hreflang Tag GeneratorBrowserTechnical SEO

Generate correct hreflang tags for international SEO.

Need something built for your business?

This tool started as bespoke client work. I build custom scripts, data pipelines, and full apps for SEO and product data problems that off-the-shelf tools don't solve.