Data Analysis·2 Nov 2026·1 min read
Cleaning survey data before analysis: a checklist
Analysis is only as good as the data behind it. Use this checklist before you run a single test.
By Derxtro, Derxtro Research and Advisory

Time spent cleaning data is never wasted. Run through these checks in SPSS, Stata, R or even Excel before analysis.
- Keep an untouched copy of the raw data.
- Check every variable's range for impossible values.
- Decide how you will treat missing data, and document it.
- Recode reverse-worded items consistently.
- Label variables and values clearly.
- Log every change in a cleaning script or notebook.
A documented cleaning process also makes your methodology chapter easier to write, and easier to defend.
Want help applying this to your own work?
Book a free 15-minute call and talk it through with one of our consultants.

