4 ms·

It's a horrific product for anyone who actually has to use a spreadsheet for work. The developers seem pre-occupied with building strange bells and whistles whi

It's a horrific product for anyone who actually has to use a spreadsheet for work. The developers seem pre-occupied with building strange bells and whistles while ceding power user functionality to Excel. Using Excel vs. Google Sheets saves me easily 20 hours a week.

selfportrait 5y ago
What is missing in Sheets that would save you 20 hours a week vs. Excel? Genuinely curious to hear real world examples from a power user, because in the worst case scenario I use JS/G Apps Script to automate analysis/organization, which is actually a preference for me if I can't do it easily enough with a formula. I also can't stand Excel UI
- shp0ngle 5y ago
  I switched from Google Sheet to Excel when I needed to actually do some work on phone. Google Sheets are surprisingly bad on phone. I wanted to "just" do drag-to-fill (or whatever is the name... that + thing that appears when you go to bottom right)... I could not do that on iOS Google Sheets? And in general, Google Sheets on mobile are surprisingly poor.
- julianz 5y ago
  If you name a cell in Excel, then use it in a formula by clicking on the cell, Excel will use the name in the formula. Sheets won't, which misses the whole point of naming cells.
- remus 5y ago
  Im interested in this too as my experience is the same as yours. Personally I feel like going in to JS/G apps script is actually a big bonus as it means you avoid some of the really gross stuff that you get in excel (which ime ends up being really hard to maintain).
- dhruval 5y ago
  For larger spreadsheets google sheets is far less performant than Excel, even the cloud version of Excel.
mccorrinall 5y ago
I recently had to create a power set in Excel and had to use this VBA monstrosity: http://www.tushar-mehta.com/excel/tips/powerset.html http://www.tushar-mehta.com/excel/tips/powerset.html I haven't used Google Sheets yet, but looks like I could just use their API and use a simple PIP package?

selfportrait 5y ago

What is missing in Sheets that would save you 20 hours a week vs. Excel? Genuinely curious to hear real world examples from a power user, because in the worst case scenario I use JS/G Apps Script to automate analysis/organization, which is actually a preference for me if I can't do it easily enough with a formula. I also can't stand Excel UI

shp0ngle 5y ago
I switched from Google Sheet to Excel when I needed to actually do some work on phone. Google Sheets are surprisingly bad on phone. I wanted to "just" do drag-to-fill (or whatever is the name... that + thing that appears when you go to bottom right)... I could not do that on iOS Google Sheets? And in general, Google Sheets on mobile are surprisingly poor.
julianz 5y ago
If you name a cell in Excel, then use it in a formula by clicking on the cell, Excel will use the name in the formula. Sheets won't, which misses the whole point of naming cells.
remus 5y ago
Im interested in this too as my experience is the same as yours. Personally I feel like going in to JS/G apps script is actually a big bonus as it means you avoid some of the really gross stuff that you get in excel (which ime ends up being really hard to maintain).
dhruval 5y ago
For larger spreadsheets google sheets is far less performant than Excel, even the cloud version of Excel.

mccorrinall 5y ago

I recently had to create a power set in Excel and had to use this VBA monstrosity: http://www.tushar-mehta.com/excel/tips/powerset.html http://www.tushar-mehta.com/excel/tips/powerset.html I haven't used Google Sheets yet, but looks like I could just use their API and use a simple PIP package?