Skip to main content

Types of Data You Can Clean

These are the data types currently supported. We’re working on expanding what you can clean next!

Updated this week

Phone Numbers

  1. US Standard: (123) 456-7890

  2. Slash separators: 123-456-7890

  3. Dot separators: 123.456.7890

  4. No separators: 1234567890

Dates

  1. MM/DD/YYYY

  2. MM/DD/YY

  3. M/D/YY

  4. DD/MM/YYYY

  5. DD/MM/YY

  6. D/M/YY

  7. YYYY/DD/MM

  8. YY/DD/MM

  9. YYYY/D/M

  10. MM.DD.YYYY

  11. DD.MM.YY

  12. YYYY.MM.DD

  13. YY.M.D

  14. YYYY-MM-DD

  15. DD-MM-YY

  16. M-D-YYYY

  17. YY-MM-D

  18. MM DD YYYY

  19. DD MM YY

  20. YYYY MM D

  21. YY M D

  22. MMDDYYYY

  23. DDMMYY

  24. YYYYMMDD

  25. YYMD

  26. Mon Day, Year

  27. Day Mon, Year

  28. Mon Day, Year

Addresses

  1. Title Case: 123 Main St, Anytown, CA 12345

  2. Lowercase: 123 main st, anytown, ca 12345

  3. Uppercase: 123 MAIN ST, ANYTOWN, CA 12345

Cities

  1. Title Case: New York

  2. Lowercase: new york

  3. Uppercase: NEW YORK

  4. Abbreviation: NY

  5. Abbreviation w/ Periods: N.Y

Names

  1. First Name Last Name in Title Case: John Smith

  2. Last Name, First Name in Title Case: Smith, John

  3. First Initial. Last Name: J. Smith

  4. Uppercase: JOHN SMITH

  5. Lowercase: john smith

Currency

  1. Symbol first: $ 9,999.99

  2. Before amount: USD 9,999.99

  3. After amount: 9,999.99 USD

  4. Before amount: US Dollars 9,999.99

  5. After amount: 9,999.99 US Dollars

Did this answer your question?