My wife is a school administrator and every year I run a little self-written pipeline for her to munge the local authority's XML admissions data into an Xlsx th

My wife is a school administrator and every year I run a little self-written pipeline for her to munge the local authority's XML admissions data into an Xlsx that the staff can use for planning home visits, class allocation etc. Excel (well strictly speaking it's loaded into Google sheets) really is the only game in town for this kind of thing, but even at this very low level there are many fraught footguns necessitating extremely careful handling. Anyone running an election or an economy off this thing needs their head examined.