Sheets Refiner — Managing messy data in google spreadsheet made easy

Good work. Very useful.

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 remove duplicate, remove blank rows and columns and convert case, split sheet ( group by columns ) and much more coming. There are 5 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 * 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 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 * 7 days free trial

This is very useful, congratulations on your launch! -Meelad @ Apipheny.io

We have added new features to sheets Refiner, feel free to try that and send us a feedback! 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 * 7 days free trial

Demo of Compare spreadsheets