Google
spreadsheets are rapidly replacing excel for some types of data
analysis. Here are some useful Google spreadsheet add ons for data
analysis.
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.
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
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
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
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.
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 add-on helps translate your spreadsheet cell by cell or fully in one click in to more than 100 languages.
The Add-on helps in finding duplicate or unique values between two tables or in one sheet in 5 simple steps.
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 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.
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.
The Add-on helps in plotting your own data onto a Google Map directly from Google Sheets.
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.
This add-on is a great assistant for correcting all fuzzy matches and removing partial duplicates from your sheet.- 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.
No comments:
Post a Comment