Sheets Refiner

Managing messy data in google spreadsheet made easy

2 followers

Managing messy data in google spreadsheet made easy

2 followers

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.

Launch tags:Productivity•User Experience•Tech

Launch Team

Viktor.comAn AI coworker that actually does the work

Promoted

Easy Importing

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

Report

5yr ago

Easy Importing

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

Report

5yr ago

Good work. Very useful.

Report

5yr ago

Perhaps you could add another tool to remove zeros values! https://gsuitetips.com/tips/shee...

Report

5yr ago

Easy Importing

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!

Report

5yr ago

@james_cui it certainly is a pain point for me personally, that's why I suggested it :)

Report

5yr ago

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

Report

5yr ago

Easy Importing

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?

Report

5yr ago

Easy Importing

Maker

Demo of Compare spreadsheets

Report

5yr ago

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

Report

5yr ago

Reviews