Coping with a Spreadsheet Database
A common way to save persistent, important data is a spreadsheet. It provides a handy, potentially normalized store that's readily accessible with minimal tooling. It has a UI usable by people with a spectrum of skills.
Sadly.
There's a core conflict:
- The advantages of spreadsheets-as-database are numerous.
- The disadvantage is …