Bold indicates negative?
summary
Over a billion spreadsheet users exist and analyses find 25–60% of public spreadsheets use formatting to encode data. The workflow imports both cell values and formatting (using tidyXL), converts formatting to explicit variables with unheadr and cleaned code, and rebuilt presentation tables with forgts to gt. A real case extracts aquarium sampling dates encoded with yellow cells across many files in about twenty minutes, producing reproducible data and HTML tables that the team actually uses.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 1:29Formatting data problem
- 4:40Encoding as formatting
- 6:05Handling formatted spreadsheets
- 9:41Tools and community efforts
- 12:32Case study: formatted data challenge
- 15:05Converting spreadsheets to tables
- 16:12Conclusion
