EXCELsioR!
summary
Argues spreadsheets are ubiquitous data sources and shows a workflow that extracts messy balance sheets from 56 Excel files into a single tidy table using R and tidyxl, producing a clean result with one line of code for the core reshape. Describes concrete problems—mixed types, Excel hash errors, duplicate IDs that later disappear, clients revising sheets—and a final design that keeps logic in a single model tab while automating cleaning and reproducible reruns.
AI-written summary · about
chapters (7)
- 0:00Introduction and speaker intro
- 1:14Why spreadsheets matter
- 3:02Spreadsheets as universal data language
- 5:34Tidy Excel for messy data
- 8:47Excel model limitations
- 11:20Key challenges with Excel data
- 13:54Summary and conclusions
related talks
53mThe Pain and Glory of Data Preparation
48mSmart Spreadsheets
17mFive signs your spreadsheet might smell (and what you can do about it)
17mOddly Satisfying - Find delight in the mundane
18mBold indicates negative?
48mSpreadsheets for Developers
39mSpreadsheets for developers
53mCreating Outstanding Spreadsheet Models