How to Connect Google Search Console to Excel – Query SEO Data with SQL

See everything Query Streams can do beyond this guide Get Started Free

Supports

+more

Live Data

Replace exports with on-demand SQL

Excel Sheets

BI & AI Analytics

Ask Nova, get SQL + charts

Meet Nova

Database REST API

One key per partner. No credentials shared.

Build an API

+more

Automation

Scheduled sync to 6+ platforms

Explore

+more

API to SQL

Query APIs with SQL, no code

Explore

+more

AI Database MCP

Claude, Cursor, ChatGPT & Grok talk to your data

Connect AI

Query Streams connects Google Search Console to Microsoft Excel, turning your organic search data into live, SQL-queryable tables. Pull keyword rankings, click-through rates, impressions, and page-level search performance into Excel spreadsheets without manual CSV exports. Sign up free at QueryStreams.com and start analyzing your GSC data with SQL in minutes.

What Google Search Console Data Can You Access?

Query Streams syncs your GSC search performance data into SQL-queryable tables. GSC data is typically 2–3 days delayed from Google’s processing pipeline.

Prerequisites

Setup Guide

Step 1: Install the Query Streams Network Agent

1. Log in to my.querystreams.com
2. Navigate to Network Agents in the left sidebar
3. Click Download Agent and run the Windows installer
4. The agent installs as a Windows service and connects automatically
5. Your agent appears as “Online” in the portal within 30 seconds

Step 2: Create a Google Cloud Service Account

1. Go to the Google Cloud Console and create or select a project
2. Navigate to APIs & Services → Library → search for and enable Google Search Console API
3. Go to IAM & Admin → Service Accounts → Create Service Account
4. Name it (e.g., “query-streams-gsc”) and click Create and Continue
5. Skip the optional role assignment → click Done
6. Click on the service account → Keys tab → Add Key → Create new key → JSON
7. The JSON key file downloads automatically — save it securely

Grant Access in Google Search Console

1. Go to Google Search Console and select your property
2. Click Settings → Users and permissions
3. Click Add User
4. Paste the client_email from your JSON key file
5. Set the permission to Full → click Add

Step 3: Add the Google Search Console Connector

1. Open the Network Agent interface at http://localhost:1823
2. Click Add Connection and select Google Search Console
3. Paste the contents of your Service Account JSON key (or upload the file)
4. Select your GSC Property from the dropdown (domain or URL-prefix property)
5. Click Next to configure sync schedules and install pre-built queries

Step 4: Configure Your Sync Schedule

Step 5: Install the Excel Add-in

1. Open Microsoft Excel
2. Go to Insert → Get Add-ins
3. Search for “Query Streams” in the Office Add-ins store
4. Click Add to install
5. Access it via the Home tab → Query Streams button in the ribbon
6. Sign in with your Query Streams account credentials
7. Or install directly: Install Query Streams for Excel

Example Google Search Console SQL Queries

SELECT
    query,
    SUM(clicks) AS total_clicks,
    SUM(impressions) AS total_impressions,
    ROUND(AVG(ctr) * 100, 2) AS avg_ctr_pct,
    ROUND(AVG(position), 1) AS avg_position
FROM gsc.search_analytics
WHERE date >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY query
ORDER BY total_clicks DESC
LIMIT 25;

SELECT
    page,
    SUM(clicks) AS clicks,
    SUM(impressions) AS impressions,
    ROUND(AVG(ctr) * 100, 2) AS ctr_pct,
    ROUND(AVG(position), 1) AS avg_position
FROM gsc.top_pages
WHERE date >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY page
HAVING ROUND(AVG(position), 1) BETWEEN 11 AND 20
ORDER BY impressions DESC
LIMIT 20;

SELECT
    query,
    SUM(impressions) AS impressions,
    SUM(clicks) AS clicks,
    ROUND(AVG(ctr) * 100, 2) AS ctr_pct,
    ROUND(AVG(position), 1) AS avg_position
FROM gsc.search_analytics
WHERE date >= CURRENT_DATE - INTERVAL '90 days'
GROUP BY query
HAVING SUM(impressions) > 500
   AND AVG(ctr) < 0.03
ORDER BY impressions DESC
LIMIT 20;

Share SEO Reports Without Sharing GSC Access

Frequently Asked Questions

Related Guides

Category: API Connectors

Tags: Google Search Console, GSC, Excel, SEO, Keywords, Rankings, SQL, Organic Search

Meta Description: Connect Google Search Console to Excel with SQL. Query keyword rankings, CTR, and impressions — 16 months of data, no CSV exports. Step-by-step guide.