Download: Excel Quick Data-Cleaning Tips Guide

This 2020 guide provides quick data-cleaning tips in excel, including examples to address the what and how.

This resource provides strategies for cleaning data in Microsoft Excel. Below is a brief overview of five situations you may find yourself in (“What”) and corresponding solutions (“How”), followed by detailed instructions to implement the solutions.


resource preview
Resource preview.

About the Authors

Miranda Lee

Miranda Lee box with arrow

Doctoral Candidate, The Evaluation Center at Western Michigan University

Miranda Lee is a project manager at the Evaluation Center at Western Michigan Unviersity. She is also a doctoral candidate in the Interdisciplinary Ph.D. in Evaluation program. Her primary responsibilities with EvaluATE involve the maintenance of our contact list and our database of evaluation data, conduct of the annual survey, webmaster, and contributor to various EvaluATE products.

Creative Commons

Except where noted, all content on this website is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Nation Science Foundation Logo EvaluATE is supported by the National Science Foundation under grant numbers 0802245, 1204683, 1600992, and 1841783. Any opinions, findings, and conclusions or recommendations expressed on this site are those of the authors and do not necessarily reflect the views of the National Science Foundation.