Google Workspace Marketplace
Recode and compute data from Google Forms™ responses on the fly with formulas in Google Sheets™ and export an SPSS syntax with alpha, tests and more.
De :
Fiche mise à jour le :26 octobre 2026
Compatible avec :
8 k+
Présentation
Prepare your data once — it stays ready while responses come in. Tests, regressions, correlations and descriptives update with every new response. Results are checked against R (stats, psych, car) and Python (SciPy, statsmodels); 4,700+ automated tests. Export to SPSS: data and syntax with clear compatibility notes.

31 formulas — from data preparation to models:
• Prepare data: recode, compute new columns, z-scores, normalization, moving averages, split a column by groups.
• Describe: descriptive statistics, frequencies with value labels, confidence intervals, normality test.
• Compare groups: one-sample, paired and independent t-tests; one-way and Welch ANOVA with post-hoc comparisons; Mann–Whitney, Wilcoxon and Kruskal–Wallis tests.
• Relationships: Pearson, Spearman, Kendall and partial correlations; crosstabs, chi-square and Cramér's V.
• Scales: Cronbach's alpha, alpha if item deleted.
• Models: multiple hierarchical regression with interactions (moderation), logistic regression, bootstrap confidence intervals.
• In one go: STATS_ANALYZE runs many analyses with one formula.

Export to SPSS whenever you need it
If you know the routine — waiting for the form to close, then a long preparation: exporting to Excel, working with the raw data, importing into SPSS and describing every column by hand — ALS Stats has a nice bonus for you. From the very first responses you can write the formulas that prepare your data; they recalculate with every new response, and the result exports straight to SPSS data and syntax files.

Results take shape before your eyes
Wouldn't it be interesting to see what your survey shows before it ends? Here you see it from the first responses. Every new response recalculates the reports: you watch the means and effect sizes change and see how much sample size matters — at 20 responses, at 50, at 100.

Formulas instead of menus
The more tests in your work, the more often you go through the SPSS menus: Analyze › Compare Means › One-Way ANOVA, find and move the columns, open Options and Post Hoc, then look for the right table in the output window. In ALS Stats a test is a line in a cell: =STATS_ANOVA(A:F,"q1,q2,q3"), and the report appears right below it: the test, assumption checks, effect sizes, post-hoc comparisons. And formulas nest: recode the answers, reverse the negatively worded items and compute the scale score — in one line.

Your supervisor sees your work any time
Yes, your supervisor wants to see how you got your numbers — but you don't have to export files and send version after version. Your supervisor opens the same spreadsheet by link at any time and sees the current reports, and the cells show what was calculated and how.

Every number in the report explained
Sound familiar: a table with F, df, p and η² in front of you, and no idea what to write in your paper and how? On als-stats.net every report is fully explained: what each value means, in plain language, and a ready line for your report — https://als-stats.net/functions/

And that's only part of what you'll find in ALS Stats: alpha if item deleted to find the weak question, recoding all Likert answers at once — and much more.

Start in three steps
1. Install ALS Stats.
2. Open your responses sheet. If the formulas do not calculate, choose Extensions › ALS Stats › Activate in this file.
3. Type =STATS_FREQUENCIES(A:F,"q1,q2") — the answers to each question appear below it, with counts and percentages.

Google Sheets™ and Google Forms™ are trademarks of Google LLC. SPSS is a trademark of IBM Corp.
Informations supplémentaires
TarifsSans frais
Développeur
Non-professionnel
Assistance
Règles de confidentialité
Conditions d'utilisation
ALS Stats vous demandera les autorisations ci-dessous. En savoir plus
ALS Stats aura besoin d'accéder à votre compte Google
ALS Stats pourra ainsi effectuer les actions suivantes :
Afficher et gérer les feuilles de calcul dans lesquelles cette application a été installée
Afficher et diffuser du contenu Web tiers dans les invites et les barres latérales au sein des applications Google
Afficher l'adresse e-mail principale associée à votre compte Google
Consulter vos informations personnelles, y compris celles que vous avez choisi de rendre disponibles publiquement
Avis
Langue :
Trier par :
Google ne vérifie pas les avis ni les notes. En savoir plus sur les avis
Aucun commentaire
Recherche
Effacer la recherche
Fermer le champ de recherche
Applications Google
Menu principal