Google Sheets makes it easy getting data from anything in your tech stack into an analysis software like Tableau
Rating: 8 out of 10
IncentivizedUse Cases and Deployment Scope
We use Google sheets to track and update projects in real time by multiple people in various locations. We also use it as a bridge between other applications and Tableau via Zapier.
Pros
- Easier than Excel to create formulas and conditional formats, etc
- Integrates with almost anything so can be easily used as a workaround to link two programs that aren't integrated with each other
- Makes sharing work and updates very seamless
Cons
- Would love to see better AI that takes more of the guesswork out of formulas, especially for newer users
- Sometimes there are glitches with the horizontal scrollbar
Likelihood to Recommend
Google Sheets is suitable for just about every standard Excel task (though I haven't tried to use it for visual analysis or pivot tables). It is particularly strong as the middleman connection point between programs via Zapier. It's extremely useful for sharing and updating information among multiple, geographically dispersed coworkers.