Subscribe to DSC Newsletter

Google Spreadsheet Add Ons for Data Analysis

Google spreadsheets are rapidly replacing excel for some types of data analysis. Here are some useful Google spreadsheet add ons for data analysis.

BLOCKSPRING

Blockspring helps people scrape websites, get product prices from Amazon, search Bing, save files to Dropbox, automate Twitter and outbound emails, find sales leads, run advanced text analysis, and much, much more.  It turns Google Sheets into a playground for APIs. Irrespective of the technical background, add-on enables one to automate work and build advanced tools.

Text Analysis

The Text Analysis add-on provides an easy way to analyze any text  as in links, tweets or documents in Google Spreadsheets. It provides various Natural Language Processing and Machine Learning tools.

The addon can be used to perform various tasks like

Sentiment analysis on Social Media streams

Extract mentions of entities and concepts
Summarize long chunks of text and articles

Detect the language of a document or tweet
Classify your documents or links into more than 500 categories
Extract the full text of an article, as well as its author name, embedded media etc

Text Mining

With this add-on one can analyze any kind of text and perform different types of Text Analysis and perform sentiment analysis on content in different languages.
It supports several languages like Italian, English, French, German and Portuguese.
The add-on helps enhance columns of text by automatically extracting keywords and named entities and linking them to Wikipedia.

Translate My Sheet

Translate my sheet add-on  helps translate your spreadsheet cell by cell or fully in one click in to  more than 100 languages.


Remove Duplicates

The Add-on helps in finding duplicate or unique values between two tables or in one sheet in 5 simple steps.

Power Tools

This Add-on provides one-click solutions for daily tasks like splitting cells, removing duplicates, changing case, finding and cleaning up data, working with formulae & more. Power Tools add-on cuts the clicks on repeated  tasks and brings features for  organizing and unifying data in Google Sheets.

Smart Autofill

Smart Autofill add-on uses Machine Learning via the Google Prediction API to fill missing values in a column of data, based on other data in the column and the data in adjacent columns.
It will look for patterns in the rows of data where there are values present in the column, and apply them to fill in the missing values of the column.

Mapping Sheets

The Add-on helps in plotting your own data onto a Google Map directly from Google Sheets.

Google Analytics

The Google Analytics spreadsheet add-on brings you the power of the Google Analytics API to Google Spreadsheets. With this tool, you can:
- Query data from multiple views (profiles).
- Create custom calculations from your report data.
- Create dashboards with embedded data visualizations.
- Schedule reports to run automatically so your data is always current.
- Easily control who can see these data and visualizations by leveraging Google Spreadsheet’s existing sharing and privacy features.

Find Fuzzy Matches

This add-on is a great assistant for correcting all fuzzy matches and removing partial duplicates from your sheet.

The list is compiled by Patnab.

Views: 13453

Comment

You need to be a member of Data Science Central to add comments!

Join Data Science Central

Comment by Krishna Bhat on December 6, 2016 at 10:00pm

Hi Kelum,

Please see my comment before yours. You can installKloudio as a Google sheets add-on and connect to MySQL, PostgreSQL etc seamlessly for both downloads and uploads. Basic features are free for all. Feel free to reach out to us at [email protected] in case of any questions. 

Thanks

Krishna

Comment by Kelum Perera on December 6, 2016 at 4:16pm

Any free add-in to connect to databases such as MySQL, PostgreSQL...etc. from google sheets ?

Thanks for the useful info.

Comment by Krishna Bhat on October 16, 2016 at 8:04am

Also, if you want to connect to databases such as MySQL, Oracle, PostgreSQL and AWS Redshift from Google sheets for both downloads and uploads, you can use Kloudio. Check out the Google Sheets add-in here. Even enterprises such as Netflix are saving thousands of data engineering and data science efforts by using the self-service business intelligence capabilities of Kloudio.

Comment by Scott Nestler on February 18, 2016 at 5:12pm

Hear are links to information on couple of other useful add-ons for quantitative analysis in Google Sheets.  All of them are available the Chrome Web Store.

Solver, for optimization, from Frontline Systems.  http://www.solver.com/advanced-analytics-web-frontline-systems-solv...

Risk Solver, for Monte Carlo Simulation, from Frontline Systems. http://www.solver.com/advanced-analytics-web-frontline-systems-new-...

XLMiner, for statistical analysis and data mining, from Frontline Systems. http://www.solver.com/xlminer-analysis-toolpak-brings-popular-stati...

Comment by Marie Susan Lee on February 18, 2016 at 3:01am

Thanks for the useful list.

Videos

  • Add Videos
  • View All

© 2019   Data Science Central ®   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service