20 November 2026
Improve spreadsheet reliability by inspecting structure before calculating results.
Getting started
Make a working copy and define one row per observation. Standardise dates and categories, remove obvious duplicates and distinguish missing values from zero values.
Putting it into practice
Check totals and sample records against the original source. Add data validation where a category must come from a known list. Record cleaning choices so the workbook can be maintained or audited.
Try it yourself
Clean a sample CSV and keep a tab showing every transformation.