Using Sorting to Recode a File for input into a database in Excel

In this video, we illustrate how one might use Excel to recode a spreadsheet file to convert it into a database. We use sorting and copying to recode text categories to reduce memory and normalize data for use in a database. This process can be done in other programs (such as in Python), using Excel provides some useful context on what needs to be done.