How to Access Google Analytics in Excel

•  At first,install a free Excel plug-in called Excellent Analytics. You will also need Microsoft Office 2007 or higher and .Net Framework 4.Once you have installed Excellent Analytics, open Microsoft Excel and locate the Excellent Analytics tab on the ribbon. Click on “Account” and enter the Google ID and password you use to login to your Analytics account.

• A Query window will pop open where you will be able to select the data you wish to pull into Excel. We will use Excellent Analytics to retrieve a list of pages.The first thing you need to do is select your website (profile) from the drop-down list on top, in case you have multiple sites tracked by Google Analytics. Also choose the start and end dates from the calendar, or click on Time Span and choose a time period.

• Click on the Dimensions tab, expand the item “Content” and select the box next to “landing page path”

• Move over to the Metrics tab, expand the item “Visitors” and select the box next to “pageviews”

• Choose Maximum results to retrieve. Remember that if you choose a huge number like the default value of 10,000 it can take a long time to download. Choose a more practical figure like 100 or 1000 or 500.
  
• Click on the Sort by drop-down menu and choose pageviews. Then click the button next to Sort order so that it shows Descending as shown in the screengrab above.Now all you to do is click on Execute, wait a few moments and your report is ready.
  
• If you want to retrieve a different set of data, say, a list of keywords that visitors used to arrive at your site from search engines, then go to the Dimensions tab, expand the item “Campaign” and select the box next to “keyword”. All options you find on your Google Analytics account from the browser are available from this tool.

Rerence: http://www.instantfundas.com/2010/07/how-to-access-your-google-analytics.html

Excellent Analytics is here http://excellentanalytics.com/