Sheets lags at 1000 rows. Excel allows 1 million. Excel has incredible optimization capabilities, it's numerics are vastly faster (and more accurate, thanks to Javascript being terrible for accurate math). While Javascript (sheets) is decently performant, it's no match for C++ and hand tuned assembly making Excel work. I tried but cannot find a single performance benchmark where Sheets outperforms Excel.

And the first time you need sheets to interact with any of the zillion excel spreadsheets running on the planet (all of finance and pretty much all of corporate America) and it fails and it costs you a contract, you'll switch immediately.

I'm guessing you really don't push either much at all.

Despite Sheets having a free version for almost 20 years, Excel sales are at all time highs. Go figure.

Sure I am not a power user. I doubt most people are :) I never found a CSV and instantly thought "oh wow let's put that in excel" I usually would just write a random script to get the data I want the way I want it.

Edit:// I am not sure if increased sales means anything when they switched their license model so often and aggressive

Most people aren't power users of Photoshop either, but no other program comes close to being able to do what it does, which is why it's the tool of choice for the vast majority of professionals that edit photos. The same thing goes for Excel. Your anecdata of being an amateur doesn't provide evidence that Excel is not a superior product, any more than a claim MSPaint is better than Photoshop because all you do is draw circles.

If all you do is CSV things then you're not even a basic user of either. The power isn't a viewer for a table of data.

As to increased sales, I find it amusing where there's good evidence for a thing being true, and people not wanting it to be true make up the most fringe excuses. The fact is sales are up by a lot. If you're going to make handwave claims, demonstrate a fact that your excuse is an actual fact, not a wishful claim to save face. If anything, as the world does more and more data analysis, Excel is one of the most used tools, because it's good for that, so it also makes sense there is more, not less, demand for Excel. And if the license model pissed enough off there a completely free "alternative". Why don't they all jump ship if it's usable?

Occam's razor :)

I just did a search on indeed.com to see job listings with "microsoft excel", 500,000 hits. I did the same search with "google sheets", zero hits. Ouch.