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 GoogleSQL queries

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

#standardSQL

For example, the following query is executed using GoogleSQL:

#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.