In Progress

Clean/Edit 5 Excel Datasheets (conform phone #, city names)

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

[url removed, login to view]

[url removed, login to view]

Skills: Data Entry, Data Processing, Editing, Excel

See more: save lot, lookout, html spreadsheet example, html spreadsheet code, excel special, excel 16, dial code, excel city, take away, sort excel, save excel, longitude, format excel, excel us, excel html, edit so, clean code, excel table sort hand, data longitude, spreadsheet manipulation, number manipulation, city country excel, city code able, excel html special characters, region code

About the Employer:
( 12 reviews ) paris, United States

Project ID: #1141752

Awarded to:

dataconsultants

Please check PMB for details. Thank you

$50 USD in 1 day
(93 Reviews)
5.7

105 freelancers are bidding on average $71 for this job

pandeypriya2003

Lets start. Thanks

$200 USD in 5 days
(524 Reviews)
7.5
FINGERRPRINT

ready to start,

$100 USD in 5 days
(124 Reviews)
7.1
Toperfection

Dear roguescribe, Highly experienced team of data processing operators and web researchers,please refer to your private message box for further details. thanks.

$30 USD in 0 days
(52 Reviews)
6.8
diamond247

#### Expert here, Please see the PM for official details and professional quote ####

$40 USD in 0 days
(80 Reviews)
6.5
YourAssistant

{{(((Please read PM for further details)))}} …Thanks

$75 USD in 1 day
(99 Reviews)
6.1
greggfletcher

Hello, i have read the description very carefully, it looks like hard task, but i will be able to help you. Please contact me if interested. Regards.

$200 USD in 5 days
(28 Reviews)
5.9
RajHeartbeat

letz start..I can deliver this work within 24 hours maximum..just send me excel spreadsheet to start this job asap..Regards..Raj..!

$50 USD in 1 day
(57 Reviews)
5.7
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

$50 USD in 2 days
(40 Reviews)
5.6
yourjmr

Hi, Kindly check PMB. Thanks & Regards Joseph

$30 USD in 2 days
(95 Reviews)
5.4
Venicebrooks

Greetings, Ready to start. Please check your PMB. Thanks

$45 USD in 3 days
(19 Reviews)
5.4
simplicityq88

Hello friend, shall we start? :)

$30 USD in 1 day
(61 Reviews)
5.2
candida

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 More

$50 USD in 2 days
(17 Reviews)
5.1
jmddata

Let's Start.! :)

$90 USD in 3 days
(22 Reviews)
5.0
manageo

Hi, I can do it, please read the inbox for details

$35 USD in 1 day
(23 Reviews)
4.6
GoodResults

Hi, I am interested. Thanks

$40 USD in 4 days
(33 Reviews)
4.6
hemi

Please see more details on PMB. Thanks

$50 USD in 2 days
(17 Reviews)
4.5
Rajni0802

Please check PM. thanks..

$60 USD in 2 days
(15 Reviews)
4.6
bluefox4ever

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 det More

$50 USD in 3 days
(13 Reviews)
4.4
quality80

Ready to begin your project. This is my area of expertise. Please check pm!

$250 USD in 8 days
(1 Review)
4.0
MohabSystems

Kindly refer PMB. Regards, Mohab

$37 USD in 1 day
(14 Reviews)
3.8