Date:         Tue, 5 Apr 2011 19:13:10 +0000
Reply-To:     Ruben van den Berg <ruben_van_den_berg@hotmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Ruben van den Berg <ruben_van_den_berg@hotmail.com>
Subject:      Can't read .csv from Google Analytics into SPSS
In-Reply-To:  <1302027291722-4284687.post@n5.nabble.com>
Content-Type: multipart/alternative;


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                                     

[text/html]