B2B Directory Data Cleansing

Замовник: AI | Опубліковано: 17.03.2026

I have a B2B company directory sitting in a set of Excel/CSV files. Each record includes the company’s name together with its full postal address, and at the moment too many of those addresses are wrong, incomplete, or formatted inconsistently. I need the entire list verified and standardised so that every row can be trusted for mail-outs, geo-analysis, and future CRM import. What I am after: • A cleaned copy of the original spreadsheet, still in .xlsx or .csv, with every address corrected, standardised to its local postal format, and clearly flagged if no authoritative match could be found. • A short summary sheet outlining the number of records processed, the number corrected, and any that remain unresolved. Feel free to use whatever address-validation resources you prefer—Google Maps API, national postal databases, or specialised cleansing software—as long as the final file opens cleanly in Excel and the addresses line up with official records. If you see obvious duplicate rows along the way, merging or removing them sensibly would be appreciated, but the priority is accuracy of the addresses themselves. I will provide the source files immediately on project start and am happy to answer schema questions quickly so you can move through the work without delay.