FREE DATA CLEANER
Turn mixed phone numbers into clean +94 records.
Paste numbers copied from chats, Excel or an old customer list. The tool removes common spaces and punctuation, normalises valid Sri Lankan mobile numbers and flags values that need review.
07X and 94 formatsBulk pasteCSV-ready output
BULK +94 CLEANUP
Paste the phone-number column.
0valid0needs review0duplicates
FREQUENTLY ASKED
Useful details before you continue.
Which numbers are accepted?
The tool recognises common Sri Lankan mobile formats beginning with 07, 947 or +947 and checks for the expected digit count.
Are contacts uploaded?
No. Formatting happens entirely in the page.
Will it remove duplicate numbers?
The output marks duplicates and keeps the first valid occurrence.
Can I paste directly from Excel?
Yes. Paste one number per row or a copied column; commas and semicolons are also accepted.
NEXT STEP
Keep the clean phone attached to customer history.
OrderMate uses the full +94 number as the primary customer identifier.