Clean/Edit 5 Excel Datasheets (conform phone #, city names)
$30-250 USD
Completed
Posted over 12 years ago
$30-250 USD
Paid on delivery
so basically
data provided to you in EXCEL
DATA FIXING
for the next, sometimes the easiest is to sort the excel spreadsheet by the column being worked on
that way you can see all the records and those which have CLOSE but NOT EXACTLY ALIKE entries
most important is not to make it perfect but to fix as much as possilbe
1) Telephone number
some telephone numbers show up without + and country code
sometimes no country code
sometimes no + sign
all the numbers should be dial able with + and country code number
desired format = + (country code) + (number)
so for example there are number
431 522 6636
so should be formatted like this (with +country code in front)
+701 838 4445
for example all the US number should have +1 in front of them, most don't
this should be done with an excel auto manipulation rather than by hand (by the way) save a lot of time
(let's discuss if not clear)
best to sort the table by country to help on this one
2) city name , region names sometimes are not consistent
for city, country please make sure that
for example there is a
BRUXELLES
and
BRUSSELS
which is the same
choose one and make all the same
3) ZIP CODE
same for zip codes
sometimes F-75007
but correct is probably 75007 only is sufficient
4) Special Characters
special characters
like
é è ñ
do not display properly in our system
lookout for garbled characters
if you see them simplify them down (take away accents)
DATA ADDING
5) wherever there is no latitude/longitude information, columns B and C
please add longitude and latitude information for the address provided
there are a number of resources to do that
[login to view URL]
[login to view URL]
Dear roguescribe,
Highly experienced team of data processing operators and web researchers,please refer to your private message box for further details.
thanks.
I am a 1st class degree holder in Computing and Information Systems at London Metropolitan University, UK. I am with 5 years experience in data entry and online researches. I have done so many similar projects and I am happy to do this for you. Please refer PM for more details. Thanks in advance!
Dear Hiring Manager,
I want to do this "Clean/Edit 5 Excel Datasheets (conform phone #, city names)" project now, let's start immediately. I have read the job description. Please send me the excel files and more details of the job. I'm still a new freelancer here in FREELANCER so please give me a chance.
Regards,
Oliver