Skip to main content

Data Cleaning with Excel

Through this guide you will learn tricks and tips to better clean and organize tabular data using Microsoft Excel.

Introduction

The data cleaning exercises demonstrated in this guide reference and are taken from the Galter Health Sciences Library & Learning Center class 10 Simple Rules for Data Cleaning with Excel. The dataset used in that class can be accessed from GitHub. The dataset is a small subset of the 2018 National Electronic Injury Surveillance System dataset, available at: https://www.cpsc.gov/cgibin/NEISSQuery/home.aspx


References:

1. US Consumer Product Safety Commission. NEISS Highlights, Data and Query Builder. Available at: https://www.cpsc.gov/cgibin/NEISSQuery/home.aspx