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.
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:
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.
Alternatively, you can use the Simba ODBC Drivers for Google BigQuery to connect Excel with BigQuery.