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.

Privacy Policy Terms & Conditions