This will bring up a new window that will show us several add-in options for Google Excel. If we click on the button with three lines at the top left, a menu opens from where we can filter plugins that appear according to our needs. Here, we can find the most popular, the most installed, the best rated or organized by categories, whether it is tools for business, productivity, education, communication or public services. There is also a searchwhere we can find any complement, for example, the ones we are going to see today.
Once we select a particular option, another screen appears with a brief description of it and a button. “Install” so you can add it to Google Sheets.
Once you select a particular option we will be asked to manage the permissions, so we click on the option “Let”. Later the process of adding the extension ends there and we will have it available.
To be able to access the complements we simply have to click on the menu of “Extensions” and in the drop-down menu, at the bottom, we will find the added extension. Similarly, to remove a plugin, all you need to do is select the Manage Plugins options in the same Extensions menu. This will open a window where the installed extensions are listed. Click on the three points inside the extension and select “Uninstall”.
Best plugins for Google Excel
Next, we are going to see a series of essential Google Sheets add-ons that will help us work better with the spreadsheet. Although most of them are paid, they also have a trial version so that we can try them for free.
Template Gallery for Sheets, add a wide variety of templates
It is a complement that will help us to be able to have, natively, a series of templates of various kinds to use in our jobs with Sheets. In this way they will save us a good amount of time by not having to start from scratch. Included here is a huge gallery of professionally designed templates, including calendars, schedules, invoices, time sheets, budgeting tools, letters, resumes, financial calculators, and more.
When we find a template that we want to use, just click the Copy to Google Drive button and the plugin will save a copy of the template in the root folder of our Google Drive. This plugin only requires the use of the Google Drive API to copy a spreadsheet or document template to our Google Drive. Therefore, it does not access, update or delete other documents, spreadsheets or folders in our Google Drive.
Power Tools, adds more functions and utilities to work
Another interesting add-on is Power Tools since it offers us a good number of additional features to use in Google Sheets. This includes both aesthetic functions, such as use, or improvement of experience and daily work With the program.
Included are functions that take care of removing duplicates, comparing and querying sheets, importing ranges from multiple sheets, merging cells, finding and replacing data, adding and counting colored cells, generating numbers and other records. It also includes a text toolkit that allows us to change case, add and remove strings and characters, trim whitespace, and split text into columns.
Of course, we must bear in mind that, in this case, we are talking about a paid add-on, although we will have a 30-day free trial available when installing it.
Advanced Find and Replace, advanced find and replace options
In the event that we normally handle a large amount of data in this tool, another add-on that can be of great help to us is Advanced Find and Replace, an add-on that, as its name suggests, presents us with a series of advanced options for locating and replacing elements of all kinds: values, formulas, notes, links, etc.
We can use this simple plugin for the advanced search in our Google spreadsheet. Thus, we will be able to find and replace text inside a formula, check hidden links behind the displayed text, search inside notes and search for values at the same time. It is possible to search and replace within a column by selecting the required range of data or by scanning the selected sheets. This plugin will show us the list of all found records organized by sheet and take you to any found cell with one click.
Likewise, given its large number of functions, we are facing a paid extension that has a free 30-day trial version.
Remove Duplicates for Sheets, find and remove duplicate data
Additionally, the plugin called Remove Duplicates for Sheets can also help us to eliminate duplicate data quickly and easily. duplicates are automatically deleted with distance correction and helps us save time. We can search for duplicates in two columns, with no requirements for editing scripts, macros, formulas, or special coding. We can quickly find duplicate cells and rows in a table, or sheets to highlight, copy, transfer or delete data from the results.
It also has individual characteristics that give us a variety of steps to follow in the content of the sheet. Thus, we can highlight duplicate or unique data with our favorite color tone, delete rows/cells and move to another Google spreadsheet. We can also copy data to another spreadsheet and mark it as a duplicate column. Also, we will be able to combine cells and rows of duplicates using delimiters and estimate numbers from duplicate rows with many functions.
Table Styles, customization and design of tables
In the event that ours is the design or we need to take special care in the external aspect of the personal spreadsheets that we create, we will surely appreciate the installation of the Table Styles plugin. This plugin focuses precisely on increasing the capabilities of customization and design of the jobs that we generate in the Google program.
This plugin allows us to quickly apply a uniform and professional appearance to our tables in Google Sheets. It has more than 50 preset styles divided into 6 groups. We simply need to select our data and use one of the predefined styles that are included in the plugin. Templates are very flexible to use, since they allow us to apply the format only to the elements of the table that we mark.
We can use this plugin for free for 30 days, after which you will need to pay to continue using it.
