Data cleaning
Remove duplicates, blanks, spaces and format issues.
Remove duplicates
Find and remove repeated records based on selected columns.
Remove Excel duplicates
Remove duplicates from a local workbook and save a new copy.
Remove CSV duplicates
Clean repeated records from a CSV file.
Find duplicates
Show repeated records without removing them.
Remove empty rows
Remove records that contain no data.
Remove empty columns
Remove columns that contain no values.
Find empty cells
Locate missing values in the sheet.
Fill empty cells
Insert a constant, zero, average or previous value.
Trim extra spaces
Trim leading and trailing spaces and reduce repeated spaces.
Uppercase a column
Convert text in selected columns to uppercase.
Lowercase a column
Convert text in selected columns to lowercase.
Capitalize a column
Format text as title case or sentence case.
Remove special characters
Remove selected characters from text values.
Add a prefix to a column
Add the same text before each value.
Add a suffix to a column
Add the same text after each value.
Replace comma with dot in numbers
Standardize the decimal separator in selected columns.
Replace dot with comma in numbers
Prepare numbers for Polish-style presentation.
Convert text to numbers
Recognize numeric values stored as text.
Normalize dates
Convert mixed date formats to one selected format.
Clean phone numbers
Remove unnecessary characters and standardize phone numbers.
Clean email addresses
Trim, normalize and flag invalid email syntax.