ASAP Utilities for Excel - Most Popular Tools

Most Popular Tools

Save time in Excel with practical tools that make everyday work easier and faster.

Here are some of the tools ASAP Utilities users value most:

Remove Leading, Trailing, and Extra Spaces

Clean messy data and prevent lookup errors caused by hidden spaces.

"  Sarah   Johnson  "
 ↓
"Sarah Johnson"

Convert Text Dates to Real Excel Dates

Fix imported dates so Excel can sort and calculate them correctly.

"JAN 23 26"
 ↓
"23-01-2026"

Rename Multiple Sheets at Once

Rename many worksheets in one step instead of editing them one by one.

Sheet1, Sheet2, Sheet3...
 ↓
Sales, Budget, Forecast...

Convert Numbers Stored as Text to Real Numbers

Fix numbers that Excel treats as text so they work correctly in calculations and formulas.

"123" (text)
 ↓
123 (number)

Sum or Count by Font or Cell Color

Count or sum cells based on their color directly in Excel.

🟩 Sum all green cells
🟥 Count all red cells

Export Worksheets as Separate Files

Save each worksheet as its own file in one go.

Sales.xlsx
 ↓
12 separate report PDF files

Create a Worksheet Index

Create a clickable overview to quickly navigate large workbooks.

48 worksheets
 ↓
1 clickable overview

Fix Trailing Minus Signs

Convert imported accounting values into real negative numbers.

"250-"
 ↓
"-250"

Clean Up Messy Imported Spreadsheets

Fix formatting issues, trim spaces, and repair imported values in one cleanup step.

Messy imported worksheet
 ↓
clean worksheet ready to work withs

Fix Trailing Minus Signs

Convert accounting-style negatives into real Excel numbers.

1250-
 ↓
-1250

Remove Hidden Characters

Remove invisible characters that break sorting, filtering, and lookups.

Lookup returns #N/A
 ↓
matching works again

Convert Numbers Stored as Text to Real Numbers

Fix imported numbers so formulas and calculations work correctly.

SUM returns 0
 ↓
calculations work again

Highlight Duplicate Values with Different Colors

Quickly spot and review duplicate values across your data.

Duplicate entries across your data
 ↓
shown in matching colors

Remove Empty Rows

Clean up large lists and remove unwanted empty rows instantly.

200 empty rows removed
 ↓
clean compact table

Remove Hidden Line Breaks

Remove unwanted line breaks that affect printing and lookups.

Broken address formatting
 ↓
clean single-line values

Remove or Replace Unwanted Characters

Remove or replace unwanted characters in selected cells quickly.

(555) 123-4567
 ↓
5551234567

Change Text Case Without Formulas

Change text capitalization directly in your selected cells without formulas or helper columns.

sArah JOHNSON
 ↓
Sarah Johnson

Merge Cell Contents

Combine text from multiple cells into one value.

Product + Region + Year
 ↓
Laptop_US_2025

Add Text Before or After Cell Content

Quickly add prefixes or suffixes to codes and IDs.

45821
 ↓
INV-45821

Spell Numbers in Words

Convert amounts into readable text automatically.

2480.95
 ↓
Two Thousand Four Hundred...

Remove or Keep Specific Characters

Quickly keep or remove letters, numbers, symbols, spaces, and more.

AB-45821-CD
 ↓
45821

Change Text to UPPERCASE Without Formulas

Standardize product codes and identifiers directly in your selected cells.

inv-us-45821
 ↓
INV-US-45821

Sum or Count by Font or Cell Color

Count or total highlighted values directly in Excel.

🟩 Sum highlighted budget cells
🟥 Count flagged problem cells

Convert Text Dates to Real Excel Dates

Fix messy dates so Excel can sort and calculate them correctly.

"MARCH 15 26"
 ↓
15-03-2026 (or 03-15-2026 in US-format)

Advanced Sorting Beyond Excel

Sort text and data in ways Excel normally cannot.

Excel:
Version 1, Version 10, Version 2
 ↓
ASAP Utilities:
Version 1, Version 2, Version 10

Convert Numbers Stored as Text to Real Numbers

Fix imported numbers and numbers with leading zeros so formulas and calculations work correctly.

SUM returns 0
 ↓
calculations work again

Insert Dates from a Calendar Popup

Select dates visually and avoid typing mistakes.

Find the first Monday of the month
 ↓
select it from a calendar

Fix Trailing Minus Signs

Convert accounting-style negatives into real Excel numbers.

250-
 ↓
-250

Select Dates by Weekday or Month

Quickly select dates based on weekdays, months, quarters, and more.

Find all Q4 invoice dates
 ↓
copy them to a new report

Fix Reversed Positive and Negative Values

Correct debit and credit values in imported financial reports.

Credits imported as positive values
 ↓
corrected in one step

Create a Clickable Worksheet Index

Navigate large workbooks using an automatically generated index sheet (TOC).

50 worksheets
 ↓
1 clickable overview page

Split Data into Multiple Worksheets

Automatically create separate worksheets based on grouped cities, departments, categories, or row counts.

Sales report grouped by city
 ↓
separate worksheet for each city

Bulk Rename Worksheets

Rename many worksheets instantly instead of editing them one by one.

Sheet1, Sheet2, Sheet3...
 ↓
Sales, Budget, Forecast...

Export Worksheets as Separate Files

Save every worksheet as its own Excel, PDF, or CSV file in one step.

12 worksheets
 ↓
12 separate PDF reports

Fix Excel's Incorrect Last Cell

Restore normal Ctrl+End behavior and reduce oversized worksheets.

Ctrl+End jumps far beyond your data
 ↓
Ctrl+End jumps to the end of your data

Sort All Worksheets in One Step

Organize worksheet tabs alphabetically, numerically, or by tab color for easier navigation.

unsorted worksheet tabs
 ↓
sorted by name, number, or color

Unprotect Multiple Worksheets at Once

Remove worksheet protection from multiple sheets or an entire workbook in one step.

25 protected worksheets
 ↓
all sheets ready to edit

Create Multiple Worksheets from a List

Create dozens of worksheets instantly from a list of names in your cells.

Week 01 to Week 52
 ↓
52 worksheets created automatically

Remove Leading, Trailing, and Extra Spaces

Clean up imported or copied data instantly without formulas or manual editing.

"  Sarah   Johnson  "
 ↓
"Sarah Johnson"

Convert Numbers Stored as Text to Real Numbers

Fix numbers that Excel refuses to recognize properly.

"125" (text)
"00495" (text)
 ↓
125 usable in formulas and sorting
495 usable in formulas and sorting

Extend Selection to the Lowest Used Row

Extend your selection downward to the last used row, even when your data contains empty cells.

Ctrl+Shift+↓ stops too early
 ↓
selection extended to last used row

Change Text to UPPERCASE Without Formulas

Convert imported or inconsistent text to clean uppercase formatting instantly.

inv-eu-2048
 ↓
INV-EU-2048

Delete All Empty Rows

Remove empty rows from large datasets instantly.

Data with hundreds of blank rows
 ↓
clean compact data

Select Cells Using Advanced Criteria

Quickly select cells by color, type, formula, content, formatting and more.

find all yellow cells
 ↓
matching cells selected instantly

Add Text to Beginning and/or End of Selected Cells

Quickly add labels, prefixes, suffixes, or other text to large lists of cells.

261001
240259
 ↓
SKU-261001
SKU-240259

Highlight Each Set of Duplicates with a Different Color

Quickly spot and review duplicate values across your data.

duplicate entries across your data
 ↓
shown in matching colors

Fill Blank Cells with Value from Above

Prepare incomplete lists for sorting, filtering, reports or pivot tables in one step.

Sales
(empty cell)
(empty cell)
(empty cell)
Marketing
 ↓
Sales
Sales
Sales
Sales
Marketing

Export Worksheets as Separate Files

Turn one workbook into dozens of Excel, PDF, CSV, JSON, or delimited text files in one step.

Sales.xlsx
 ↓
12 separate report PDF files

Split Data into Multiple Worksheets

Automatically create separate worksheets based on grouped cities, departments, categories, or row counts.

Sales report grouped by city
 ↓
separate worksheet for each city

Create a Worksheet Index

Create a clickable overview to quickly navigate large workbooks.

48 worksheets
 ↓
1 clickable overview

List File Names and Properties from Folder

Turn a folder into a searchable Excel file list with properties and metadata.

project folder with hundreds of files
 ↓
organized Excel overview

Insert Dates from a Calendar Popup

Pick dates from a real calendar popup directly inside Excel instead of typing them manually.

Need the first Monday of next month
 ↓
pick the date from a calendar

Sum or Count by Font or Cell Color

Count or sum cells based on their color directly in Excel.

🟩 Sum all green cells
🟥 Count all red cells

Unprotect Multiple Worksheets at Once

Remove worksheet protection from or apply protection to multiple sheets or an entire workbook in one step.

25 protected worksheets
 ↓
all sheets ready to edit

Sort All Worksheets in One Step

Organize worksheet tabs alphabetically, numerically, or by tab color for easier navigation.

unsorted worksheet tabs
 ↓
sorted by name, number, or color

Add New Formula Powers to Excel

Get 38 powerful new worksheet functions that extend Excel's built in formulas. Count or sum by color, retrieve file paths, sheet names, comments, or hyperlinks, count words, spell out numbers, and much more directly in your formulas.

€ 142.23
 ↓
One Hundred Forty-Two Euros and Twenty-Three Cents

Select Cells Using Advanced Criteria

Quickly select cells by color, formula, content, formatting, dates, errors, comments, and more. For example, you can select cells with bold formatting or dates from a specific month or quarter.

find all red cells
 ↓
matching cells selected instantly

Designed by Excel users for Excel users.
Practical tools many Excel users wish were built into Excel.

Save Time in Excel. The Easy Way.

ASAP Utilities helps you save time and do what Excel alone can't.

You can get started right away. No training needed.

Most users start with a few tools. Many end up using ASAP Utilities daily.

Used by teams in 28,500+ organizations.