Standardise the formats in a file
Before importing into a CRM or payroll software, each column has to speak one language: phone numbers in one format, postcodes complete, emails in lowercase. Values that cannot be read are shown, not guessed.
What this tool does
- French phone numbers as "06 12 34 56 78" or international "+33612345678"; other international numbers kept.
- French postcodes on five digits, Corsica included (2A, 2B).
- Emails in lowercase, without spaces or "mailto:", invalid addresses flagged.
- SIRET and SIREN numbers grouped by three digits, proper names in title case.
What it does not do: Phone number formatting follows French conventions; foreign numbers are kept as they are when already in international format, and flagged otherwise. An email's validity is only checked on its form.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Fix a CSV file : Broken accents, everything in one column, lost zeros: a file Excel opens right the first time.
- Remove duplicates : On the columns you choose, optionally ignoring case, spaces and accents.
- Near-duplicates : "Smith Ltd" and "SMITH LTD.": the almost-identical duplicates, reviewed one by one.
- Clean text : Extra spaces, non-breaking spaces, line breaks, invisible characters, case.
- Convert text to numbers : "1,234.56 $", "(45.00)", "12.5-": real numbers that add up.