Phone numbers lost their leading zero and the formats are inconsistent, so sends get rejected

Built!

Contact Format Cleanup checks numbers from a file or pasted column, shows candidates and errors, and applies only the fixes you choose.

Current workflow

Most people fix lists by eye — inserting hyphens one number at a time and counting digits to restore a missing leading zero by hand. A common shortcut is a single custom Excel format (000-0000-0000), but Korean phone numbers don't all have the same length — mobile numbers starting with 010 are 11 digits, Seoul 02 numbers are 9–10 digits, and regional area codes (031–064) are 10–11 digits — so one fixed format breaks as soon as different types are mixed. Nested TEXT, LEFT, and MID formulas can do it too, but maintaining them across a long list becomes a job of its own. The root cause is that Excel treats a digits-only value as a number and drops the leading zero. Mix in inconsistent separators — some people type hyphens, others dots — and bulk message or notification uploads can be rejected for format errors.

Solution

Clean Phone & ID Formats

How to use

1. Upload an XLSX, XLS, CSV, TSV or TXT file, or paste the column you want to clean (phone numbers, business registration numbers, postal codes, emails). 2. Choose how to format it — add hyphens, remove hyphens, and so on. 3. Review the leading-zero restore candidates and format errors, and choose the value to apply in each cell. 4. Download the Excel file with your choices applied, and check the original sheet and the other columns.

Example

- Input: a 50-row list mixing inconsistent hyphens and phone numbers that lost their leading zero (for example, 01012345678 stored as 1012345678) - Result: the list with each number's type identified by length, zero-restore candidates shown, and hyphens unified using the values you confirm — with malformed cells flagged separately. Business registration numbers are checked for all 10 digits plus the checksum, and postal codes follow the current 5-digit system.

Open tool
View details
Limits
- A number whose length matches no known pattern is not "fixed" by guessing; it's flagged as an error. - Emails are checked for format (structure) only. Whether mail actually reaches the address can't be verified.
Cost type
Free

A format check only tells you a value is well-formed, not that it's real. A business registration number can pass the digit count and checksum test and still not correspond to an actual registered business — confirming that requires a separate lookup with the tax authority. There's also a trap after cleanup: when you paste the cleaned results back into Excel, the leading zero can disappear all over again. The tool fixed the value, but the destination can break it once more, so set the target column to Text format first, or prefix values with an apostrophe (') to protect them.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in