Stay organized with collections Save and categorize content based on your preferences.

BigQuery connector for Microsoft Excel

BigQuery offers a connector that allows you to make queries to BigQuery from within Excel. This can be useful if you consistently use Excel to manage your data. The BigQuery connector works by connecting to BigQuery, making a specified query, and downloading and propagating that data to Excel.

System Requirements

The BigQuery connector for Excel is designed to work with Microsoft Excel 2007 and higher. It may work for other versions of Excel, but this was not tested. The connector will work for both Windows and Macintosh versions of Microsoft Excel.

Accessing the Connector

For instructions on how to download and use the connector, see the BigQuery connector for Excel page.

Running Google Standard SQL queries

By default, the BigQuery connector for Excel runs queries using legacy SQL. To run queries using Google Standard SQL, prefix your query with the following line:


For example, the following query is executed using Google Standard SQL:

  weight_pounds, state, year, gestation_weeks
  weight_pounds DESC

Note that you might need to use a special keyboard combination to enter a newline character within a cell. For more information about the SQL syntax prefix, see Setting a query prefix.