Subscribe
Sign in
Sheets Refiner
p/sheets-refinerManaging messy data in google spreadsheet made easy
Start new thread
james cui

Sheets Refiner - Managing messy data in google spreadsheet made easy

by•

Sheets refiner is a collection of FREE tools to manage your messy spreadsheet data easily. Current feature set includes remove duplicates, remove blanks, convert case and split sheet.

Add a comment

Replies

Best
Gary Elley
Good work. Very useful.
Gary Elley
Perhaps you could add another tool to remove zeros values! https://gsuitetips.com/tips/shee...
james cui
Maker
@gary_elley thanks for the suggestion! May I ask whether you or your team members encountered this pain point in the day to day life? Want to evaluate how important the feature is. But again, thanks for bring this up, it might be the next small tool supported in sheets refiner!
Gary Elley
Another tool I would use is one that compares values in two columns and highlights the values that are not duplicates. (ie highlight the unique values).
james cui
Maker
@gary_elley right now remove duplicates in sheets refiner did that in row base, but it could be valuable to do column base as well. May I know your use case in mind? I mean what scenarios / applications that could be useful?
Gary Elley
@james_cui use case is where I want to compare values from the same column in two sheets that are laid out the same way. I don't mind manually merging the two sheets prior to running a 'compare' routine. Essentially, it's comparing similar data from two sources.
james cui
Maker
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
Meelad Mashaw
This is very useful, congratulations on your launch! -Meelad @ Apipheny.io
james cui
Maker
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
james cui
Maker
Demo of Compare spreadsheets