Importing Google Analytics into Excel – Text to Columns Function!


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-messAn 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.

excel-text-to-columns

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.

About these ads

4 thoughts on “Importing Google Analytics into Excel – Text to Columns Function!

  1. 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.

Comments are closed.