SPSS · Google Forms

How to move Google Forms data into SPSS: cleaning, coding and importing it correctly

You open the sheet and it is all “Strongly agree” and “Female”, with checkbox answers crammed into one cell. Here are 6 steps to a clean SPSS file you can analyze straight away.

⏱ ~6 min readApplies to: Google Forms · Google Sheets · SPSSUpdated:

Your survey is done, you download the responses, and the whole file is text: “Strongly agree”, “Female”, “$500 to $1,000”. The column names are entire questions, and checkbox answers are crammed into a single cell. SPSS cannot run anything on data like this. This guide takes you through 6 steps to move Google Forms data into SPSS, from downloading and cleaning to coding and declaring variables, plus the traps that quietly corrupt your results.

A table of Google Forms text answers converted into numbers with valid SPSS variable names
The same data before and after coding.

1Why you cannot run SPSS on the raw Google Forms file

Problem in the downloadWhat happens in SPSS
Answers are text (“Agree”)String variables: no means, alpha or EFA
Column names are whole questionsSPSS shortens them or renames to V1, V2…
Checkboxes share one cell (“Facebook, TikTok”)You cannot count each option
Test, duplicate or off-target responsesSkewed results and an inflated sample
Six steps: download, clean, name variables, recode, split checkboxes, import into SPSS
The six steps from the form to a .sav file.

2Step 1: Download the responses from Google Forms

🖱️ Clicks
  1. Google Form→Responses→Link to Sheets
  2. Google Sheets→File→Download→Microsoft Excel (.xlsx)
⚠️ Always keep the original

Save one raw copy you never edit and do all your work on a duplicate. If you need to check something or your supervisor asks for the source data, it is there.

3Step 2: Clean the data and remove invalid responses

According to Pallant (2020), cleaning is a required step before any analysis. Go through:

  • Test responses: the ones you submitted to try the form.
  • Duplicates: the same person submitting more than once.
  • Failed screening or attention-check questions.
  • Straight-lining: the same answer to every Likert item, including reversed ones.
  • Too many blanks in the main scales.
✦ Record what you removed

Note how many responses came in, how many you removed and why, and how many remain. Committees often ask about this in the methods and results chapters.

4Step 3: Name your variables for SPSS

Replace the long column titles with short names that follow SPSS’s rules: start with a letter, no spaces, no special characters, no duplicates. Use construct code + number: SAT1, SAT2, PI1…

Google Forms columnSPSS variable
What is your gender?GENDER
I am satisfied with the product qualitySAT1
I will keep buying this productPI1

The full question is not lost: it goes into the Variable Label in step 6.

5Step 4: Recode text answers to numbers

Option 1: Find & Replace in Excel

Replace “Strongly agree” → 5, “Agree” → 4 and so on across the Likert columns.

⚠️ The substring trap

“Agree” sits inside “Strongly agree”, and “Disagree” contains “agree” too. Replace “Agree” first and you get “Strongly 4”. Always turn on “Match entire cell contents”, or replace longer text before shorter text.

Option 2: Recode in SPSS

🖱️ Clicks
  1. Transform→Recode into Different Variables→Old and New Values
  2. Enter each pair: Old Value (String) “Strongly agree” → New Value 5, and so on.
⚠️ Do not use Automatic Recode for Likert items

Transform → Automatic Recode assigns codes in alphabetical order, not by level: “Agree” becomes 1, “Disagree” 2, “Neutral” 3… Your scale is scrambled, and alpha and regression are wrong without any error message.

6Step 5: Split multiple-choice (checkbox) answers

Google Forms puts all selected options in one cell, separated by commas. Each option must become its own variable with 1 (selected) or 0 (not selected):

Original answerSRC_FBSRC_TTSRC_YT
Facebook, YouTube101
TikTok010

In Excel, a formula such as =IF(ISNUMBER(SEARCH("Facebook",C2)),1,0) works for each column. Watch out for option names that contain commas or that sit inside another option’s name.

To analyze them, use Analyze → Multiple Response → Define Variable Sets for a frequency table across the group.

7Step 6: Import into SPSS and declare your variables

🖱️ Clicks
  1. File→Open→Data→pick the .xlsx · tick “Read variable names”
  2. In Variable View, fill in Label (the question), Values (1 = Male, 2 = Female…), Missing and Measure (Nominal / Ordinal / Scale).
  3. Check with Analyze → Descriptive Statistics → Frequencies that no odd values remain (such as a 6 on a 1–5 scale).
  4. Save as .sav, which works for both SPSS and AMOS.
🔢
Details
How to code each variable type and label it
Nominal, ordinal, binary, Likert, reversed items and value labels.
→

8How to convert Google Forms to SPSS automatically

With a few dozen questions and a few hundred responses, steps 3–5 can eat an entire afternoon, and one wrong replacement ruins a whole column. The Light Data’s SPSS encoding tool follows one consistent plan:

⚡ Four steps with the tool
  1. Paste the Google Form link: an AI assistant reads the questions and proposes valid SPSS variable names and a coding table.
  2. Review the coding plan: adjust names and values if needed (free).
  3. Add the responses sheet link, shared as “Anyone with the link can view”.
  4. Download the Excel file with a coded data sheet (checkboxes already split into 0/1) and a codebook sheet, ready to open in SPSS.

You still do the cleaning in step 2 yourself, because those are academic decisions only you can make. Credits are charged only when a file exports successfully; reading the form and reviewing the plan are free.

🎯 Ready-to-analyze checklist
  • You have a raw copy, and removed test, duplicate and invalid responses with counts recorded.
  • Variable names are short and valid; Likert items are numbers 1–5 in the right direction; reversed items are flagged.
  • Checkboxes are split into 0/1; Variable View has Label, Values and Measure.
  • Frequencies show no odd values, so you are ready for Cronbach’s alpha.

Frequently asked questions

Can SPSS open a Google Sheet directly?

Not directly. Download the sheet as .xlsx or .csv, then use File → Open → Data in SPSS. The answers are still text at that point, so they need coding before analysis.

How do I enter checkbox questions into SPSS?

Google Forms puts all selected options in one cell, separated by commas. Split each option into its own variable with 1 (selected) or 0 (not selected), then analyze them with Multiple Response.

Which responses should I remove when cleaning?

Duplicates, responses that failed a screening or attention-check question, responses with the same answer to every Likert item, and responses that skip many key questions.

Is there a tool that codes Google Forms data automatically?

The Light Data’s SPSS encoding tool reads your form, proposes variable names and a coding table, splits checkbox questions and exports Excel with a codebook. Reviewing the plan is free; credits are charged only when you export.

Do I need a codebook?

It is worth keeping. A codebook records each variable name, its question and what every code means, so you read results correctly, and it often goes in the thesis appendix.