5 ms·

Google Sheets > Excel

by hbarka 4y ago

filmgirlcw 4y ago
I shouldn’t respond to this but…in what universe? Please share whatever drug you’re on with the class.
- orange_fritter 4y ago
  Apple Numbers for iOS has entered the chat
  - filmgirlcw 4y ago
    I almost made a Numbers joke!
  - HFguy 4y ago
    Nice...I would give you an award if I could.
- t6jvcereio 4y ago
  I bet you it's someone who used Excel for work, and whose entire analysis is something like "it's on the browser and it's easier to share documents".
- makeitdouble 4y ago
  Yes, that's a crazy thing to say without explaination. I think Excel will be unbeatable as an offline spreadsheet application for many years, if a competitor ever appears. Now, if what you're looking for is not offline spreadsheets, but a tabular interface that can be messed around in JS, with an API integration, Sheets is an excellent product that fills Excel's niche but in a connected system. disclaimer: I haven't touched much of office 365's online part, but am under the impression scripting with cloud services is not the direction MS is going for.
  - samplatt 4y ago
    >scripting with cloud services is not the direction MS is going for. It absofuckinglutely is the direction they're going for. MS Flow, Teams and Sharepoint integration, upgrades to simultaneous-editing-documents-in-the-browser... the main problem is that they're trying to go too big too quickly which is causing hiccups especially from MS Teams, and also that anyone that doesn't use Excel seriously is already on Google Sheets with no real reason to migrate.
  - Godel_unicode 4y ago
    Excel has had a JavaScript api since at least 2016. Excel online definitely has the ability to integrate with online services, although at that point you really want something like Power Automate. See also Microsoft Graph, which has an Excel API as well. Edit: https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0 https://docs.microsoft.com/en-us/graph/api/resources/excel?v...
    - foomz 4y ago
  - filmgirlcw 4y ago
    Totally agree that Sheets is better as a quick and dirty web-based spreadsheet app. I’d still prefer something like Airtable for most of the use cases you outlined, but Sheets is absolutely a good quick and dirty tool. But once you go beyond that, all, as we’re both saying, it’s not even a conversation. And anyone who is trying to argue against Excel on its merits as a power app (no pun intended) is on something or not arguing in good faith. (O365 has improved a lot but I still think GSuite feels faster. But I don’t hate Office Online or whatever it is called.)
system2 4y ago
For sharing and viewing, yes. For anything else including speed, macros, options, keyboard shortcuts, MS Excel kills anything. Google is for convenience, I wouldn't even consider it a professional software at its current level.
quartesixte 4y ago
No professional organization that depends on Excel to make things with real consequences should be using Google Sheets.
- bardworx 4y ago
  Large audit firms (Big4) use google sheets and they do some real crazy/awesome stuff. Why are you poo-pooing on the tech? Edit: They also use Excel, btw. It’s just the right tool for the right job.
  - emeril 4y ago
    haha, maybe Big 4 does, but, generally speaking, the best employees of Big 4 leave for greener pastures as soon as possible I've never seen anything remotely impressive from a cpa in public practice in terms of excel usage or high level thinking tbh
    - bardworx 4y ago
      That makes sense. Everyone leaves, they have no partners and it’s all run by college grads? Just thinking through the premise of: Big4 folks arent capable of high level thinking that’s why they leave for “greener pastures”, implies that the “greener pasture” employees are less competent than the Big4. Otherwise, why would they hire folks from Big4?
  - magnio 4y ago
    My relative works at KPMG and it's fully Excel there.
    - Sateeshm 4y ago
      PwC uses g-suite
- deleted 4y ago
  [deleted]
- 4y ago
rr808 4y ago
Sacrilege
tanin 4y ago
My time to shine. SQL > Google Sheets, Excel for large data. Try https://superintendent.app https://superintendent.app
- ryanbrunner 4y ago
  SQL and excel are pretty different tools. When used as a database, SQL is far superior to Excel. When used for calculation, SQL isn't even particularly good: - Depending on which implementation you're using, it has a pretty anemic set of built-in functions. - Building calculations on top of other calculations is trivially easy in Excel and basically not available in SQL. - SQL forces you into a tabular mindset - Excel is often used that way but it's more freeform and you can have individual calculations that don't map to a particular schema. - Excel has much better UX in terms of visually representing what you're building as you build it, where SQL doesn't have any real interactivity in terms of building queries. Your product does look cool, but I think it's very much addressing specifically the "Excel / CSV as database" use case and less the analysis side.

Google Sheets > Excel

by hbarka 4y ago

Google Sheets > Excel

filmgirlcw 4y ago

I shouldn’t respond to this but…in what universe? Please share whatever drug you’re on with the class.

orange_fritter 4y ago
Apple Numbers for iOS has entered the chat
- filmgirlcw 4y ago
  I almost made a Numbers joke!
- HFguy 4y ago
  Nice...I would give you an award if I could.
t6jvcereio 4y ago
I bet you it's someone who used Excel for work, and whose entire analysis is something like "it's on the browser and it's easier to share documents".
makeitdouble 4y ago
Yes, that's a crazy thing to say without explaination. I think Excel will be unbeatable as an offline spreadsheet application for many years, if a competitor ever appears. Now, if what you're looking for is not offline spreadsheets, but a tabular interface that can be messed around in JS, with an API integration, Sheets is an excellent product that fills Excel's niche but in a connected system. disclaimer: I haven't touched much of office 365's online part, but am under the impression scripting with cloud services is not the direction MS is going for.
- samplatt 4y ago
  >scripting with cloud services is not the direction MS is going for. It absofuckinglutely is the direction they're going for. MS Flow, Teams and Sharepoint integration, upgrades to simultaneous-editing-documents-in-the-browser... the main problem is that they're trying to go too big too quickly which is causing hiccups especially from MS Teams, and also that anyone that doesn't use Excel seriously is already on Google Sheets with no real reason to migrate.
- Godel_unicode 4y ago
  Excel has had a JavaScript api since at least 2016. Excel online definitely has the ability to integrate with online services, although at that point you really want something like Power Automate. See also Microsoft Graph, which has an Excel API as well. Edit: https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0 https://docs.microsoft.com/en-us/graph/api/resources/excel?v...
  - foomz 4y ago
- filmgirlcw 4y ago
  Totally agree that Sheets is better as a quick and dirty web-based spreadsheet app. I’d still prefer something like Airtable for most of the use cases you outlined, but Sheets is absolutely a good quick and dirty tool. But once you go beyond that, all, as we’re both saying, it’s not even a conversation. And anyone who is trying to argue against Excel on its merits as a power app (no pun intended) is on something or not arguing in good faith. (O365 has improved a lot but I still think GSuite feels faster. But I don’t hate Office Online or whatever it is called.)

system2 4y ago

For sharing and viewing, yes. For anything else including speed, macros, options, keyboard shortcuts, MS Excel kills anything. Google is for convenience, I wouldn't even consider it a professional software at its current level.

quartesixte 4y ago

No professional organization that depends on Excel to make things with real consequences should be using Google Sheets.

bardworx 4y ago
Large audit firms (Big4) use google sheets and they do some real crazy/awesome stuff. Why are you poo-pooing on the tech? Edit: They also use Excel, btw. It’s just the right tool for the right job.
- emeril 4y ago
  haha, maybe Big 4 does, but, generally speaking, the best employees of Big 4 leave for greener pastures as soon as possible I've never seen anything remotely impressive from a cpa in public practice in terms of excel usage or high level thinking tbh
  - bardworx 4y ago
    That makes sense. Everyone leaves, they have no partners and it’s all run by college grads? Just thinking through the premise of: Big4 folks arent capable of high level thinking that’s why they leave for “greener pastures”, implies that the “greener pasture” employees are less competent than the Big4. Otherwise, why would they hire folks from Big4?
- magnio 4y ago
  My relative works at KPMG and it's fully Excel there.
  - Sateeshm 4y ago
    PwC uses g-suite
deleted 4y ago
[deleted]
4y ago

rr808 4y ago

Sacrilege

tanin 4y ago

My time to shine. SQL > Google Sheets, Excel for large data. Try https://superintendent.app https://superintendent.app

ryanbrunner 4y ago
SQL and excel are pretty different tools. When used as a database, SQL is far superior to Excel. When used for calculation, SQL isn't even particularly good: - Depending on which implementation you're using, it has a pretty anemic set of built-in functions. - Building calculations on top of other calculations is trivially easy in Excel and basically not available in SQL. - SQL forces you into a tabular mindset - Excel is often used that way but it's more freeform and you can have individual calculations that don't map to a particular schema. - Excel has much better UX in terms of visually representing what you're building as you build it, where SQL doesn't have any real interactivity in terms of building queries. Your product does look cool, but I think it's very much addressing specifically the "Excel / CSV as database" use case and less the analysis side.