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

Posted by Ruben Geert van den Berg on Apr 05, 2011; 7:58pm
URL: http://spssx-discussion.165.s1.nabble.com/Multiple-imputation-tp1075737p4284970.html

Thanks a lot, Rick!

The rubbish is not really a problem, I can drop it by specifying a cell range.

I tried switching Unicode on (set unicode on.) and just using syntax instead of the wizard, generating

>Error.  Command name: GET DATA 

>(2054) The file is not in a recognized Excel file format. 

>* File: "C:\Documents and Settings\Ruben\Bureaublad\NetSociety_SPSS\Analytics_www.netsociety.nl_20100405-20110404 (1).xls" 

>Execution of this command stops. 

DATASET NAME DataSet2 WINDOW=FRONT.

So the problem is the encoding of the xls file you think? Do you have a clue what the encoding could be and what it should be? Because if I know that, I could perhaps try and bother the python forum with the rest of my troubles...

Best,

Ruben

---

Date: Tue, 5 Apr 2011 14:30:45 -0500
From: [hidden email]
Subject: Re: Can't read .csv from Google Analytics into SPSS
To: [hidden email]

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