With the release of an API for Google Analytics http://analytics.blogspot.com/2009/08/analytics-data-in-excel-through-our-api.html) we are now starting to see the appearance of tools to make use of the API. A couple of the tools embed plug-ins into Excel giving the ability to run your GA queries directly from Excel and cutting out the whole .CSV export and import process
A couple of Excel plug-ins are available. Excellent Analytics http://excellentanalytics.com/ works with Excel 2007 and Tatvic http://gaexcelplugin.tatvic.com/ works with both Excel 2007 and Excel 2003.
I’ve been playing around with Tatvic’s version in recent days. Once you have registered, downloaded and installed the plug-in you just have to enable it from the Tools | Add-Ins menu option – it shows up as Gaclient. The toolbar then shows up as Tatvic Google Analytics Excel Plugin in the View | Toolbars menu.
As a first step click on Login and enter your Google Analytics username and password to connect to your GA account.
Once you are logged in then you can start to pull your data from GA into your spreadsheet. Click Add a new data block to start the query-building dialogue. The first screen lets you choose from your GA profiles which website you want to analyse, select the time period for the query and decide whether you want the data selected by dates.