I work with spreadsheets daily and have always used Excel. On the few occasions I’ve tried Google Sheets, it felt like a similar product but with a cheaper experience. Given this, why would someone choose Google Sheets over Excel? I’m really interested in hearing your thoughts on this.

I love Excel, but my workplace prefers that we use Google’s suite of apps like Docs and Sheets because we do a lot of collaborative work.

I’ve built several Excel sheets that do things like lookups in other tabs within the same sheet, pivot tables, lots of advanced calculations, etc. I want to share my Excel files with my colleagues but since they prefer Google Sheets, when they open my file on their computer after I’ve placed it in our share drive, that’s what my file opens in. I’m a little worried that some things won’t work correctly since my files were built in Excel so don’t know if everything will function properly.

What can Excel do that Google Sheets can’t? I’d rather not have to test everything in Google Sheets because that would take forever and I most certainly don’t want to rebuild them.

Edit: Thank you all for the replies! Given the major consequences of even a single error, I’ve told my colleagues they will need to use my Excel sheet or shouldn’t use it at all and that they’re more than welcome to replicate my work from the ground up in Sheets.