How to Analyze Google Forms Data Without SPSS (Free, On Your Phone)

Most student researchers collect data the same way: a Google Form goes out, responses pile into a Google Sheet, and then… the laptop problem begins. SPSS needs a licensed copy on a computer, and many students do not have one. Here is the complete alternative workflow: from your Google Sheet to SPSS-style frequency tables, charts, statistical tests and a full PDF report — entirely on your phone, offline and free.

Step 1: design your form for analysis

Good analysis starts before a single response arrives:

• Use MCQ-style questions. Multiple-choice, checkbox ("tick all that apply") and dropdown questions analyze beautifully. Long free-text answers do not — keep at most one optional "comments" box.
• Keep option text identical everywhere. "Yes" vs "yes" splits your frequency table into two rows. Copy-paste the same options across questions.
• One question, one idea. "Do you smoke and drink?" cannot be analyzed — split it into two questions.

Step 2: connect responses to a Google Sheet

In Google Forms, open the Responses tab and click the Sheets icon. Every new response now lands as a spreadsheet row, with your questions as column headers. Keep the first row as clean headers — rename any "Untitled question" before collecting data, because the header text becomes your variable name in every table and chart.

Step 3: load the data on your phone

Open the FormStat app and choose how to load your data:

• Sheet link — paste the Google Sheet's share link (set sharing to "Anyone with the link"). Fetching the sheet is the only moment the internet is needed.
• Excel / CSV file — download the sheet as .xlsx or .csv and open it from your phone's storage.
• Paste — copy cells straight from a spreadsheet and paste them in; the delimiter is auto-detected.

Everything after loading runs offline, and your data is never uploaded anywhere. You immediately see summary chips: number of responses, number of questions, empty cells.

Step 4: frequencies and charts for every question

Tap any question chip to see the classic SPSS-style table: value, frequency, percent, valid percent, cumulative percent, plus a missing-count row. Toggle between bar chart and pie chart for your figures. For "tick all that apply" questions the app detects the pattern automatically and splits each cell on commas, giving the SPSS-style multiple-response table with % of responses and % of cases (yes — % of cases legitimately sums above 100%).

Step 5: run the one comparison your objectives need

Pick a grouping question (gender, year of study, smoker/non-smoker) and run the matching test — each shows the statistic, the p-value and a plain-English interpretation:

• Chi-square / Fisher's exact — two categorical questions
• Welch's t-test / Mann–Whitney U — a numeric outcome across two groups
• ANOVA / Kruskal–Wallis — a numeric outcome across three or more groups
• Pearson / Spearman correlation — two numeric questions, with scatter plot

Unsure which test fits? The built-in test recommender asks four short questions and points you to the right one.

Step 6: download the full analyzed PDF

One tap on the Report card builds everything: frequency tables for every categorical question, descriptives and histograms for numeric ones, multiple-response tables, and every comparison you ran. Choose "PDF with charts" for presentations or "PDF without charts (tables only)" — the tables drop straight into your thesis document.

Sanity checks before you trust the numbers

Before writing up results, spend two minutes verifying the data survived the trip intact:

• Response count matches. The app's summary chip should show the same number of responses as your Google Form. A mismatch means the sheet didn't finish syncing — reload.
• Headers are clean. Open the Data View and scan the column headers: no duplicates, no "Untitled question", no trailing spaces.
• Percentages behave. In any frequency table, the valid percents should sum to 100 (give or take rounding). If they don't, a stray value — often a typo like "Yse" — is hiding in the data; fix it in the editable grid.
• Spot-check one respondent. Pick a response you remember filling in yourself and confirm its row looks right. If that row is correct, the import is almost certainly correct everywhere.

Tips that save you later

• Pilot-test on 5–10 people and fix confusing questions before real collection — analysis cannot rescue bad questions.
• Decide your main comparisons before collecting data and write them into your objectives.
• Check sample size first with the OpenEpi-style calculator — 80 responses cannot answer a question that needed 384.
• Fix typos in the editable Data View instead of re-collecting — tap any cell, correct it, and every result refreshes.

Frequently asked questions

Is my data uploaded anywhere?

No. The app runs entirely on your phone; the sheet link is fetched directly by your browser and nothing is stored on any server. Closing the tab clears it from memory.

Can it handle 300+ responses?

Yes — the app is built for real fieldwork volumes. Frequencies, tests and the full PDF report all work with hundreds of rows.

What if my supervisor asks for SPSS output specifically?

Show them the tables: the frequency-table columns (frequency, percent, valid percent, cumulative percent) and the test statistics follow SPSS conventions, and the PDF report is formatted for thesis appendices.

Do I need internet while analyzing?

Only once — to fetch the Google Sheet. After loading, airplane mode is fine.

Start now: open the free FormStat app on your phone — no signup, no laptop, no SPSS license.