Analytics Edge Add-in for Excel

Works with Microsoft Excel 2016+ on Windows PCs

Automate your reports and end the drudgery! The Analytics Edge Add-in for Excel will download your data into your workbooks for you. With connectors for popular online services and wizard-based operation, creating new reports is quick and easy, and refreshes are even faster.

Tight Excel Integration

This small XLL add-in works inside Microsoft Excel and uses regular Excel workbooks (.xlsx). From a menu on the ribbon bar, you have access to all the features and functions. Everything is wizard-based — no formulas or coding necessary! Your downloads are fast and written right into your worksheets, even if you have lots of data — as much as Excel can handle!

Data Sources

Optional connectors are available for many popular ads services (Google Ads, Microsoft Ads, Facebook Ads, LinkedIn Ads), search and web analytics services (Google Analytics, Google Search, Bing Webmaster Tools), and email services (Constant Contact, MailChimp). Since you are querying the APIs direct from your computer, there are no account or query limits. Each connector offers all the dimensions and metrics available, and they are updated with new capabilities in a timely manner.

Quick Queries

Pick a spreadsheet cell, make a query using simple popup wizards, repeat as needed. Refresh all with a single click. Simple automation. No limits – use different accounts, different sources, all on the same worksheet or spread over several sheets. Copy and paste, quickly edit with the popup wizards, or get technical and work with the query definitions sheet — you do you. Get your work done fast, refresh whenever you want even faster.

Interactive Mode

Need to clean up some data or just download some data once? No problem – interactive mode lets you pick a location and pick a function. Analytics Edge will load the data and run the function, then save it back or write it to a new location.

Analytics Edge Macros

Want more insights and have a couple of minutes? Convert your Quick Query to a Macro and open the door to limitless analysis. No formulas or coding to learn; everything is wizard based! Replace text, remove duplicates, pivot, filter, sort, combine, lookup — 34 powerful wizard-based functions let you dig into your data in minutes. Easily work with data from multiple sources, making step-by-step changes and seeing the results as you work. Stay focused on your data, not writing code. Refresh in seconds.