Excel Tools for HR & Recruiters

Candidate lists and employee rosters arrive in every imaginable shape. These free Excel macros standardize the messy parts: phone numbers, full names, duplicate applicants, mixed-case text. You stop reformatting and start hiring.

AI tool finder

Try:

Tools for HR & Recruiters

Add Prefix and Suffix to Cells

Bulk-add text to the start and/or end of every cell in your selection, with formulas left untouched

productivity

Bulk Find and Replace From Table

Read a 2-column table of find/replace pairs and apply every pair to your data range in one pass

productivity

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

Compare Two Columns

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

data-cleanupreporting

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

Extract Email Addresses From Text

Pull every email address out of messy free-form text into a clean adjacent column

productivity

Find and Replace Across All Sheets

Replace text in every worksheet of your workbook in one go, with case and whole-cell options

productivity

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

Insert Blank Row On Change

Insert a blank row above every cell where a chosen column's value changes from the row above.

productivityreporting

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

Split Full Names Into First and Last

Take a single column of full names and split it into First Name and Last Name columns to the right

productivity

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

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