← The Derxtro Journal

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.

  1. Keep an untouched copy of the raw data.
  2. Check every variable's range for impossible values.
  3. Decide how you will treat missing data, and document it.
  4. Recode reverse-worded items consistently.
  5. Label variables and values clearly.
  6. 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.