Data Cleaner

Trim header whitespace

Remove leading/trailing spaces from column names

Lowercase headers

Convert headers to lowercase_snake_case

Trim cell whitespace

Remove leading/trailing spaces from all cells

Remove empty rows

Delete rows where all cells are empty

Remove duplicate rows

Keep only the first occurrence of identical rows

Dedup by column(s)

Remove duplicates based on selected columns only

Remove empty columns

Delete columns where every cell is empty

Normalize booleans

Convert yes/no/1/0/on/off to true/false

Normalize phone numbers

Format US phone numbers to (555) 123-4567

Fill empty cells with "N/A"

Replace blank cells with N/A

Uppercase all cells

Convert every cell value to UPPERCASE

Lowercase all cells

Convert every cell value to lowercase

Find & replace

Replace text across all cells