While Google Sheets was originally see as a Microsoft Excel replacement , it terminate up being something more than that . Indie developer took reward of the loose API to build a identification number of Google Sheets MBD - ons that heighten its functionality in a number of ways . While there are hundreds of add - ons for Google Sheets and covering all of them is unacceptable , I do have a list of some of the adept Google Sheet minimal brain damage - ons for you to check out .
allow ’s start .
Also Read : How to Combine Cells in Google Sheets
Table of subject matter
Google Sheets Add-ons
1. Power Tools
have ’s set about with an add - on that bundles a number of tools to help you be more productive . Power Tools will remove duplicates , find vlookups , merge or stock split cells , import information from other sheets , feel and replace datum in cell including formulas , equate data , add text or capitalize it , cleared cellphone data point by type and so much more .
exponent Tools is a powerful suite of add - ons for Google Sheets that take to have whether you are a unconstipated or a pro user of the Google Sheets . Useful for insistent labor . There is an annual subscription that unlocks more tools .
Download Power Tools : Google sheet
2. Email Address Extractor
Chances are that you are also using Gmail and/or Gsuite to send and welcome emails . Email Address Extractor Google Sheets add - on will collect all email IDs based on your criteria and economise them in a sheet of paper . you’re able to choose to relieve email IDs from To , From , CC , BCC , and even body field .
The loose version will bring until 250 email IDs have been extracted . None of this data will be uploaded anywhere .
Download Email Address Extractor : Google Sheets
3. XLMiner
What are Google Sheets without a way to analyze all the datum collect statistically ? Nothing . XLMiner is one of the unspoiled Google Sheets add - ons that offers 19 Excel feature that you were missing in Google Sheets . Some of them are covariance , ANOVA , correlation , histogram , moving average , exponential smoothing , sampling , and more .
XLMiner is a must - have for those who care to manage or pull wires information around to get in at meaningful conclusions . It ’s the same add - in that you loved and used in Excel .
Download XLMiner : Google Sheets
4. Doctopus
Doctopus was designed with teachers in mind which is why it come with a handy feature . you’re able to now handout specific documents in Google Drive to one or more specific scholar . Once a doc has been divvy up , you could go after progress , comment , and overturn permissions as you deem fit .
design by a skill teacher , Doctopus allows you to follow the workflow to the T , allowing you to manage , track , assess , and record tasks remotely .
Download Doctopus : Google tabloid
5. Google Analytics
Google Analytics is how you understand and crunch all the site data . Google Analytics for Google Sheets tot up - on will allow you to further manipulate these metric unit to arrive at better conclusion . you’re able to also use this add - on to recover data point and take regular backups of your site data .
Once information has been queried and cells have been dwell , you may separate or filter this data by CTC , clicks , impressions , positioning , and so on . Go on , judge it now .
Download Google Analytics : Google Sheets
6. Template Gallery for Sheets
As the name paint a picture , this Google Sheets add - on is a gallery of templates that you could use based on the eccentric of data point you are working with . Some exemplar admit invoice , calendars , timesheets , occupation workplace , letter , resumes , and so on .
What ’s coolheaded is that the same ADHD - on will also form with Google Docs and tender a ton of templet for that too . A must - have Google Sheets add - ons if you are a Google Sheets and Docs user .
Download Template Gallery for sheet : Google sheet
Also Read : How to simulate Files and Folders in Google Drive
7. Autocrat
Autocrat come with a number of guide that you could use to merge data point from spreadsheets into a document . That fix it easy to share these papers with relevant datum from Google Sheets using Autocrat hyperkinetic syndrome - on . Autocrat can manage a large bit of documents and sire them automatically .
Templates also include the power to use Slides . you may also generate PDF files if need be . Selecting cells ie easy and the interface has been made elementary .
Download Autocrat : Google sheet
8. Flubaroo
Flubaroo was developed for teachers who want to grade students based on answers to multiple - choice question and forms . It is a Google Sheets bring - on as much as a Google Form one . Grade students , give them score and feedback , help oneself them get better and improve , identify patterns in questions that were answered or not the most , and so much more .
Once you are done , it ’s well-heeled to share the results via email or cloud using other Google apps like Drive and Gmail . you could automatize the scoring and grading process by entering the correct solvent that delay hidden until the quiz is complete .
Download Flubaroo : Google bed sheet
9. Lucidchart Diagrams
Lucidchart is plausibly the most brawny Google Sheets add - ons there is when it follow to make charts , diagram , mockups , ERDs , and more . you could create reasonably much any type of chart with this add - on and then collaborate with your equal in real - clock time .
It comes with initiative - floor security measures with encryption and lockdown features . It ’s a ocular collaboration prick to makes sense of data point , all packed into an easy - to - use UI . Lucidchart integrate with a numeral of third - political party apps , so you may export data point easily .
Download Lucidchart Diagrams : Google Sheets
10. Yet Another Mail Merger Support
A peck of brand use Google Sheets to keep a database of important e - mail tangency . Whether it ’s dispatching news - letters or frequent communication with node , sending bulk tocopherol - mail service can be wearisome and to tackle that , you could habituate YAMM living and direct with a single click . Here ’s how you do it .
launch the canvass consisting of e - mails you desire to use . Click onadd - onsfrom the toolbar and chooseYet Another Mail Mergeand click onStart Mail Merge . Then you just need to fill in the sender ’s name and choose from a diverseness of templates that are editable in Gmail or you’re able to pick out a star e - ring mail from your drafts . In improver to that , it also track if the receiver has open up the e - post or not . Most organizations also produce interactional send - out , withYAMM , you could create interactive polls as well . Using this overhaul as a first time user can be a bite perplexing , so there is an option to encounter trial e - mail that can be reviewed and change . You also get a side toolbar where you’re able to overview the tracking report .
Get YAMM Support .
11. Random Generator
You give out usance passwords to new employee and to manually think of so many parole is not only a chore but absolutely necessary . With add - ons likeRandom Generator , you’re able to generate any number of random string in a irregular .
To start , chooseRandom Generatorfrom the add - on section . Then you ’d need to typeset a series of parameters to generate a string like lower limit and maximal values , length , etc . Moreover , you may also generate other matter at random , like days , date , months , real numbers and even integer . In the same sidebar , you’re able to mother a strong password within the bowed stringed instrument section . After you decide what do you want to generate at random , set the parameters and flick generate . If you need to generate more data at random , you have the option to choose multiple cellular telephone as well .
It currently has a60 day trial periodbut you’re able to get aone - class subscription at $ 9.99andlifetime access code at $ 39.95 .
Get Random Generator
12. Change Case
I do n’t always pay attention to names when I ’m work on Google sheets . I write some in upper case and some in low . fault my laziness or my working manner . If you ’re in the same gravy boat as I am , I have a way to plow this laziness into productiveness with a simple-minded add - on calledChange guinea pig .
You select one prison cell or more cells that you ’ve to exchange . Then go to the minimal brain dysfunction on and choose between the options you desire to apply . you may change all character to scurvy case , make the first missive cap , invert each part , change sentence case or title of respect case capitalization .
Note : It supports only click and drag options to take cells . So you ca n’t press Ctrl and choose individual cells .
Get Change Case
13. Calendar to Sheet
Google Calenders is an indispensable part of our lives . From birthday ’s to public holiday , it aid up to track everything . While Google calendar is a peachy pick to catch upcoming events , you’re able to also match it withSheetsto view them as an organise tilt .
spread the attention deficit hyperactivity disorder on and selectUndefined . Now a dialog box soda water undefendable where you involve to arrange theimport settingfrom Google Calendar . If you ’ve dates saved across multiple calendars take the first choice or opt a specific calendar . You have the option to give a custom name to the sheet and also put a specific word by which upshot in the calendar will be filtered . The next whole tone is to select a time period between which you want to import the events . Although the import data format calculate on the data it is access , if it ’s large and complicated , chances are you ’d line up a haphazard theatrical performance of your event .
In my casing , I spell birthday and public holidays which were segregated by start appointment , oddment date , description , and position . It also bear witness the period filtered , east - mail relate to the significance and calendar detail . It ’s a great tool if you have a pile of events in your calendar that you want inGoogle Sheetsformat .
Get Calendar to Sheet
14. Mapping Sheets
Are you heading out for a calendar month - long trip or have a Google Sheet filled with in the buff - fabric suppliers ? . You might spend 60 minutes wasting time to occupy in everything in Google Maps or manually prefer to navigate one fix at a clock time . Whichever elbow room you choose , it ’s metre - exhaust , but do n’t care I have your back . It ’s easy to map multiple fix with Mapping Sheets mechanically .
Access it from the add on section and chooseStart Mapping . Remember to keep all your datum in three columns , the title , filer an location . After putting all the inside information flick onBuildwhich will save a.jsonfile in yourDrive . Then click onViewwill meet all the locations and show them on the map .
There is no use of mapping the name and address until you share them . The sharing option is in the top veracious corner of theadd - on dialog box . you may either share the single-valued function with a link or get through on the share clit to send theGoogle Drivefile .
The introductory add - on pop the question up to 50 locations but you may get unlimited access at$25 each year .
Get Mapping Sheets
