[Total: 0 Average: 0/5]
SheetsRefiner is a free Google Sheets addon you should utilize to take away duplicates, clean rows, clean columns, and even cut up sheets in a couple of clicks. For now, it has four important instruments that you would be able to activate on any Google Sheet and it really works magically. The instruments that it provides are a lot wanted for normal Google Sheet customers and make the info transformation simpler with none difficult formulation.
Doing easy duties equivalent to eradicating duplicates or first occurrences from all the Google Sheet may be difficult. However with the add-on I’ve talked about right here, you are able to do this in a matter of seconds. Additionally, as an alternative of eradicating duplicate knowledge, you possibly can choose to simply spotlight it and go away it there within the sheet.
You could find another add-ons for Google Sheets to do the identical factor however they’re principally industrial or restrict their performance within the free plan. However this add-on right here is totally free and all of the options in it may be used for limitless variety of instances on any Google Sheet.
Take away Duplicates, Clean Rows, Cols & Cut up Google Sheet: SheetsRefiner
You possibly can obtain and install SheetsRefiner from Google Marketplace. After that, yow will discover it within the Add-ons menu of the GSheets. Proper now, it has the next important capabilities in it and they’re:
- Spotlight duplicates with person chosen colour, distinctive, duplicate + first occurrences, distinctive + first prevalence
- Clear rows/cells
- Course of present sheet tab solely
- Delete rows/cells
- Change case sensitivity
- Skip headers for sure operation
- Create backup for authentic knowledge
- Inclusion/exclusion of clean cells and rows
- Course of chosen vary in present sheet tab
- Course of all sheet tabs collectively
To make use of any instrument, you simply open the sheet you need to manipulate after which merely choose what you need to do. Choose any instrument and apply it to the present sheet. Earlier than continuing, in order for you then it’s also possible to choose to skip header rows or choose a selected situation to match to use the chosen operation.
That is it. On this means, you possibly can choose and use different capabilities of this add-on. The method may be very easy and easy. It labored as anticipated with none errors throughout my testing. Nonetheless, it could take a while on sheets with plenty of rows with complicated knowledge.
Google Sheets are utilized by a whole lot of organizations every day and it is among the most important enterprise instruments as properly. However some duties are repetitive and required every day by totally different professionals. One such process is highlighting or deleting duplicate knowledge. Different instruments to do that are principally industrial so SheetsRefiner is an excellent choice. I preferred its simplicity and capabilities that it has included in it. I hope there might be extra instruments on this GSheet add-on in later updates.