I think Excel online with Office Script https://docs.microsoft.com/en-us/office/dev/scripts/overview... is awesome. Combine it with OneDrive & Power Automate & you can share & automate many boring stuff.
It's always been a mystery to me why Microsoft never addressed this - they could have prevented a whole host of competitors in the "big data" space from ever existing if they'd found a way of abstracting this limit away from end users.
Too many people believe excel should do everything... no, just no