Hacker News new | ask | show | jobs
by selfportrait 1564 days 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
4 comments

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.
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.

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).

For larger spreadsheets google sheets is far less performant than Excel, even the cloud version of Excel.