Open navigation

How to connect data sources to Excel with Supermetrics

Once you’ve added Supermetrics to Excel, the first step in moving your data in Excel with Supermetrics is to connect to the data sources you want to use in your reporting. Once you’ve done this, you can use the sidebar to create queries for any connected data source.

Some data sources have different requirements. Explore our connection guides for specific guidance on how to connect to each data source.

In this guide, we’ll show you the process for one of our most popular data sources: Google Ads. 


  1. Open an Excel file and navigate to the Data tab in the top Ribbon.
  2. On the right-hand side of the Ribbon, click Show Supermetrics.
  3. In the Data source section, click the data source you’d like to connect to Supermetrics.
  4. Follow the prompts to log in to the data source, approving permissions when asked. Learn more about our data protection and privacy policies.
  5. Once you’ve logged in, return to Excel.
  6. The account you’ve added will be available under My data sources in the Supermetrics sidebar.

Next steps 

Learn how to set up and run your first queries in Excel.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.