Doctopusĭoctopus was designed with teachers in mind which is why it comes with a handy feature. It’s the same add-in that you loved and used in Excel.ĭownload XLMiner: Google Sheets 4. XLMiner is a must-have for those who like to manage or manipulate data around to arrive at meaningful conclusions. Some of them are covariance, ANOVA, correlation, histogram, moving average, exponential smoothing, sampling, and more. XLMiner is one of the best Google Sheets add-ons that offers 19 Excel features that you were missing in Google Sheets. What are Google Sheets without a way to analyze all the data collected statistically? Nothing. None of this data will be uploaded anywhere.ĭownload Email Address Extractor: Google Sheets 3. The free version will work until 250 email IDs have been extracted.
You can choose to save email IDs from To, From, CC, BCC, and even body field. Email Address Extractor Google Sheets add-on will collect all email IDs based on your criteria and save them in a sheet. Email Address ExtractorĬhances are that you are also using Gmail and/or Gsuite to send and receive emails. There is an annual subscription that unlocks more tools.ĭownload Power Tools: Google Sheets 2. Power Tools is a powerful suite of add-ons for Google Sheets that need to have whether you are a regular or a pro user of the Google Sheets. Power Tools will remove duplicates, find vlookups, merge or split cells, import data from other sheets, find and replace data in cells including formulas, compare data, add text or capitalize it, clear cell data by type and so much more. Let’s begin with an add-on that bundles a number of tools to help you be more productive.
#BEST ADD ONS FOR EXCEL HOW TO#
Also Read: How to Combine Cells in Google Sheets Google Sheets Add-ons 1.