Member Avatar for MktgRob

I received an e-mail with the URL below for a free plug-in for Google analytics that lets you import web analytics data from Google into an excel spreadsheet. It is open-source and free for everyone. I am going to start playing with it this week and I encourage others to do so also and report back your opinion. If it is good then we can all benefit from another free tool.

http://excellentanalytics.com/

  • 3 Contributors
  • 4 Replies
  • 122 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by MktgRob

Dani AI

Generated

Good find by . With noting the value of importing and manipulating GA exports, and asking about WebTrends, a few practical, up-to-date points are useful when revisiting an old Excel add‑in years after its release.

Before installing or relying on any legacy add‑in, verify maintenance and compatibility: check the project repository or issue tracker for recent updates; confirm which Analytics API it targets (Universal Analytics vs GA4) and which authentication flow it uses (modern OAuth2 vs older methods); make sure the add‑in supports the installed Office bitness (32-bit vs 64-bit) and required runtimes. Test first on a non‑production property or with a small date range.

Simple workflow tips that help immediately:

  • Load query results into a dedicated worksheet and convert the range to an Excel Table (Ctrl+T) so refresh, formulas and PivotTables behave predictably.
  • Use PivotTables or Power Query (Get & Transform) to reshape and summarise data instead of manual edits.
  • If totals don’t match the GA web UI, check for sampling, different date ranges/timezones, or processing lag; reduce the date window to confirm sampling.

Quick troubleshooting checklist:

  • Authentication errors → ensure the add‑in supports OAuth2 and that credentials/permissions are correct.
  • Silent failures → check Excel Trust Center (add‑ins/macros), missing dependencies (.NET/VSTO), and 32/64‑bit mismatch.
  • Large or sampled exports → use smaller ranges or a paid connector that offers unsampled extracts.

If the add‑in is unmaintained, pragmatical alternatives include Google Sheets add‑ons, commercial connectors (for example, Supermetrics or Analytics Edge), Looker Studio for dashboards, or exporting via API scripts and then loading CSVs into Excel. For WebTrends, vendor exports or third‑party connectors are usually the most reliable path.

Recommended Answers

All 4 Replies

Member Avatar for mackone

I would love to try, seems to be great tool which let's you import the data and manipulate it at will.

Member Avatar for MktgRob

I have already begun testing it and it works really well.

Member Avatar for InsightsDigital

I wish there was a similar tool for WebTrends. I heard only really good things about this plug in. Thanks for sharing.

Member Avatar for MktgRob

I wish there was a similar tool for WebTrends. I heard only really good things about this plug in. Thanks for sharing.

I am hoping for an onslaught of plugins and apps for analytics from the various SE's, much in the same way that WordPress apps and plugins are so plentiful that it is like they are growing on trees!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.