Excel Tools for Sales & RevOps
CRM exports are never clean. These free Excel macros take the friction out of pipeline reporting: dedupe leads, split full names, summarize by region, find missing data. You report faster and chase the right deals.
Tools for Sales & RevOps
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
Add Running Total Column
Write a cumulative running total to the column next to your numeric column, in one pass
Add Totals Row to Numeric Columns
Drop a SUM formula at the bottom of every numeric column in your selection, plus a 'Total' label and a top border
Auto Pivot Summary
One-click summary of any data: group by one column and sum another, output to a new Summary sheet
Bulk Add Hyperlinks
Convert every URL-like cell in your selection into a clickable hyperlink in one pass
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
Clean Phone Numbers
Strip dashes, spaces, parens, and dots from a column of phone numbers so every entry is just digits
Combine All Sheets Into One
Stack the data from every worksheet in a workbook into a single Combined sheet, with one header row at the top
Compare Two Columns
Highlight every cell in two columns whose value does not appear in the other column, in one click.
Convert Text to Numbers
Turn numbers stuck as text back into real numbers, including currency symbols, commas, and parens
Convert Text to Proper Case
Capitalize the first letter of each word in your selection and lowercase the rest, in place
Count and Sum Cells by Color
Count how many cells share a background color, and sum them when they're numeric, with one click
Extract Email Addresses From Text
Pull every email address out of messy free-form text into a clean adjacent column
Extract Numbers From Text
Pull every number out of a column of text cells and write them comma-separated to the next column.
Fill Blank Cells With Value Above
Walk down each column and copy the most recent non-blank value into every blank cell underneath it
Find and Replace Across All Sheets
Replace text in every worksheet of your workbook in one go, with case and whole-cell options
Highlight Duplicate Values
Color every cell whose value appears more than once in your selection
Highlight Rows Containing Keyword
Color every row in your selected range where any cell contains a keyword you type in.
Highlight Top and Bottom Values
Color the top N values green and the bottom N values red in your selection in one click
Insert Blank Row On Change
Insert a blank row above every cell where a chosen column's value changes from the row above.
List All Sheet Names
Generate an index sheet at position 1 with a hyperlinked list of every other sheet in the workbook
Remove All Formatting
Strip all colors, borders, fonts, and number formats from your selection while keeping values and formulas intact
Remove Blank Rows
Delete every row in your selection where every cell is empty or contains only whitespace
Remove Duplicates by Multiple Columns
Delete rows where the values in two or more columns you choose are all the same
Remove Line Breaks From Cells
Strip newlines and tabs from text cells, replacing them with spaces and collapsing extra whitespace
Split Cell on Delimiter
Split each cell in a column on any delimiter you choose, writing the parts to columns to the right
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
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
Swap Two Columns
Swap the data in two columns in one click, supporting both adjacent and Ctrl-clicked non-contiguous columns
Transpose Rows and Columns
Copy your selection and paste a transposed version (rows become columns and vice versa) at the cell you pick
Trim Whitespace From All Cells
Strip leading, trailing, and extra internal whitespace from every text cell in your selection
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