Back to Browse

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

35 views
Feb 18, 2024
15:35

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.

Download

1 formats

Video Formats

360pmp426.6 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

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