Google Sheets Add-Ons
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
Advanced Find & ReplaceCVS ConverterFlubarooGeocodeMapping SheetsRandom GeneratorSort By Color
App SheetData ToolsformCreatorImport SheetMerge ValuesRemove DuplicatesSplit Names
AutocCratEasyConcatFormMuleInsert &
Delete Cells
Power ToolsrowCallVLOOKUPSTR
copyDownFiles CabinetFuzzy
Lucid Diagrams for SheetsPuzzle SolverSave As DocYet Another Mail Merge
Advanced Find & ReplaceSearch in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click
Advanced Find and Replace add-on will help you complete any substitutions in your sheets in seconds.
You can look for the record you need in hyperlinks hidden behind the display text, formulas, and even notes. The search in values is performed with advanced parameters as well: you can match case, retrieve the cells that contain only the exact entry, or get any text occurrences.
This Google Sheets add-on is very easy to work with:
- Enter the value, choose its type and the sheets to search in
- See all matches listed in the sidebar
- Replace all or only the selected records
- Export the found values, or get the entire rows with the entries
Finding and replacing data in your worksheets is a breeze with this tool at hand.
App SheetBuild a custom mobile app from your Google spreadsheet. It is easy, takes only a few minutes, and no coding is involved.
Make your Google spreadsheets truly mobile with AppSheet.. With AppSheet, you can create and deploy mobile solutions for your business automatically from Google Sheets. It is easy, free, and there is no coding involved.
AutocCratFlexible, easy to use document merge tool that creates PDF or shared Documents from spreadsheet data.
autoCrat: So you don't have to be the bureaucrat!

Automates the creation and sharing of personalized (e.g. merged) Google Docs or PDF email attachments from columns of data in a Google Sheet. Optionally merge documents when forms are submitted!
copyDowncopyDown adds functionality to Form-fed Google Sheets -- the ability to have row 2 formulas auto-copied into form submission rows. Adds a simple but revolutionary functionality -- the ability to have formulas and cell formats carry into new form submission rows.

With this ability, any Google form submission can auto-calculate subtotals, perform a vertical lookup against another sheet, include conditional formats or data-validation lists in new form rows, or calculate a count or countif tied to a cutoff threshold and more!
CVS ConverterCSV Converter allows you to handle CSV data in your spreadsheet. You can convert CSV data to rows and columns or back to CSV. Additionally It allows you to paste CSV as rows and columns or upload a CSV file. Choose specific columns you want to download as CSV.
Data Tools1. Remove Duplicates.
2. Text to Columns.
3. Get Link to Spreadsheet: the name of the spreadsheet will be the text and clicking on it will get you to the spreadsheet itself. You can paste it to your email or anywhere else you are interested in.
4. Manipulation of Text: changes text in selected range to Lower Case, Upper Case or Camel\Proper Case depends on your selection.
EasyConcatEasyConcat makes concatenating cell values a snap, and ignores blank cell values automatically. Click and drag across the cells you want to concatenate for the first value (or just type in the range), then specify a delimiter in quotes for the second value. You can also have it skip characters that you choose by using the optional "skipvalue" parameter.
Files CabinetQuickly list all the files of a Google Drive folder in a spreadsheet, and automatically display it in an Awesome Table view.
Files Cabinet by Awesome Table is an add-on that helps you list a Google Drive folder. It explores every child folder and lists every file that can be found. After giving you a quick count of all the folders and all the files, you get a list of the files that are ready to be displayed in a catalog created with Awesome Table.

Even if you have a huge Google Drive, Files Cabinet will find its way. It can list thousands of files and is only limited to the size of the spreadsheet (two million cells) - which means up to 100 000 files! Just leave the sidebar open and wait for the spreadsheet to be filled. If you have a bigger Drive, and wish to list it, feel free to contact us.

Files Cabinet does not keep neither use any of your data after they were listed. (By Awesome Table)
FlubarooFlubaroo is a FREE add-on to Google Forms/Sheets which lets you quickly grade and analyze student performance on multiple choice and fill-in assignments. Within a minute you'll be able to:
* Get scores for each student, and identify students in need of extra help.
* View average score, and a histogram of scores.
* Quickly identify questions which a majority of the students missed.
* Share scores with students via email or Google Drive, along with optional notes to the class and/or to each student.
* Assign your own score to open-ended questions.
formCreatorCreate a form directly from the values in your spreadsheet.
FormMuleFormMule (Email) is a communications work animal, perfect for form driven email switchboards or herding cats in project management. formMule sends targeted, personalized emails from a Google Sheet. Run as either a manual email merge or -- more powerfully -- as a triggered merge that runs automatically on form submit or on a timer.

- Handy email template editor auto-inserts merge tags with the click of a button, making template-creation a breeze!
- Can be set to use up to 10 different email templates based on specified send conditions.
- Create unique case numbers on form submit for use in keying follow-ups.
- Grab and send form response edit URLs, and formulas copied down on form submit
- Custom spreadsheet functions RANGETOTABLE and RANGETOVERTICALTABLE make it possible to merge tables of multiple, matching records into email bodies.
his helpful add-on scans your sheet for typos and lets you correct them in seconds. This add-on is a great assistant for correcting all fuzzy matches and removing partial duplicates from your sheet.

Your table may have similar entries for company names, surnames, or cities; you can deal with all misprints in one go.
- Use three simple settings to narrow your search results
- Get all typos grouped by record
- Pick or enter the correct values and apply changes

Besides comparing entire cells, you can look at every word within the cells separately. Set the number of different characters your values may have and exclude short words from the search. Once you get your results, export them to a new sheet or work with them right in the pane. Tick off the right value to change all similar records in the group; you can select any misspelling to see where it is in the sheet if you have any doubts. If all entries are inaccurate, you can type in the valid one.
GeocodeA map tool that helps you get latitudes and longitudes from addresses in a Google Sheet and display them on a Google map you can share. Easiily get geographic data- Adresses are converted into Maps coordinates: longitudes and latitudes. Geocode uses Google's services to retrieve this data. (powered be Awesome Tables)

1. Create a spreadsheet (or reuse one of your existing ones)
2. Add physical addresses and other info
3. Use the spreadsheet menu Add-on > Geocode
4. Indicate the column containing your addresses
5. Click on the button to start the geocoding
6. That’s all! Once the geocoding is done, you will see two more columns in your spreadsheet (for latitude and longitude data) and a link to the Maps view created.
Import SheetEasily Connect Sheets to Sync & Consolidate Data Automatically
Import Sheet allows users to easily and automatically import or export data from one spreadsheet to another. The add-on saves the Sheet Link for future imports, provides the ability to schedule, shows sync status, auto formats, uses a smart algorithm to process data, can append data and more.
Insert &
Delete Cells
Creates menu items that allow you to easily insert blank cells in the middle of a spreadsheet, shifting the existing content down or to the right.
- It also allows you to delete cells in the middle of a spreadsheet, shifting in content up or left.
- Adds a feature that Excel Users are familar with using that Google Sheets lacked.
- Changes can be easily undone with Edit - Undo (Control- or Command-Z).
Lucid Diagrams for SheetsQuickly create and insert flowchart, UML, wireframe, mind map, and more diagrams directly into a Google document. Part of the Lucid group including the Lucid Chart App.
Mapping SheetsThe type of data we want to put on a map is all over the place, from business contacts to next week’s appointments, or simply your friends’ addresses.
For the first time, the Mapping Sheets add-on provides an easy way to plot your data onto a Google Map directly from Google Sheets with just a few clicks.
Merge ValuesYou can join values in the selected rows, columns, or cells and keep the original data untouched. Makes the process of combining records in your sheet very simple.
- Choose if you want to merge values horizontally, vertically, or get all records from the range in one cell
- Enter delimiters to separate the joined values
- Pick additional options that let you skip empty cells, wrap text, and more
You can keep your table structure or insert new columns and rows with the merged data. This tool still allows you to merge areas without losing a single value.
Power ToolsA giant suite of tools. There is both a free and paid version with additional tools. Also a great tool to add in some of the Excel like operations not found in Google Sheets.
There are so many options that I needed to use multiple spreadsheet rows below to show them all
Power Tools (continued) Smart toolbar offers a set of one-click actions
- Advanced find and replace in all selected sheets
- Insert cells and shift data down or right
- Delete cells and shift data up or left
- AutoSum all numbers in columns or rows
- Sum by fill and text color
- Flip values in adjacent cells, rows, or columns with or without their format
- Change case
- Freeze or unfreeze top rows and left columns
Power Tools (continued)Main tool sets group solutions by type:
Remove unwanted data
- Delete leading and trailing spaces
- Reduce spaces between words to one
- Remove html entities, non-printing characters, and delimiters
- Get rid of any character or string in the range
- Delete characters by position, or those that follow or precede certain text
- Remove empty or unused rows and columns
Power Tools (continued) Clear data by type
- Erase any combination of data types from the selected range: formatting, numbers, dates, booleans, notes, text, or hyperlinks
Work with text
- Capitalize each cell or word, change case to uppercase or lowercase
- Add your text at the beginning or at the end of the selected cells, before or after certain text, or at any position you like
- Replace accented characters with non-accented, turn codes to symbols and back
Power Tools (continued) Convert data format
- Convert text-formatted numbers and dates to numeric and date format
- Change number sign
- Export range to JSON or XML
Try out the formula tools
- Switch formula reference type from relative to absolute or vice versa
- Get values instead of the formulas
- Automatically add functions to all selected columns
- Apply new calculations to all formulas at once
Power Tools (continued) Split tool set
- Separate values by any character or string
- Split text by position
- Extract name parts into separate columns
Data tool set
- Identify duplicate records in any combination of columns on your sheet
- Compare two columns or sheets to find duplicates
- Join values in rows, columns, or the entire range and keep cells unmerged
- Merge sheets by a key column
- Shuffle values in rows, columns, or the entire range
- Generate random numbers, dates, booleans, custom lists, or strings
Puzzle SolverCustom functions for Google Sheets to help solve puzzles. Functionality includes braille decoding, morse decoding, and cryptograms.
Random GeneratorWhenever you need a random set of data in your sheet.
Forget about inventing clever passwords: this tool will quickly create any number of random strings that meet your requirements. All you need is pick a set of characters and choose the length for the generated values. The add-on is also good at filling your range with workdays or weekends in the selected time period, getting unique numbers from the defined range, randomizing your custom values, or simply putting yes/no or true/false values at random.
Create any set of random data in your sheet in three simple steps:
- Select the range you want to fill with random values
- Choose from 6 types of data to generate: integer or real numbers, dates, booleans, custom list values, or strings
- Narrow down the data range or character set and click "Generate"
Remove DuplicatesComes with two useful wizards. One will show how to delete duplicates in Google Sheets in 4 steps, the other will quickly compare data from two columns for repeated values.
rowCallrowCall sorts rows from your main sheet by the column you select and creates individual sheets for every unique cell in that column.
rowCall filters rows from your main Google Sheet by whatever column you select and then creates individual sheets for every unique cell in that column. This calls the rows out into their own space. If the automatic setting is enabled, any new entry or alteration to the main sheet, manual or form driven, will be fed to the individual sheets.

It can be used for a variety of purposes, such using a Google Form for assessments or self assessment. For example; each week students complete a self-assessment rubric form, the form is completed by all students in the class sending the results to the form response sheet. A teacher can then use the rowCall Add-on to create a separate sheet for each student and quickly view their individual entries in addition to the whole class summary of results from the form response sheet. Each new form entry will go to the form response sheet as well as each individual sheet if the automatic setting is enabled, thus providing a master sheet of the whole class scores each time a form entry is made and auto updating the individual sheets with their scores.
Save As DocConvert any Google Sheets spreadsheet into a Google Document for improved legibility of lengthy cell text entered manually or through a Google Form submission. Basically, this will make Google Forms submissions readable!
Sort By ColorSort your color-coded spreadsheet by CELL COLOR or FONT COLOR.
When data is color-coded and the only constant is the color of the cells or the fonts, sorting your data can be difficult. Now you can sort your color-coded spreadsheet based on the color of the cell or the color of the font. By reading the color of the cell or font, Sort By Color uses the hex code as sortable text.
Split Names"Quickly split full names to several columns with first, middle, last names, titles, and/or post-nominal letters.

The add-on recognizes over 80 titles and 40 post-nominals; you can be sure you address people appropriately.
- Select your column with full names
- Start the add-on and pick the parts you have: titles, name parts, and post-nominal letters
- Click ""Split"" and see new columns with the results
The add-on will insert columns with the selected name units next to the original one. You can keep your table structure by considering or ignoring headers."
VLOOKUPSTRVLOOKUPSTR(search_key, range, index, case_insensitive) This function acts like the build-in function VLOOKUP. But it performs a non-full-match string searching, which can not be done by VLOOKUP. Example: =VLOOKUPSTR(A1, A2:B26, 2, FALSE)
Yet Another Mail MergeQuickly split full names to several columns with first, middle, last names, titles, and/or post-nominal letters.

The add-on recognizes over 80 titles and 40 post-nominals; you can be sure you address people appropriately.
- Select your column with full names
- Start the add-on and pick the parts you have: titles, name parts, and post-nominal letters
- Click "Split" and see new columns with the results
The add-on will insert columns with the selected name units next to the original one. You can keep your table structure by considering or ignoring headers.
Main menu