Microsoft Excel

Learn to import data from Microsoft Excel files using readxl and purrr in the tidyverse.

For many reasons, a lot of data and analyses are often stored in Microsoft Excel. One of those reasons is that spreadsheets are very accessible and very flexible. Analysts using Excel don’t need to concern themselves with any constraints instilled by databases or programming languages. They can freely do anything, structuring their data in whatever format they like. However, that freedom gives rise to potential issues when we try to tackle more robust analytics, where data tends to be messy, files get lost, and version control is confusing or non-existent.

Get hands-on with 1200+ tech skills courses.