Clean and standardise spreadsheet data
Remove duplicates, trim whitespace, fix inconsistent dates and numbers, split or merge columns, and validate data quality before it reaches your reports.
11 tools in this categoryColumn Splitter
Split one column into many by delimiter, width or pattern.
Column Merger
Combine several columns into one with a custom separator.
Remove Duplicates
Delete duplicate rows across any combination of columns.
Duplicate Finder
Find and highlight duplicates without deleting anything.
Excel Data Cleaner
Fix messy spreadsheets in one pass.
Data Validator
Check every row against rules before it reaches your report.
Date Formatter
Standardise every date in a column to one format.
Text Formatter
Change case, trim, pad and reshape text columns in bulk.
Number Formatter
Clean currency, decimals, percentages and thousand separators.
Excel Data Sorter
Multi-level sorting with custom orders and locale rules.
Excel Filter Tool
Filter rows with stacked conditions and export the result.