Date: Tue, 5 Apr 2011 19:13:10 +0000
Reply-To: Ruben van den Berg <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Ruben van den Berg <firstname.lastname@example.org>
Subject: Can't read .csv from Google Analytics into SPSS
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!