This content originally appeared on DEV Community and was authored by Daniel ZS
If you’re looking to pull data from Google BigQuery directly into Microsoft Excel, the process can be a bit intimidating — especially if you’re not a developer.
But don’t worry — using the ZappySys ODBC API Driver, you can connect Excel to your Google Query API with zero coding. In this post, we’ll walk you through the basic setup — and provide a link to the full detailed tutorial with screenshots and video.
Try it live: Connect Google Query to Excel using ZappySys ODBC (full tutorial)
What You’ll Need
Before getting started, make sure you have:
- ZappySys ODBC PowerPack installed — Download it here
- A Google account with access to BigQuery
- A Google Cloud Project with APIs enabled
That’s it! Let’s get into it.
Quick Overview of the Setup Process
Here’s a high-level look at what you’ll do:
Step 1: Set Up Google API Access
You’ll go into the Google Cloud Console, enable the necessary APIs (like BigQuery API), configure OAuth credentials, and get your Client ID and Secret.
Need help with that? View full instructions here
Step 2: Create a ZappySys ODBC DSN
Using the ZappySys API Driver, you’ll create a new DSN and select the Google BigQuery Connector from the list. From there, you’ll enter your credentials and test the connection.
Step 3: Load Data into Excel
In Excel, go to Data > Get Data > From Other Sources > From ODBC, select your new DSN, and log in using Windows Authentication. Then select the BigQuery table you want to query.
Want a visual walkthrough?
Watch this short video:
Bonus Tips
- Save your OAuth credentials so you don’t have to re-authenticate every time.
- Use preview mode in the ZappySys driver to explore datasets before pulling them into Excel.
Get Full Details with Step-by-Step Screenshots
To see the complete tutorial with all screenshots, field names, and advanced configuration tips, check out the full article on our website:
Full Step-by-Step Guide: Connect Google BigQuery to Excel via ODBC
Need Help?
If you run into issues or have questions, our friendly support team is available via chat on zappysys.com.
This content originally appeared on DEV Community and was authored by Daniel ZS