Mark Red and Dropit have put together a useful plugin that helps query Google Analytics using Microsoft Excel. Considering that these are among the more commonly used tools/apps, this is a welcome plugin. What’s more, it’s even Open-Source.
Excellent Analytics is a simple Excel plug in that lets you import web analytics data from Google Analytics in to an Excel spreadsheet.
- Build queries with all dimensions and metrics available in Google Analytics
- Apply filters to create advanced queries
- All queries are stored in the spreadsheet
Imported data is stored in the spreadsheet so you can sort, manipulate and distribute the data to anyone using Microsoft Excel.
Use Microsoft Excel to combine web analytics data from Google Analytics with offline data from any other source. Excellent Analytics makes this easy!
I’m yet to use it, because I don’t have any Google Analytics work going on at the moment, but will give it a spin when I can.
Update: From some discussions on mailing lists and forums, I think one has to fiddle with the date-format settings in Excel to make it work. Just in case any of you were having trouble.