BigQuery Connector for Excel

Google BigQuery offers a connector for Excel 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 (through a Web Query File), 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 standard SQL queries

By default, the BigQuery runs queries using legacy SQL. To run queries using standard SQL, prefix your query with the following line:

#standardSQL

For example, the following query is executed using standard SQL:

#standardSQL
SELECT
  weight_pounds, state, year, gestation_weeks
FROM
  `bigquery-public-data.samples.natality`
ORDER BY weight_pounds DESC
LIMIT 10;

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.

What's next

Alternatively, you can use the Simba ODBC Drivers for Google BigQuery to connect Excel with BigQuery.

Send feedback about...

BigQuery Documentation