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.
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
Comments
Be the first to comment.