A Guide From Domandata
Survey Software That Exports to Stata, SPSS, and R
Written by Domandata, which makes a survey platform. We name our product where it fits and say where another tool fits better. Claims about other tools link to their own documentation, checked ; confirm anything decisive with the vendor or your institution.
Getting survey data into Stata, SPSS, or R with labels intact can take minutes or most of a day, depending on the tool. A native file keeps variable and value labels; a CSV plus syntax script usually works but needs a step; a spreadsheet leaves the recoding to you.
This page compares what each tool's official documentation says it exports, and what else to check before you trust an export.
What makes an export analysis-ready
- 1
Native file or CSV plus script
A native .dta, .sav, or .RData file opens with labels in one step. A CSV with a syntax script also works but adds a step that can break on special characters or long text.
- 2
Variable names you control
Set short, stable variable names in the survey before launch, so the export matches the names in your preregistered analysis code.
- 3
Value labels and missing codes
Check that answer labels arrive as value labels and that skipped, not-shown, and declined answers are distinguishable.
- 4
Design metadata
Assigned condition, randomized order, timing, and quality flags should be columns in the same file, not in a separate report.
- 5
Multi-select and grid layout
Check how each tool lays out multiple-answer and matrix questions, since one column per option and one column per question need different code.
- 6
Test with your own script
Export a pilot dataset and run the full analysis script on it before launch. It is the only check that catches every problem.
Tools by export style
Native files for all three packages
Domandata exports .dta for Stata 14 and later, .sav, and .RData that loads without extra packages, with conditions and quality flags in the same file, and randomized display order by default. REDCap documents exports for SPSS, SAS, Stata, and R.
SPSS files
Each exports .sav, which Stata reads with import spss and R reads with the haven package. Check license or plan requirements before relying on it.
Data plus import scripts, at no cost
Both provide scripts that load labelled data into SPSS, Stata, and R. LimeSurvey's native .sav and R exports need plugins enabled.
Spreadsheets only
Fine for simple data you will recode yourself. Gorilla's long, trial-level format suits reaction-time analysis in R or Python.
Export formats at a glance
| Tool | SPSS | Stata | R | Other |
|---|---|---|---|---|
| Domandata | Native .sav | Native .dta (Stata 14+) | Native .RData | CSV, codebook; paid plans |
| Qualtrics | .sav, optional syntax file | Not documented | Not documented | CSV, TSV, Excel, XML; varies by license |
| REDCap | Documented | Documented | Documented | SAS, Excel, CSV |
| LimeSurvey | .sav (plugin) or .sps + data | XML for Stata import | Data + R syntax (plugin) | CSV, Excel |
| SoSci Survey | .sps syntax with data | CSV + import script | CSV + script or API import | Excel with codebook |
| SurveyMonkey | .sav on paid plans | Not documented | Not documented | CSV, Excel; no export on free plan |
| Alchemer | .sav (Full Access license) | Not documented | Not documented | .sps + .txt option |
| KoboToolbox | Labels syntax for CSV data | Via SPSS conversion | Not documented | XLS, CSV, GeoJSON |
| Gorilla | Not documented | Not documented | Not documented | CSV or Excel, long or wide |
| Google Forms | Not documented | Not documented | Not documented | Google Sheet or CSV |
| Microsoft Forms | Not documented | Not documented | Not documented | Excel |
From each vendor's official documentation as of the review date. "Not documented" means the official pages reviewed did not list it; every tool's CSV or Excel export can still be imported by hand. Formats can depend on license or plan.
Before you trust an export
- Variable names match your analysis code
- Value labels arrive intact
- Skipped, not-shown, and declined answers are distinguishable
- Assignment and randomized order are in the file
- Multi-select and grid questions are laid out as your code expects
- Non-English characters survive the round trip
- Your full analysis script runs on the pilot export