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.