Useful Add-ons
Hi [accessally_user_firstname],
An ‘add-on’ is a little snippet of code that run inside Google Documents, Sheets or Forms. They add functionality in order to perform a certain task. There is a huge (and growing) variety of Add-ons to choose from that perform all sorts of useful functions.
This list has been carefully curated using the following categories:
- The type of Google document it is used in: Documents, Sheets, or Forms.
- The audience it is intended for: Office Staff, ICT Leaders, School Leaders, Class Teachers
- A quick description.
- Alternatively, you can search for something which will filter the entire list.
Add ons have to be installed and activated before they can work. You can find these useful tools inside the ‘Add Ons Store’ from inside a Doc, Sheet or Form.
To learn more watch this movie or check this presentation on learningarchitects.com
Clicking any of these icons will launch that item in the Chrome web store for you – make sure you read the description of what it does before installing it.
| Img | Title | Description | ||||||
|---|---|---|---|---|---|---|---|---|
| CategoryFilter | csvFilter | csvFilter | CardsContent | StringFilter | ||||
| https://sites.google.com/a/revevol.eu/images-base/ADD-REMINDERS-LOGOS-440x280.png | Add Reminders | Set up and organize email reminders from a Spreadsheet | https://sites.google.com/site/scriptsexamples/available-web-apps/add-reminders-to-spreadsheet | Sheets | Office Staff, School Leaders | Easy calendar reminders | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Add-Rows-and-Columns.png | Add Rows and Columns | Adds multiple rows and columns to your spreadsheet quickly. | https://chrome.google.com/webstore/detail/add-rows-columns/bepdpnejbnandmmikaedhbmphflnbnmn?utm_source=permalink | Sheets | Office Staff, School Leaders, ICT Leaders | Managing spreadsheets easily | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Advanced-Find-and-Replace.png | Advanced Find and Replace | Search in values, formulas, notes, hyperlinks in all sheets at once. | https://chrome.google.com/webstore/detail/advanced-find-and-replace/gdjlbafkoaciknlpkmiedbgnlfglcpmb?utm_source=permalink | Sheets | Office Staff, School Leaders | Quickly finding and replacing data in Sheets. | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Autocrat.png | Autocrat | Mail merge in the cloud. Quite powerful and a little more advanced. | https://chrome.google.com/webstore/detail/autocrat/ppgnklghfnlijoafjjkpoakpjjpdkgdj?utm_source=permalink | Sheets | Office Staff, School Leaders | Mail merge. | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Blockspring-for-Google-Sheets.png | Blockspring for Google Sheets | VERY powerful tool for pulling data from the web and much, much more. | https://chrome.google.com/webstore/detail/blockspring/aihldeahgcpbpmimkdpkafaedhbmfhoh?utm_source=permalink | Sheets | Office Staff, School Leaders, ICT Leaders | Managing data import into Sheets. | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Bulk-Sheet-Manager.png | Bulk Sheet Manager | Allows you to delete, protect and lock sheets in one go. | https://chrome.google.com/webstore/detail/bulk-sheet-manager/ncifcaeanmakefjdnkaiddkiecokhoka?utm_source=permalink | Sheets | Office Staff, School Leaders, ICT Leaders | Locking Sheets | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Calendar-Event-Importer.png | Calendar Event Importer | Imports data from one or more Google Calendars into Sheets. | https://chrome.google.com/webstore/detail/calendar-event-importer/ffkehpeilnhbpobkeojanjohnocolbhi?utm_source=permalink | Sheets | Office Staff, School Leaders | Importing calendar data into Sheets. | ||
| https://members.learningarchitects.com/wp-content/uploads/2016/11/Change-Case.png | Change Case | Make changes to the case of text in block selections: uppercase, lowercase, first letter capitals, invert, sentence and title case. | https://chrome.google.com/webstore/detail/change-case/ahpcjlihommmjokggmgpinfpflphlall?utm_source=permalink | Docs | Office Staff, School Leaders, ICT Leaders, Teachers, Students | Formatting text | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Choice-Eliminator.png | ChoiceEliminator | Similar to FormLimiter - great for signing up for time slots or having students choose topics without doubling up. | https://chrome.google.com/webstore/detail/choice-eliminator-2/mnhoinjhhhafgieggnhjekliaodnkigj | Forms | Office Staff, School Leaders | Managing workshops | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Crop-Sheet.png | Crop Sheet | Allows you to instantly crop the sheet to the data, or the selected region. | https://chrome.google.com/webstore/detail/crop-sheet/aojcceglbipehndciapjedoomockgagl?utm_source=permalink | Sheets | Office Staff, School Leaders | Crop your Sheets by getting rid of unwanted rows or columns | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Data-Everywhere.png | Data Everywhere | Very interesting tool which allows you to connect an Excel spreadsheet to a Google Sheet, so that if you edit either - it synchronises! | https://www.dataeverywhere.com/ | Sheets | Office Staff, School Leaders | Synchronising Excel files with Google Sheets. | ||
| https://members.learningarchitects.com/wp-content/uploads/2016/11/Doc-Tools.png | Doc Tools | A set of single-click tools to change case, highlight text, sort tables and lists, change numbers to text, and more. Big time saver! | https://chrome.google.com/webstore/detail/doc-tools/gjbhiglgnpikoggompgjflkoeacenbdo?utm_source=permalink | Docs | Office Staff, School Leaders, ICT Leaders, Teachers | Changing the case of text in Docs and many more features. | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Easy-Accents.png | Easy Accents | Allows writing in different languages, Māori macrons! Tumeke! | https://chrome.google.com/webstore/detail/easy-accents/njbfdnnpglelehliilonpfcbckcdhnid?utm_source=permalink | Docs | Office Staff, School Leaders | Writing using macrons and other symbols - awesome! | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Email-Notifications-for-Google-Forms.png | Email Notifications for Forms | Allows you to send customized email notifications to form respondents. | https://chrome.google.com/webstore/detail/email-notifications-for-f/acknfdkglemcidajjmehljifccmflhkm?utm_source=permalink | Forms | Office Staff, School Leaders | Notifying form respondents | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Email-Range.png | Email Range | Allows you to take a snippet from a spreadsheet and email it to someone. | https://chrome.google.com/webstore/detail/email-range/dolojkflgagmliddfokeajaohhbojgdm?utm_source=permalink | Sheets | Office Staff, School Leaders | Emailing a snippet from a Sheet to someone | ||
| https://sites.google.com/a/revevol.eu/images-base/EVENT-MANAGER-440x280-logo.png | Event Manager | The all-in-one add-on to manage registrations to multiple events | https://sites.google.com/site/scriptsexamples/available-web-apps/event-manager | Sheets | Office Staff, School Leaders | Managing registrations for events. | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Files-Cabinet-by-Awesome-Table.png | Files Cabinet by Awesome Table | Quickly list all the files of a Google Drive folder in a spreadsheet, and automatically display it in a table view. | https://chrome.google.com/webstore/detail/files-cabinet-by-awesome/obmjbphplaacknapcnebijpkmghknmdo?utm_source=permalink | Sheets | Office Staff, School Leaders | Displaying files inside a Drive folder easily | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Folder-Owner-Change.png | Folder Owner Change | Handy if you wish to change ownership of folders, subfolders and files en masse. | https://chrome.google.com/webstore/detail/folder-owner-change/lilnffknbkdpbeaaoolgedamdgljjjkk?utm_source=permalink | Admin Console | Office Staff, School Leaders, ICT Leaders | Changing ownership of folders en masse. | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Form-Limiter.png | FormLimiter | Shuts off a Google Form after a maximum number of responses, at a date and time, or when a spreadsheet cell equals a value. | https://chrome.google.com/webstore/detail/formlimiter/clflahnkjeannplpafofekagclpmijkl?utm_source=permalink | Forms | Office Staff, School Leaders, ICT Leaders, Teachers | Limiting sign ups in a Google Form | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/From-Sheets-to-Calendar.png | From Sheets to Calendar | Brilliant for creating mass events in a calendar. | https://chrome.google.com/webstore/detail/from-sheets-to-calendar/lebmclhgnlegneijebiigijaoheabfjh?utm_source=permalink | Sheets | Office Staff, School Leaders | Setting up calendar events en masse. | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Hellosign.png | HelloSign | Online permission slips (3 free). | https://chrome.google.com/webstore/detail/hellosign/bolpggiohbfjnlhnggkmfhighoijeekn?utm_source=permalink | Docs | Office Staff, School Leaders | Online signing of permission | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Mapping-Sheets.png | Mapping Sheets | Map address or GPS related data and places it onto a Google Map. | https://chrome.google.com/webstore/detail/mapping-sheets/ddfdjfkaipgeahdjeemdojbpcglcncif?utm_source=permalink | Sheets | Office Staff, School Leaders | Instantly mapping location of geographic data | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Merge-Values.png | Merge Values | Joins two values together (e.g first and last name). | https://chrome.google.com/webstore/detail/merge-values/lhikboagplgbemjnkgoahbphfgieaiek?utm_source=permalink | Sheets | Office Staff, School Leaders | Joining values in different columns together | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Power-Tools.png | Power Tools | Very handy add-on which does a whole range of quick clean-up type tasks in spreadsheets (eg. lower/upper case, split cells, text to columns, etc.). | https://chrome.google.com/webstore/detail/power-tools/dofhceeoedodcaheeoacmadcpegkjobi?utm_source=permalink | Sheets | Office Staff, School Leaders | Quickly cleaning up data in Sheets (lots of features) | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/ProjectSheet-Planning.png | ProjectSheet Planning | GANTT charts and project planning. | https://chrome.google.com/webstore/detail/projectsheet-planning/ejljeigigmpdnoohkmbpbgdgmgffjahc?utm_source=permalink | Sheets | Office Staff, School Leaders | Project management | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Remove-Duplicates.png | Remove Duplicates | Quickly find duplicates in one sheet or in two columns. Move, delete, or highlight the results. Has a number of useful tools. Make your Google Sheets duplicate-free in a flash. | https://chrome.google.com/webstore/detail/remove-duplicates/bckmhokpcdnhhjldhhfpebhdfipmlbog?utm_source=permalink | Sheets | Office Staff, School Leaders | Removing duplicates of data | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Secret-Santa.png | Secret Santa | Helps you organize a blind gift distribution among your family, your mates or even your work team. | https://chrome.google.com/webstore/detail/secret-santa/eoognkhkcdgmnhmlobgnehlpjmdcngkk?utm_source=permalink | Sheets | Office Staff, School Leaders | Organising a fun activity for the team | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Simply-Send-for-Forms.png | Simply Send for Forms | Allows you to send the form results to specified email addresses, with the option to merge with a template. | https://chrome.google.com/webstore/detail/simply-send/dfpmmnbflloldgmcbmpcgiklcckibeff?utm_source=permalink | Forms | Office Staff, School Leaders | Sending form results by email | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Split-Names.png | Split Names | Quickly split full names to several columns with first, middle, last names, titles, and/or post-nominal letters. | https://chrome.google.com/webstore/detail/split-names/omjobieogknhhlogiaeofbdpipihaanb?utm_source=permalink | Sheets | Office Staff, School Leaders | Splitting values in a Sheet cell | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Styles.png | Styles | Give some pre-set options which will appeal to some users. | https://chrome.google.com/webstore/detail/styles/nkhhmdlcfanccpjadngacgjgecfbheje?utm_source=permalink | Sheets | Office Staff, School Leaders | Quickly applying a style to a Sheet | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Sudoku-Sheets.png | Sudoku Sheets | Generates and helps you solve sudoku problems. | https://chrome.google.com/webstore/detail/sudoku-sheets/eagolleeideiojopioiiaadjkneafmen?utm_source=permalink | Sheets | Office Staff, School Leaders | Generating sudoku sheets | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Survey-Monkey.png | Survey Monkey | Allows you to view your Survey Monkey data in a spreadsheet! | https://chrome.google.com/webstore/detail/surveymonkey/caipcojfoolgojgbomkmeokjmfecahha?utm_source=permalink | Sheets | Office Staff, School Leaders | Viewing Survey Monkey data inside a Sheet | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Table-Styles-for-Google-Sheets.png | Table Styles for Google Sheets | Allows you to set up table styles for sheets. | https://chrome.google.com/webstore/detail/table-styles/miephfllckffagckloelhmnbefefbldl?utm_source=permalink | Sheets | Office Staff, School Leaders | Quickly applying a style to a Sheet | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/TimeSheet.png | TimeSheet | Uses your Google calendar as a timesheet. | https://chrome.google.com/webstore/detail/timesheet/nebngbhpfeiihkkpkgfignmdfikfpclb?utm_source=permalink | Sheets | Office Staff, School Leaders | Setting up a timesheet | ||
| http://members.learningarchitects.com/wp-content/uploads/2016/11/Yet-Another-Mail-Merge.png | Yet Another Mail Merge | Write your template as a draft in Gmail and insert {{markers}} to reuse data from your spreadsheet and send personalized emails. | https://chrome.google.com/webstore/detail/yet-another-mail-merge/mgmgmhkohaenhokbdnlpcljckbhpbmef?utm_source=permalink | Sheets | Office Staff, School Leaders | Mail merge. | ||
| https://members.learningarchitects.com/wp-content/uploads/2016/11/Email-Spreadsheet.png | Email Spreadsheet | Convert and email Google Spreadsheets as PDF, Excel or CSV to multiple people. | https://chrome.google.com/webstore/detail/email-spreadsheet/nmjdgbcladefaegbhmndjchmpbnhlcnp?utm_source=permalink | Sheets | Office Staff, School Leaders | Converting and emailing Google spreadsheets manually or on a recurring schedule. | ||
| https://members.learningarchitects.com/wp-content/uploads/2016/11/ezNotifications-for-Google-Drive.png | ezNotifications for Docs | Brilliant add-on for Docs which allows you to get notifications of changes to documents (or folders) that you specify. Totally brilliant. | https://chrome.google.com/webstore/detail/eznotifications-for-docs/niaenhdmffjodkpdmfkephmonnhibdcg?utm_source=permalink | Docs | Office Staff, School Leaders, ICT Leaders, Teachers, Students | Being notified of changes to files or folders. | ||
| https://members.learningarchitects.com/wp-content/uploads/2016/11/editLock-logo.png | editLock | editLock enables you to easily lock a cell or range of cells in a Google Sheet. This is a brilliant tool that gives you a lot more flexibility in how you protect information inside a Google Sheet. Watch the tutorial here | https://chrome.google.com/webstore/detail/editlock/dlhdmpipcbpjcafijmfenhmhmidjjfcc?authuser=0 | Sheets | Office Staff, School Leaders, ICT Leaders, Teachers | Protect cells immediately after they've been edited. Prevents users editing each other's cells in collaborative sheets. | ||
| https://members.learningarchitects.com/wp-content/uploads/2016/11/ezPanel.png | ezPanel | ezPanel allows you to manage your G Suite domain, 25+ tools and reports to speed up your admin daily work. Achieve most common google apps admin tasks right from Spreadsheet. No need to go on the admin console, just from spreadsheet you can create a users, move user to an OU, create reports to list all groups, all users of an OU, all resources, all Google Sites, etc... | https://chrome.google.com/webstore/detail/ezpanel/cpphofgdkmbpaoikahklekohndnlihfo | Admin Console | ICT Leaders | Managing G Suite administration tasks from a Google Sheet | ||
| https://members.learningarchitects.com/wp-content/uploads/2016/11/Chromebook-Inventory.png | Chromebook Inventory | This script is for super-admins, to be used on G Suite domains with Chrome Device Management Console licenses -- used to manage Chromebooks. This script allows you to both export and update your Chromebook inventory via a Google Sheet. It enables download and update of the metadata and Organisational Units of enrolled Chrome devices direct from a Google Sheet. | https://chrome.google.com/webstore/detail/chromebookinventory/iifofihmahmlokfnajjngehfnilmdmei?utm_source=permalink | Admin Console | ICT Leaders | Managing ChromeBooks using a Google Sheet. | ||
| https://members.learningarchitects.com/wp-content/uploads/2018/07/Show-Add-on-for-Docs.png | Show | Are you missing the ability to show invisibles in Google Docs? Not any more! | https://chrome.google.com/webstore/detail/show/cookfoficdecobaeegihlmciepcgpplm | Docs | Office Staff, School Leaders, ICT Leaders, Teachers, Students | Showing invisible characters in Google Docs | ||
| https://members.learningarchitects.com/wp-content/uploads/2018/08/Pear-Deck.png | Pear Deck | Amazing formative assessment tool for Google Slides. Turns your slideshows into interactive assessment tools! This add-on allows you to add the magic of formative assessments and interactive questions to your presentations right from Google Slides. Has a range of types of questions you can use: multi-choice, open-ended, drag/drop, tickbox and more! | https://chrome.google.com/webstore/detail/pear-deck/amfkiahebibbkifgdjdfplkjohlgfdgg?hl=en | Slides | ICT Leaders, Teachers, Students | Include formative assessment inside Slideshows! | ||
| https://members.learningarchitects.com/wp-content/uploads/2018/09/Form-Publisher-3.png | Form Publisher | Excellent tool for creating Docs, Sheets, Slides & PDF from form submissions. Even does approval workflows! Free version creates 100 files/month (http://bit.ly/2xmGHbH). | https://form-publisher.com/login | Forms | Office Staff, School Leaders, ICT Leaders, Teachers, Students | Create documents, PDF, Sheets & Slides from form submissions. | ||
| https://members.learningarchitects.com/wp-content/uploads/2018/11/FormRanger.jpg | Form Ranger | Flexible add-on which allows you to dynamically populate form question choices from a column in a Google Sheet. Supports populate multiple choice, list, checkbox, and grid style question options. | https://chrome.google.com/webstore/detail/formranger/faepkjkcpnnghgdhiobglpppbfdnaehc?utm_source=permalink | Forms | Office Staff, School Leaders, ICT Leaders, Teachers, Students | Auto-populating Form fields - very useful for RSVPs. | ||
| https://members.learningarchitects.com/wp-content/uploads/2019/02/Event-Manager.png | Event Manager | Manage RSVPs to events using a sheet, form and provide calendar invites to registrants! | https://chrome.google.com/webstore/detail/event-manager/cbfocjjpcfonndkpclhlbgcipohlmbbp | Sheets | Office Staff, School Leaders, ICT Leaders | Managing RSVPs for multiple events using a Google Sheet. |
There is something for everyone on this list. If you come across others, you can also submit these to the list for the benefit of other members.
If you find one that will benefit the community that isn’t listed, please submit it here…