[geysersam]

Seriously doubt Google Sheets lacks powerful features that Excel has (except niche features). Why would the developers intentionally cripple their product? It's not like any common operations on table data is too challenging for the Sheets team to implement. If there's any real difference between the softwares it's in their respective focus.

[dijit]

I really despise Microsoft (from an irrational place) and even I have to agree that Sheets is relatively crippled.

Even basic chart types are not supported, I think it might be due to limits of what's possible in the browser.

Granted though, excel can't backed on bigquery.

[miniBill]

Google Sheets is nowhere close to Excel in terms of features, and not just niche ones. The biggest being tables, IMO.

[actionfromafar]

Not intentionally cripple. It takes years to get to feature parity even with laser focus. If that focus isn't there (deciding Sheets has a slightly different positioning in the market for instance) it's not getting to feature parity.