Excel Vs Google Sheets - Is Google Sheets Better than Excel for Data Collection?

Excel and Google Sheets are completely different tools. Here's why you want to learn how to use both...

Excel contains no code data prep and blending tools taken from Power BI and SQL server.

Want to learn to use Excel like a pro?

In this training, you'll learn how you can implement an automated Excel dashboard in minutes along with a downloadable workbook that you can re-use for your own work.

Google Sheets is the best tool for collaboration, data collection or quick centralised database.

I'm looking to create some training on combining google sheets with R to build quick database applications.

Let me know in the comments below if you'd like to learn more about google sheets

Businesses everywhere use Excel because it's agile. Even though automation allows to save hundreds of hours Excel steps in whenever you need the job done today and not at the end of a 3 month IT project.

All of that is now changing with new tools. R and Python are not just for data science. With the right training deeper analysis, automation and apps can be built in the same time it takes to develop Excel spreadsheets.

For some examples along with downloadable code please see the free training at

Other content you might find helpful
Combine Excel Files Fast using R Tidyverse

Data Science Without Code?

Build a Dashboard in 10 Seconds with R Shiny Flexdashboard

R vs Python for Data Science, Data Analytics, Machine Learning Building Apps, Moving to Production

Easy Excel Dashboard with Power Query no VBA or Formulas

Linking to Data with Power Query Excel 2016 (Get & Transform) - Part 1

Better Than Vlookup. How to Merge or Join Data w/ Power Query Excel 2016 (Get & Transform) - Part 2

[zeppelinqaz]

Finally someone who understands the issues.

[nathanieldeacon]

I've found excel fine for collaboration by saving it to a Sharepoint site and sharing the link. Sometimes some syncing issues with large files (40K+ rows) with multiple formulas, but generally works really well.

[genysisonline]

Hi there: great analysis there. I consider myself an advanced-level user of both platforms and I definitely agree with your points. Excel is great but for collaboration, its still far from catching up with Google Sheets. The Online version of excel is very limited interms of features...

[dnghn.design]

Sheets is easier to use, Easier to share with other coworkers, can do it on multuple devices easily

[annielin]

I have a question, if I download a google and use excel to create pivot table can I upload it back to google sheet?

[williamb]

does google sheets have something like vba

[abcfedas]

simple task: sheet or excel




heavy tasks: EXCEL

[pablofernandez]

Hey mate, great video and explanation!


I have a case and mabye you can help me to realize if Gsheets can be helpful.
I work in supply chain and basicaly I need to create a schedule for every supplier that needs to deliver to my door. I have limited resources to unload trucks, so I want them to book a request for arrive and download their load.
After my approval and time slot assigned, they can come.


What are your thoughts? Google Sheets it's strong enough to look at it for this?


Thanks in advanced!!!

[Funintherain]

You forgot to mention Microsoft forms.