Excel/Survey Monkey and SPSS

[futureapppsy2]

---

Members do not see this ad.

Hi,

How do you go about getting Survey Monkey results into SPSS? Can you copy and paste from Excel or import the data some other way without re-entering all the data by hand (I hope so!)?

Thanks!

 

[dotdash]

You can download an Excel file from Survey Monkey, save it, and then read it in directly from within SPSS. (File.. Open Data..). You will get a chance to make sure it's reading in correctly, but basically it's pretty seamless. After you've opened it in SPSS, of course, save it as an .sav file and you're done.

 

[futureapppsy2]

Thanks!

 

[Cosmo75]

There is some data cleanup that you'll have to do. I use Survey Monkey quite a bit. It's very simple to understand. This is especially true if you used multiple choice with multiple answer questions as each answer will be in it's own column.

 

[futureapppsy2]

What are common "data clean up" issues you have?

 

[blindblonde]

I haven't worked with Survey Monkey, but I do know that you can import/export from Excel to SPSS.

Also, just for general information, you can use data list file syntax in SPSS to import text files into SPSS. I used this syntax quite a bit with data entry (just do all your data entry in Microsoft Word, save as a text file, and import into SPSS--no tabbing with data entry and fewer mistakes), as well as getting data off my palm pilots in experience-sampling research. If you want more specific details, just let me know. 🙂

 

[Cosmo75]

What are common "data clean up" issues you have?

The main one is if you have a multiple choice question with multiple answers and your variable in SPSS will be categorical. Each answer will appear in its own column. So answer 1 will be in column A, answer 2 in column B, etc. So you have to consolidate them all into 1 column. The rest tends to be pretty clean in my experience.

 

[JW05150]

Hey guys,

I have a question about importing data from survey monkey... I have no problem getting it into excel and spss but what I am having trouble with is renaming the questions into variables.. Is there a way to do this in survey monkey where you can indicate that instead of exporting the whole question it could be just exported as one word? For instance, instead of the box saying What is your highest level of education? (as the question appears on survey monkey) it could say simply "education"? or do you have to manually rename this in excel/spss... Finally, if I rename it after the first export is there a way to always have the data open in that one file with the renamed questions/variables? I have no idea if this is even probable as I am really not good with computers but I'm hoping one of you guys can help... thank you, thank you!🙂

 

[Ollie123]

To my knowledge, you have to rename them (one of my bigger complaints about surveymonkey). I haven't used it in awhile though, so they may have added something that lets you get around that.

You certainly don't have to re-name it each time. There's a bunch of ways around it...you can copy the data into that file and then (I think) SPSS has an option to find and delete duplicate cases, you can sort by date and then just copy and paste the data, you can import the variable settings into the updated dataset. There are many options there, it just depends on what works best. For example, if you have changed the order of the variables or anything like that then copying and pasting won't work.

 

[OlliePsych]

yeah, there will be some clean up to do. I would advise doing that before you put it into SPSS, this makes it a lot easier (at least to me)

 

[deleted176373]

yeah, there will be some clean up to do. I would advise doing that before you put it into SPSS, this makes it a lot easier (at least to me)

+1, USE EXCEL for a first pass cleaning and write SPSS code to setup all your variables once you read it in...

Excel to get rid of excess header information and to rename the variables. I would cut and paste my renamed variable list across the top getting rid of the 2 lines generated by Survey Monkey, sort the file, resolve and/or get rid of duplicates and/or missing data.

Once in SPSS I would open my syntax file that did the magic... which looked like this (If you are not using SPSS syntax yet, learn how, great time saver):

This is an abridged version of a much more complex file.

** OPEN FIRST XLS FILE FOR PROCESSING **

GET DATA /TYPE=XLS
   /FILE='F:\datarun\Sheet_1.xls'
   /SHEET=name 'Sheet1'
   /CELLRANGE=full
   /READNAMES=on
   /ASSUMEDSTRWIDTH=32767.
DATASET NAME DataSet1 WINDOW=FRONT.
EXECUTE. 

** DEIDENTIFY THE DATA BY DELETING VARIABLES I DON'T NEED **

DELETE VARIABLES RID IP V1 V2 V3 V4 CONSENT EVEN CNSVS1 ODD CNSVS2 Email Name Street City ST ZIP Hphone Wphone Aphone EMail2 SSN Links END. 
EXECUTE.

** RENAME VARIABLES THAT I BUGGERED UP IN EXCEL **

RENAME VARIABLES (FC30 = BRFS) (FC31 = ROTTERDAM1) (FC32 = ROTTERDAM2) (FC33 = ROTTERDAM3).
EXECUTE.

** RECODE VARIABLE VALUES THAT SURVEY MONKEY REVERSED OR SCREWED UP **

RECODE WLQ1 WLQ2 WLQ3 WLQ4 WLQ5  (1=4)  (2=3)  (3=2)  (4=1)  (5=0)  (6=0).
EXECUTE.

RECODE ROTTERDAM1 ROTTERDAM2 ROTTERDAM3  (1=0)  (2=1)  (3=2)  (4=3)  (5=4).
EXECUTE.

** ADD DATA LABELS **

ADD VALUE LABELS StudySRC     
1 'Hospital or Medical Center or Clinic' 
2 'Support Group'
3 'Website'
4 'Craigslist'
5 'Newsletter'
6 'Support Group Email'
7 'Newspaper'
8 'Word of Mouth' 
9 'Other' .
Execute .

ADD VALUE LABELS Distraction            
1 'Yes'
2 'No' .
EXECUTE.

** COMPUTE NEW VARIABLES OR TOTALS OF MEASURES FROM EXISTING MEASURES **

COMPUTE WLQOUTPUT = WLQ1 + WLQ2 + WLQ3 + WLQ4 + WLQ5.
EXECUTE.

COMPUTE MFSIFATIGUE = MFSI1 + MFSI2 + MFSI3 + MFSI4 + MFSI5.
EXECUTE.

** OPEN SECOND DATAFILE **

GET DATA /TYPE=XLS
   /FILE='F:\datarun\cnsvs.xls'
   /SHEET=name 'cnsvs'
   /CELLRANGE=full
   /READNAMES=on
   /ASSUMEDSTRWIDTH=32767.
DATASET NAME DataSet2 WINDOW=ASIS.
EXECUTE .

** MERGE DATA SOURCES by Participant ID**

MATCH FILES /FILE=* 
 /FILE='DataSet1'
 /FILE='DataSet2'
 /BY PID.
EXECUTE.

** RECODE ANY DATA FROM SECOND FILE **

RECODE
  Age (18 thru 25=1)  (26 thru 30=2)  (31 thru 35=3)  (36 thru 40=4)  (41 thru 45=5)  (46 thru 50=6)  (51 thru 55=7)  (56 thru 60=8)  (61 thru 65=9)  INTO  AgeCategory.
EXECUTE .

** SAVE OUR DATASET **

SAVE OUTFILE='F:\datarun\New Data Run.sav'
 /COMPRESSED.
EXECUTE .