I believe Sheets contains virtually all Excel functions, and while Excel supports 1M rows, Sheets supports 5M cells, so they can both outperform each other in size depending on how many columns you have.

But yes, add-on tools are going to be platform-dependent in both directions.