Google Sheets
Free Online Spreadsheets for Personal Use
Start new thread

Sheets by Google - Excel powered with automation and collaboration features.

by•

Hey Hunters!!!

Google launched major update for Google Sheets with the addition of "Macro" feature. It will not only increase productivity of teams using G Suite but it will also enhance the automation in the Google Sheets.

For those who are not using Google Sheets here are the features offered by Google Sheets:

1. Sharing for enhanced collaboration

2. Chat during editing

3. Data import from variety of sources like XML, HTML, RSS and CSV

4. Connect with housands of online apps using tools like Zapier for automation

5. Data visualization tools

6. Work anywhere, anytime

Add a comment

Replies

Best
MACROS!
What are the pros of using Excel over Google Sheets at this point? I'm failing to see many.
I guess if your Infosec doesn't allow for "unsecured confidential online data"??? There really aren't that many.
Interesting, curious what you mean by that?
Well, I worked at a company last year whose Info. & Security department did not allow Google Sheets to be used organization-wide. They claimed it wasn't secure enough for our confidential data to be uploaded on there.
That's interesting. Just researched a bit. It seems like it has to do with how data at rest is secured in each system. Additionally, it appears Excel has more failsafe options using multi-sheet encryption.
Speed. Only thing I ever really run to Excel for is spreadsheets with 400k+ rows. 😅 I also use Numbers from time to time because of the nice charting defaults and mobile friendly UI
excel google really liked for the possibility of working with tables on the Internet.
So, macros are called automation here?
As someone who has been making Google Apps scripts the hard way for repeating processes, the new macros feature will be a game changer!
Anyone know if this will work for the free version of Google Sheets?
This will be fun to use!!!! Yipee!!
Looks absolutely very promising!

Great for medium size data and easily connects to other plug-in such as Coefficient and Looker, for large data set Excel is still the go to.

 the new experimental canvas feature integration with sheets is pretty useful but i can't seem to find literally anybody talking about it's capabilities/limitations. have you tried it with a medium sized dataset?

Switched from Excel to Google Sheets recently and my muscle memory is crying. 😤 The shortcuts are so different and it feels so clunky. Anyone else feel the frustration? How do you all deal with this?