Clean Up and Standardize Phone Numbers in Excel Data – Upwork

I have an excel file with contacts that need to be imported into another system.

I need an expert to clean up and standardise the phone numbers in the data and convert the file to CSV

The requirements are:
– Make sure all numbers start with a country code and +. E.g. +27766851000
– Export the file to CSV

The current problem with the data is that numbers use different formats.
E.g.
South Africa +27766851000 correct format
South Africa 002776851000 wrong
South Africa 0766851000 wrong
South Africa (+27)76851000 wrong

Where there is a number without a country code and the country is not specified, you can remove the number.

The file has 5,374 entries and most of them are correct.

Let me know how long it will take you and your price for the project.
Please don’t send me a generic application as I will not consider it.
To ensure you read this and you pay attention to detail please start your application by saying your FAVOURITE COLOR.

Hourly Range: $5.00-$25.00

Posted On: January 15, 2022 11:20 UTC
Category: Data Entry
Skills:Data Entry, Microsoft Excel

Country: South Africa

click to apply
Read More
All jobs | upwork.com

Scroll to Top