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...