In my experience it's mostly about understanding business requirements of people using said excel sheets and then replicating it to CRUD WebApps while keeping capabilities of importing said sheets and exporting them so user flows are unharmed till a wholesale transition is mandated.

Good source of money for contractors as OP said.