grumpygamer, After watching @patKemp's excellent talk I've decided to ditch spreadsheets and use text config files with inheritance. I'll use JSON rather than YAML because my engine has a lot of support for it.
https://www.youtube.com/live/CZYon-aK4O0?feature=shared&t=25736