Sheets Refiner
Google spreadsheets lack of handy tools which helps users to clean up and transform their data. Existing tools are limited by their functionality. Sheets Refiner tries to resolve the problem by providing a list of handy tools to spreadsheet users. Current functionality includes remove duplicate, remove blank rows and columns and convert case, split sheet, combine sheets and hide or remove values.
There are 7 major features in Sheets Refiner now
Remove duplicates: Remove duplicate helps to highlight, delete or clear duplicate rows or cells with full of flexibility
Find duplicates, uniques, duplicate + first occurrences, unique + first occurrence
Highlight/Clear/Delete rows/cells
Case sensitivity
Skip headers
Create backup for original data
Inclusion/exclusion of blank cells and rows
Process selected range in current sheet tab
Process all sheet tabs together
Process current sheet tab only
Straightforward UI with all options shown at once
Encourage my work by buy me a coffee
Cache user configs
Help Content
Remove Blanks: Remove blank helps get rid of blank rows and columns quickly
Delete blank rows or columns or both
Consider space characters as blanks
Create backup for original data
Process current sheet tab
Process all sheet tabs
Process selected range in current sheet tab
Straightforward UI to show all options at once
Encourage my work by buy me a coffee
Cache user configs
Help Content
Convert Case: Change the case easily with one click
All characters to uppercase
All characters to lowercase
First letter capitals
Invert the case of each character
Create backup
Skip header row
Process all sheet tabs
Process current sheet tab
Process active range in current sheet tab
Straightforward UI to show all options at once
Encourage my work by buy me a coffee
Cache user configs
Help Content
Split Sheets: Divide sheets into multiple based on content (group by columns).
Split current sheet into multiple based on content
Skip header rows
Ignore blank cells
Trim space before split
Save to current spreadsheet or a new spreadsheet
Encourage my work by buy me a coffee
Cache user configs
Help Content
Compare Columns or Sheets: Quickly find difference between columns or sheets
Compare columns in the same sheet
Compare sheets with selected columns
Backup main sheet tab
Skip header rows
Ignore blank rows
Case sensitive matching
In-App Stripe based payment
Donation with buy me an coffee
3 days free trail
Combine Sheets: Merge sheet tabs into one
Combine sheet tabs into one
Merge sheet tabs based on header row
Separate the copied range by blank row
Merge into a new spreadsheet
3 days free trail
Hide or remove Values
Rich filter to select the target value
Backup current sheet tab
Skip header row
Hide, Unhide or remove value
Process current sheet tab
Process all sheet tabs
Process selected range
3 days free trail
FAQ
Authorization is required to perform that action: This is an error from Chrome that sometimes occurs when you have multiple Google accounts open in the same session. To resolve, open an Incognito (private) window and sign in with the account that you want to use. Make sure the add-on is installed on your target account before using it. If you do not know how to use the Incognito window here is a video
This action would increase the number of cells in the workbook above the limit of 500000 cells: The number of cell limitation is enforced by Google on each spreadsheet. If you encountered this in Sheets Refiner, it is likely because you used the backup option in the UI. To overcome this, 1. backup your spreadsheet manually in a new spreadsheet if you want to keep a copy of the original data. 2. Use Sheets Refiner without backup option.