Google Sheets vs MS Excel - What to choose in 2020 ?

By Adel Chemi

Google Sheets and MS Excel are the most popular for data visualization and analysis tools in the market. So if you are asking which one fits better for task here's some points :


- Performance and big data :

MS Excel wins this easily because its use your desktop and it has better performance then limited Google sheets cloud :

  • Using formulas for big rows in Google sheets make your browser to consume too much ram and will crash.
  • MS Excel VBA forms and scripts are much faster because its run your script immediately without checking authentication and quotas each time you run script
  • MS Excel better in BIG data importing, If you have some big data and you import it to G Sheets it may cause your chrome crashing
  • Google sheets is limited :
    • 400,000 cells
    • maximum of 256 columns per sheet. 
    • Uploaded spreadsheet files that are converted to Google spreadsheets format can't be larger than 20MB, and need to be under 400,000 cells and 256 columns per sheet.
  • Something bad in Excel when some big data calculation crashes it won't save or make copy properly in older version (2013 and below)

- Sharing and collaborating :


Google sheets has the best online collaboration and real time editing and chatting in same time
that make your work much easier do same thing including tablet and phone.

  • You can access to your files wherever you are without needs to install it.
  • Create HTML Embed for your website
  • More control for sharing access.
  • Better UI for collaborating
  • Available in tablets and phones

- Developers friendly :


Google Apps script use Javascript and it's the most popular programming language now time with chrome V8 is much better then the VBA that it's old and has less sources and solutions for the current problems, With apps script cloud hosted you can :
  • Trigger and run script by time driven
  • Web app that can show your G Sheets data
  • Web app for webhook calls
  • Connect to public APIs. You can use the Url Fetch service to make API requests directly.
  • More friendly with JSON

- Resources


Google sheets has many add-ons and big support for external APIs
  • Google sheets has more Add-ons
  • Zapier® connects Google Sheets to 2,000+ apps with absolutely no code required. Zapier®

Comments

Post a Comment

Popular posts from this blog

Email a Custom Sheets as PDF in Attachment

By Adel Chemi
Image
Script export and send email of custom sheet on PDF in Attachment for Google Sheets with GAS (Google Apps Script) & Javascript Language, don't forget to change the variables according to your goal, read tips and watch video to understand more about how to run it even you are not a programmer
Read more

Export and Email Specific Range in Google Sheets in CSV,PDF or XLSX

By Adel Chemi
Image
Script for Exporting a specific Range from spreadsheet and save it in drive or email it in attachment in CSV, PDF or XLSX . If you want to export just specific sheets in the spreadsheet just check this  Tutorial  . How to use it : In Spreadsheet Menu Click Tools and select Script Editor from spinner to go put your script, in Excel "Visual Basic" on developer mode. 1- Open Google Apps Script file or create new one : File > New > Script File and name it with whatever you want . 2- Past the script in the bottom of Article and Save the Script . What necessary to change : Line 5 : Range you want to export it. Line 6: Sheet who has that range . LINE 59 : Email Receiver, if you want to email a multiple emails just make comma between each email address e.g : 'pace3man@gmail.com ,spider-max@live.fr,......'  . LINE 60 : replace Title word with whatever. LINE 61 : The body of Email. LINE 64 : The Attachment file name.
Read more