This article walks you step-by-step through the process we use when merging datasets from multiple sources.

One of the most common things I see when I work data in excel that others have compiled or analyzed is the under-use of Excel’s computational powers. In part, this has to do with setting up your data correctly to all Excel to do the work.

We’ve all been there – you get some data from a client or a survey you’ve run, and you can’t wait to start answering your evaluation questions. But you find one of your data columns is a complete mess because it was an open-ended text field.

Cleaning this messy data can be a day-ruining task - but this doesn’t have to be! I’m going to show you how to use OpenRefine to make this task a million times easier.