Analytics Edge Add-in for Excel

Works with Microsoft Excel 2016+ on Windows PCs

Automate the Download and Analysis! Connectors for popular services like Google Analytics, Search Console, and Ads.


Tight Excel Integration

  • It works inside Microsoft Excel with regular Excel workbooks (.xlsx). No special macro workbooks or restrictions.
  • Everything is wizard-based; no formulas or coding necessary.
  • Your downloads are fast and written right into your worksheets.

Data Sources

Optional connectors are integrated for many popular ads services:

  • Google Analytics
  • Google Search
  • Bing Webmaster Tools
  • Google Ads
  • Microsoft Ads
  • Facebook Ads
  • LinkedIn Ads
  • Constant Contact

Quick Queries

Pick a spreadsheet cell, make a query using simple popup wizards, repeat as needed. Functions available to all queries:

  • Pivot
  • Arrange
  • Filter
  • Sort / Count
  • Write (to worksheet/append to worksheet/write to text file)

Analytics Edge Macros

Open the door to limitless analysis with over 30 wizard-based functions available without ever touching a formula, pivot table or Power Query:

WORKBOOK

  • Read worksheet
  • Read text/web file
  • Read Google Sheet
  • Web request
  • Write to worksheet
  • Write to text file
  • Write to Google Sheet
  • Append to worksheet
  • Save/email PDF
  • Save/email workbook
  • Send email
  • Repeat macro
  • Run…if…

MULTIPLE

  • Append
  • Combine
  • Compare
  • Lookup
  • Match
  • Update

TABLE

  • AI Request
  • Arrange
  • Duplicates
  • Filter
  • Group
  • Pivot
  • Sort
  • Table name
  • Top/Bottom
  • Total
  • Transponse
  • Unpivot

COLUMN

  • Calculate
  • Convert
  • Formula
  • Join
  • Rank
  • Replace
  • Split
  • Subtotal