I work in logistics consulting - it’s pretty common to receive orderline data that is a few hundred thousand rows and excel is great at analysing it (eg to build a material flow).
Excel for this is significantly faster and more flexible than any other tool I’ve used.
Also transport data and models can often use many columns. Google Docs limit is actually the active cells used so this then reduces the row limit further.
If we receive data that is a few million rows on bigger formats, we will still use excel, just with PowerQuery / PowerPivot and using measures which works pretty well up to 10 million records or so.
Excel for this is significantly faster and more flexible than any other tool I’ve used.
Also transport data and models can often use many columns. Google Docs limit is actually the active cells used so this then reduces the row limit further.
If we receive data that is a few million rows on bigger formats, we will still use excel, just with PowerQuery / PowerPivot and using measures which works pretty well up to 10 million records or so.
Bigger than that and we will use PowerBI.