Edit on GitHub
Report issue
Page history

Author(s): @{[ username ]}  Published: {[ TutorialCtrl.tutorial.date_published | date:'mediumDate' ]}

title: Connecting to BigQuery from Microsoft Excel using ODBC description: Learn how to use the ODBC drivers for Google BigQuery to load query results into Microsoft Excel for analysis and visualization. author: tswast tags: BigQuery, Excel, ODBC date_published: 2017-01-26

Google BigQuery enables standard SQL queries to petabytes of data. But what if software you depend on doesn't support the BigQuery API? The BigQuery ODBC drivers enable you to connect tools that support the Open Database Connectivity (ODBC) API to BigQuery, such as Microsoft Excel.


  • Installing the ODBC driver for Google BigQuery.
  • Configuring the ODBC driver
  • Loading query results into Microsoft Excel®

Before you begin

This tutorial assumes you are using the Microsoft Windows operating system.

  1. Create a project in the Google Cloud Platform Console.

  2. See the blog post on getting started with the BigQuery free tier or video for more detailed instructions.

  3. Install Microsoft Excel 2016 for Windows.


This tutorial uses billable components of Cloud Platform including Google BigQuery. Use the Pricing Calculator to estimate the costs for your usage.

The first 1 TB per month of BigQuery queries are free. See the BigQuery pricing documentation for more details about on-demand and flat-rate pricing. BigQuery also offers controls to limit your costs.

Downloading the driver

  1. Check whether your version of Excel is 32-bit or 64-bit.
  2. Download the latest version of the ODBC driver from the Simba Drivers for Google BigQuery page which matches your version of Excel.
  3. Run the ODBC driver installer.

Configuring the driver

  1. Run the ODBC Data Sources Administrator program as the Windows administrator.
  2. Select the System DSN tab.
  3. Configure the BigQuery driver.
  4. Provide credentials with user authentication. Follow the prompts to log in and authorize the driver to access the BigQuery API.
  5. Set the Project (Catalog) to your Google Cloud project ID.

Note that the installer writes a user guide to the installation directory (in my case: C:/Program Files/Simba ODBC Driver for Google BigQuery) which contains more detailed instructions about how to configure the driver.

Running a query

Once the ODBC driver is configured, open Excel.

Opening the query dialog

  1. Go to the Data tab.
  2. Select New Query -> From Other Sources -> From ODBC. Query from ODBC in Excel screenshot
  3. Choose Google BigQuery as the data source.
  4. Don't supply a username or password. Instead, select the connection type tab for Default or Custom.

Entering a query

  1. Select Advanced Options.
  2. Enter your query in the SQL statement text box.

    Enter SQL statement screenshot

    As an example, query the USA names public dataset for the most popular names during the baby boomer generation.

      name, SUM(number) as total_number
      year >= 1946
      AND year <= 1964
  3. Click OK. When the query completes, you will have a new sheet with about 7,400 rows.

Next Steps

With the driver you installed, you can connect any application which supports the ODBC API to Google BigQuery.

See more by @{[ username ]} and more tagged {[ tag ]}{[ $last ? '' : ', ' ]}

Submit a Tutorial

Share step-by-step guides


Request a Tutorial

Ask for community help


GCP Tutorials

Tutorials published by GCP


Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see our Site Policies. Java is a registered trademark of Oracle and/or its affiliates.