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:

Watch the tutorial

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