How to Connect BigQuery to Excel – Stream Live Data Warehouse Analytics

CONNECTOR GUIDE

BigQuery ➤ Microsoft Excel

BigQuery

Query Streams

Microsoft Excel

Cloud Native

Live Data

Secure

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 enables you to connect BigQuery Data Warehouse directly to Microsoft Excel, streaming live cloud data without ODBC drivers, VBA scripts, or complex configuration. Sign up for free at QueryStreams.com and start pulling live warehouse data into your spreadsheets in minutes.

This guide shows you how to establish a secure, real-time connection between your BigQuery data warehouse and Microsoft Excel. Whether you’re analyzing marketing data, building executive dashboards, or sharing analytics with stakeholders worldwide, Query Streams provides a simple solution for accessing your Service Account Auth.

What You’ll Accomplish

By the end of this guide, you’ll be able to:

• Connect Excel to BigQuery – Service Account Auth access
• Execute BigQuery SQL in real-time from Excel
• Build live warehouse dashboards with auto-refreshing data
• Share secure warehouse access with stakeholders globally

Prerequisites

Step 1: Access the Query Streams Agent Interface

With your agent installed, configure your BigQuery connection.

1. Open your web browser and navigate to: https://localhost:1823
2. Navigate to Data Connections: Click Data Sources > Connections
3. Add a new connection: Click Add Connection

Step 2: Select BigQuery as Your Connection Type

1. Choose BigQuery: Click on the BigQuery tile (green border when selected)
2. Alternative – Use search: Type “BigQuery” to quickly find it
3. Click Next to proceed

Step 3: Configure Your BigQuery Connection Details

Required BigQuery Connection Details:

1. Connection Name – A friendly label (e.g., “BigQuery Analytics”)
2. Project ID – Your Google Cloud project ID (e.g., my-analytics-project-123456). Find it in the Google Cloud Console dashboard.
3. Credentials JSON – Paste the full contents of your service account JSON key file. Generate one from IAM & Admin > Service Accounts > Keys > Add Key > JSON.
4. Dataset (optional) – Default BigQuery dataset to query against (e.g., my_dataset). You can also specify the dataset in your SQL.
5. Location (optional) – BigQuery data location (e.g., US, EU, us-central1). Defaults to US if not specified.

Once completed, click Next.

Step 4: Select Your Data Realm

Select your Data Realm – your query processing capacity.

1. Review available realms: Based on your subscription
2. Select realm: Choose “Default Data Realm”
3. Click Next to test the connection

Step 5: Test Your BigQuery Connection

Query Streams will verify your BigQuery credentials.

1. Automatic testing: Agent attempts to connect to BigQuery
2. Review results: Success shows BigQuery version, warehouse, and permissions
3. Click Next if successful

Step 6: Finish Setup

1. Review configuration: Verify all settings are correct
2. Click Finish to save your BigQuery connection

Your BigQuery connection is ready! Next, install the Excel add-in.

Step 7: Install Add-In and Run Your First Query

Install the Query Streams add-in from Microsoft AppSource:

After installation, open the add-in from the Home ribbon tab and create your first BigQuery query:

1. Click “Stream a Query”
2. Select your BigQuery connection
3. Choose database and schema
4. Write your BigQuery SQL:

SELECT 
    customer_id,
    customer_name,
    email,
    total_purchases,
    country
FROM customers
WHERE total_purchases > 1000
ORDER BY total_purchases DESC
LIMIT 100;

5. Configure destination: Choose “Create a new tab”
6. Click Play to execute

Next Steps: Save and Share Queries

Use the Query Streams web portal to build, save, and manage your BigQuery queries:

• Save queries: Store warehouse queries for reuse
• Add parameters: Create dynamic filters for data exploration
• Share globally: Let stakeholders run queries from anywhere
• Access from add-in: Saved queries appear in “Saved Queries” menu

Frequently Asked Questions

Related Guides