Wanted: simple free way to export GA data (e.g. to CSV)

theWebalyst

unread,

Jul 19, 2010, 6:03:47 PM7/19/10

to google-analytics-api - GA Data Export API

I've seen the apps and tried excellentanalytics.com but my Excel is
too old for it.

I am really surprised to find that Google (with their data
accessibility pronouncements) don't provide a simple way to export
data. Even more surprised that I can't find a free third party tool.

Have I missed one?

Thanks

Mark
http://theWebalyst.com

mike3s

unread,

Jul 19, 2010, 7:14:50 PM7/19/10

to google-analytics-api - GA Data Export API

automateanalytics.com a.k.a. Mikael's page. He has been giving away
Google Analytics query code since the API came out and is written up
everywhere there is a comparison. Surprised you didn't come across
it. Excel VBA code, which he states is 2003 compatible.

Nick

unread,

Jul 19, 2010, 7:48:40 PM7/19/10

to google-analytics-api - GA Data Export API

Also (as I'm sure you already know)

Custom reports in the web interface has an export to CSV option.

If you need to automate pulling of data, you can also use our free
API.
-Nick

theWebalyst

unread,

Jul 20, 2010, 7:46:40 AM7/20/10

to google-analytics-api - GA Data Export API

Thanks both mike3s and Nick. Your pointers are both useful.

Didn't know about the export from reports option, despite searching
Google it didn't show up. I think the GA UI is frequently obtuse, and
web search is creaky these days with so much spam SEO.

I am so far unable to get Mikael's stuff working in Excel 2000 (or
OpenOffice Calc), but the CSV report is probably adequate so I'll try
that.

Mark
http://theWebalyst.com

Marcus Taylor

unread,

Jul 20, 2010, 12:10:50 PM7/20/10

to google-analytics-api - GA Data Export API

Hi Mark,

Here is a resource comparing all of the leading GA API tools, which
might be of use in your search for a free tool to export GA data.

http://blog.gartoo.net/gartoo-releases-report-on-google-analytics-api-tools/lang/en/
or http://www.lokkulabs.com/content/Review-of-Analytics-API-Tools-by-LokkuLabs-Gartoo.pdf

Hope this helps,
Marcus

Ravi Pathak

unread,

Jul 21, 2010, 4:26:54 AM7/21/10

to google-analytics-api - GA Data Export API

Hi Mark,

Disclaimer : I work for Tatvic.

You can use Tatvic Excel plugin, for your older version of excel , it
should work.

While its not free of cost (not many good things are apart from GA
API :) , If you can let me know the purpose of use , I will be happy
to help to structure it out, appropriately for you.

Best,
Ravi

chrissky

unread,

Jul 21, 2010, 11:37:03 AM7/21/10

to google-analytics-api - GA Data Export API

Hi Mark,

Chris Harrington from ShufflePoint here. Our service is not free, but
we do support older versions of Excel and also OpenOffice.

- Chris

Reply all

Reply to author

Forward