Working with data isn’t always easy. It can be laborious, frustrating and downright infuriating at times. But, there’s no better feeling than when you absolutely nail that visualization or find that perfect nugget of information that makes everything come together.
To help you get that nailed it feeling, we’ve picked 10 awesome Google Sheets add-ons that will make working with data an absolute treat.
We’ve all been there, you have 10 sheets with data from the same website and you need to find what’s changed. Merge sheets to the rescue! Merge sheets lets you scan two sheets for the same values based on key columns and update your main table with the missing information. It’s a great tool for whenever you need to compare two sheets and bring the latest changes to your table.
You know those annoying people who still insist on using Excel instead of GS? Well with Data Everywhere you can still collaborate with them. Data Everywhere can connect very different systems together through a data feed. Their data feed is composed of rows and columns of data, the formatting associated with the data, the people who may access the data, and the full history of changes to the data. Meaning you can connect and collaborate on anything from Google Sheets, Excel, Google Forms, Salesforce, and any database.
This nifty little add on lets you plot your data onto a Google Map directly from GS. You can easily plot as many locations as you can fit in a 10 MB (a limitation of Google App Scripts). This means you can create a giant map with all your contacts or easily plot out a vacation plan. Really, you can plot out pretty much any data you want and it only takes a couple of seconds.
Find fuzzy matches
When simply remove duplicates isn’t enough, you need Find Fuzzy Matches. This super handy add-on helps you find duplicate entries which have slight name variations. This tool is really handy when you want to find or delete duplicates whose names are slightly different (ex: Michael – Micael – Michel).
This awesome add-on allows you to leverage R and Python machine-learning models for predictive analytics. You can deploy your models to the cloud and then make predictions using spreadsheet data inputs. Check out the video above to see it in action.
If working with web data is your thing, you need this plugin. Right now! Blockspring has a whole host of integrations that let you pull in live data from all over the web. Using it is as simple as writing a quick function, saving you hours of manual, error-prone exports and copy/paste. With Blockspring you can get fresh data from any source whenever your spreadsheet recalculates.
Sentiment analysis is all the rage these days, and now you can do it straight from GS. The Text Analysis add-on provides an easy way to analyze any text (links, tweets or documents) all without ever leaving Google Spreadsheets. It’s built on a package of Natural Language Processing and Artificial Intelligence tools that provide pretty sophisticated Text Analysis capabilities. Whether you’re a savvy marketer, or a seasoned data junkie, this add on allows you to analyze text with no programming or Text Analysis expertise in a matter of minutes.
Translate my sheet
This one’s pretty self explanatory. This simple Google Add-on allows you to translate your spreadsheet in more of 100 languages, either cell by cell or fully in one click. As you can imagine it’s based on the Google Translate API, meaning it’s got a good degree of accuracy. Plus the code is open source on Github so if you find something you don’t like, you can contribute to it directly.
We all know spreadsheets can be super powerful, but did you know you can use them to create apps? AppSheet is the fastest way to create mobile apps from within your Google Sheets. It is easy, free, and (best of all) there is no coding involved. You can even deploy your apps in minutes by sharing the install link available in the App/Editor. No need for App Store approval!
Our favorite machine learning tool now has a Google Sheets add-on! The guys at BigML have built an add-on which provides an easy access to the models and clusters under your account in BigML within GS. Using them, the blank cells in your datasheet can be filled with the predictions that the model can extract from the known values in each data row.
Sheetgo develops a Google Sheets add-on to connect Google Sheets with Excel or CSV file. Upon connection, choose from a variety of features to import or export data between multiple spreadsheets and create simple yet powerful spreadsheet-based systems.