Re: Can't read .csv from Google Analytics into SPSS

Posted by Rick Oliver-3 on Apr 05, 2011; 7:30pm
URL: http://spssx-discussion.165.s1.nabble.com/Multiple-imputation-tp1075737p4284919.html

A few things to try:

Clean up the file in Excel and delete the "rubbish".
Since you're already in Excel, save the file in Excel format.
In SPSS, switch to Unicode mode before reading the Excel file.



From:        Ruben van den Berg <[hidden email]>
To:        [hidden email]
Date:        04/05/2011 02:16 PM
Subject:        Can't read .csv from Google Analytics into SPSS
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Dear all,

I wanted to examine some data from Google Analytics and what could possibly be a better option for this than SPSS??

However, I somehow don't succeed reading the .csv data into SPSS. I already tried to change the extension to .txt and .xls but whatever I try, SPSS seems unable to read it (even though it opens fine in EXCEL). In the preview of the SPSS import wizard, I see incomprehensible signs, like a "Y" with two dots on top of it.

In GA, I used ".csv for EXCEL", this seemed a better option to me than just ".csv".

Lines 1-9 in EXCEL are rubbish, line 10 contains (valid) variable names and the actual data start at line 11.

Can anybody please suggest how to fix this?

Thank you in advance!

Ruben