Excel Data Cleanup Tools

Tools that fix messy spreadsheets: duplicates, inconsistent formats, stray whitespace, broken text.

Change Case to UPPERCASE or lowercase

Convert every text cell in your selection to UPPERCASE or lowercase in a single click

data-cleanup

Clean Phone Numbers

Strip dashes, spaces, parens, and dots from a column of phone numbers so every entry is just digits

data-cleanup

Clear All Comments

Delete every cell comment in your selection in one shot, with a confirmation prompt before deletion

data-cleanup

Compare Two Columns

Highlight every cell in two columns whose value does not appear in the other column, in one click.

data-cleanupreporting

Convert Hyperlinks to Plain Text

Extract the URL from each hyperlinked cell and replace the cell content with the plain URL text

data-cleanup

Convert Text to Numbers

Turn numbers stuck as text back into real numbers, including currency symbols, commas, and parens

data-cleanup

Convert Text to Proper Case

Capitalize the first letter of each word in your selection and lowercase the rest, in place

data-cleanup

Delete Empty Columns

Remove every column in your selection where all cells are empty or whitespace-only

data-cleanup

Extract Numbers From Text

Pull every number out of a column of text cells and write them comma-separated to the next column.

data-cleanupproductivity

Fill Blank Cells With Value Above

Walk down each column and copy the most recent non-blank value into every blank cell underneath it

data-cleanup

Highlight Blank Cells

Color every blank or whitespace-only cell in your selection light red so missing data is visible at a glance

data-cleanup

Highlight Cells With Comments

Color every cell in your selection that has a comment (note) so you can spot annotations at a glance

data-cleanup

Highlight Duplicate Values

Color every cell whose value appears more than once in your selection

data-cleanup

Highlight Rows Containing Keyword

Color every row in your selected range where any cell contains a keyword you type in.

data-cleanupproductivity

Remove All Formatting

Strip all colors, borders, fonts, and number formats from your selection while keeping values and formulas intact

data-cleanup

Remove Blank Rows

Delete every row in your selection where every cell is empty or contains only whitespace

data-cleanup

Remove Duplicates by Multiple Columns

Delete rows where the values in two or more columns you choose are all the same

data-cleanup

Remove Line Breaks From Cells

Strip newlines and tabs from text cells, replacing them with spaces and collapsing extra whitespace

data-cleanup

Remove Special Characters

Strip non-alphanumeric characters from text cells in your selection, with options to keep spaces and basic punctuation

data-cleanup

Split Cell on Delimiter

Split each cell in a column on any delimiter you choose, writing the parts to columns to the right

data-cleanup

Standardize Mixed Date Formats

Convert text dates in M/D/Y, D/M/Y, or Y-M-D format into real Excel dates with a YYYY-MM-DD display

data-cleanup

Transpose Rows and Columns

Copy your selection and paste a transposed version (rows become columns and vice versa) at the cell you pick

data-cleanup

Trim Whitespace From All Cells

Strip leading, trailing, and extra internal whitespace from every text cell in your selection

data-cleanup

Unmerge Cells and Fill Down

Unmerge every merged cell in your selection and copy the value into all the cells the merge used to span

data-cleanup