Importing Google Analytics data into Excel seems to be, for me at least, a chore but the Text to Columns function in the Data tab makes it easy. Import the data, in this example Content data, as a CSV file into Excel, open it and arrrgh, unholy mess which seems unusable.
An unholy excel mess…
But, select the Content data (which is all stuffed into one column) and then click on Text to Columns in the Data tab. After checking ‘Delimited’, check other ‘.’ and comma.
This will hopefully make some more sense of your data, and spread it out into separate columns. You’ll probably have to sort out some of the data manually, but it will certainly be faster than copy and pasting the data direct from GA. I probably should get out more.
Maybe this brand new plugin for Excel will help you import data from Google Analytics more easily?
Hi Mark, thanks for that – could you send a link please?
The name is linked. Can’t include the link in the text since the message then gets discarded.
Enjoy!
It’s free and open source.
Thanks Mark, I’ll check it out.