Compare sheets, Remove duplicates, Remove blanks, Convert case, Split Sheets, Combine sheets, Hide or remove value, Merge sheets, AI refiner
Listing updated:December 29, 2023
Works with:
8K+
Overview
Google spreadsheets lack of handy tools which helps users to clean up and transform their data. Existing tools are either commercial or limited by their functionality.  SheetsRefiner tries to resolve the problem by providing a list of handy tools to spreadsheet users. Current functionality includes compare sheet, remove duplicate, remove blank rows and columns and convert case, split sheet ( group by columns ), hide or remove target value, merge sheets and AI refiner. 

There are 9 major features in Sheets Refiner now
1. Remove duplicates : Remove duplicate helps to highlight with user customized color, delete or clear duplicate rows or cells with full of flexibility. 
Options: 
  * Highlight duplicates with user selected color, uniques, duplicate + first occurrences, unique + first occurrence
  * Clear rows/cells
  * 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 

2. Remove Blanks : Remove blank helps you to quickly get rid of blank rows and columns, crop your sheet with just data and trim cells within a range.
Options:
  * Delete blank rows or columns or both 
  * Consider space characters as blanks
  * Backup 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 

3. Convert Case: Change the case easily with one click
Options:
   * All characters to uppercase
   * All characters to lowercase
   * Proper case (First letter capitals for each word)
   * Invert the case of each character
   * Sentence case 
   * 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

4. Split Sheets:  Divide your sheets into multiple based on content (group by columns)
Options
   * 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   

5. Compare Columns or sheets: Compare two sheets or columns and quickly spot alterations and changes.
Options
   * Compare columns in the same sheet 
   * Compare sheets with selected columns
   * Backup main sheet tab
   * Skip header rows
   * Ignore blank rows
   * Case sensitive
   * In-app Stripe based payment
   * Donation with buyme an coffee
   * 3 days free trial 

6. Combine sheets : combine multiple sheet tabs into one quickly.
Option
   * Combine multiple sheet tabs into a new sheet tab
   * Combine multiple sheet tabs into a new spreadsheet
   * Separate combined sheets with empty rows for better navigating
   * Use header row to merge columns
   * In-app Stripe based payment
   * Donation with buyme an coffee
   * 3 days free trial 

7. Hide or remove target value: Hide or remove a target value (e.g., zeros) quickly for better data analyzing and reporting with 1 click.
Options
   * Hide target value in current sheet tab, active range or all sheet tabs 
   * Unhide target value in current sheet tab, active range or all sheet tabs
   * Remove target value in current sheet tab, active range or all sheet tabs 
   * Backup spreadsheet
   * In-app Stripe based payment
   * Donation with buyme an coffee
   * 3 days free trial 

8. Merge Sheets: merge two sheet tabs quickly with rich operations.
   * Merge sheets with compared columns to update existing columns or append new columns
   * Backup main sheet tab
   * Skip header rows
   * Ignore blank rows
   * Case sensitive
   * Highlight updated cells
   * Add status column in main sheet
   * Update only empty cells in main sheet
   * Update only if look up sheet is not empty
   * In-app Stripe based payment
   * Donation with buyme an coffee
   * 3 days free trial

9. AI refiner: Generated script/code automatically with ChatGPT AI LLM and executed the generated script in the app. 
   * Generate app script code by AI on the fly to refine sheets data. 
   * Execution the generated script code with One click
   * Provided few typical questions to start
   * Cache results whenever possible
   * Detailed status report for the execution. 
   * Flexibility for easy tasks instead of relying on customized solutions. 

===========================================================
Sheets Refiner is the most user friendly and most affordable addon to manage messy data for Google Sheets among other great apps, such as chromebookInventory, Stupeflix, MathType, Doc Appender, Power Tools, PlanbookEdu, Bark, PowerSchool, Nearpod, Super Quiz, Slido, MindMup, Lucidpress, Form Mule, VoiceThread, LumApps, BetterCloud, YAMM, Spanning Backup, Digication, Grackle Docs, Form Ranger, EasyBib, DocuSign eSignature, Drag, Colaboratory, Yet Another Mail Merge ,SketchUp for Schools, Asana, Mailmeteor, GAT+, SysCloud Security, Mindomo, diagrams.net, MindMeister, BrainPOP, Cisco Webex, Kami, Screencastify,  Wrike, Mojo Helpdesk, Kaizena, JoeZoo Express, Backupify, Appsheet, Kabanchi, Timify.me, gPanel, Flubaroo, Hapara Teacher, Form Publisher, Slack, Sketchboard, Smartsheet, Zapier, GQueues, AODocs, Certify'em, Easy Accents, StackEdit, Mavenlink, DocHub, Choice Eliminator, Pixton for Schools, SMART Learning Suite, Pear Deck, Doctopus, EasyBib, LucidChart Diagrams, GoFileDrop, PerformFlow, NoodleTools, Zoom,Text gBlaster, formLimiter, Form Publisher, Awesome Table and more...
Additional information
PricingFree of charge trial
Developer
Non-trader
Privacy policy
Terms of service
Sheets Refiner will ask for the permissions shown below. Learn more
Sheets Refiner will need access to your Google account
This will allow Sheets Refiner to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Aryan Gupta
January 8, 2024
good stuff
Is this review helpful?
Yes
No
Profile Picture
Carline Clerina
November 16, 2022
i llikeit so much
Is this review helpful?
Yes
No
Profile Picture
Mohammad Suleman
May 4, 2021
Other tools are nice but Splitting Sheets doesn't work. It creates the same sheet.
Is this review helpful?
Yes
No
Profile Picture
Isaac Benge
February 8, 2021
****Authorization is required to perform that action.*** useless for me since it always gives this error. Their site claims you have to log out of other accounts to use. I tried that and it still did not work
Is this review helpful?
Yes
No
Profile Picture
james cui
December 15, 2020
Sheets refiner is a handy tool to remove duplicates, remove blank rows and convert case, and much more. Stay tuned!
Is this review helpful?
Yes
No
1-5 of 5
Search
Clear search
Close search
Google apps
Main menu