Færdiggjort

Excel task: standarize a list of addresses in excel (150.000 aprox.)

I'll provide a list of addresses in 1 excel column.

The addresses are formatted like this:

Knutton Lane<br> Newcastle-under-Lyme<br> Staffordshire<br> ST5 2GB<br> <a target="_blank" href="[login to view URL],-2.237987">Find on Google map

The task will consist in splitting the address in 4 columns:

Column1=Street address

Column2=City

Column3=County

Column4=Postal Code

Column5=Country

In this example shown it will be like this:

Column1=Street=Knutton Lane

Column2=City=Newcastle-under-Lyme

Column3=County=Staffordshire

Column4=Postal Code=ST5 2GB

Column5=Country=England...this is not appearing in the excel, it has to be filled with England/Wales/Scotland/Northern Ireland depending on the County (a list with all the towns/counties/Countries will be provided).

Issues to take into account:

1. This is not only a mechanic task (like splitting text inside <br> tags): some addresses will not have the data regarding street address or county or town or Postal Code. This has to be taken into account.

2. Names of cities: have to be standarized. For example: "Newcastle-under-Lyme" could appear in the list as "Newcastle under Lyme" or "newcastle-under-lyme". All the city names have to be standarized. The same for the names of counties.

3. Names of counties have to be filled if they are empty. A list of cities/counties will be provided, see it attached.

The task has to be done fast: in 1 day or 2 days maximum.

Evner: Dataindførsel, Databehandling, Excel, Web Skrabning, Websøgning

Se mere: excel normalize data 0 to 1, excel address book database, excel standardize between 0 and 1, excel normalize data to 100, how to create a google map with excel data, create map from excel data free, standardize formula in excel, plot addresses on google map from excel, excel customer projects list, cut paste list contacts excel internet, excel project contacts list, list contact excel, list dentists excel, list contactpersons excel, convert list addresses excel, list addresses excel, excel list addresses copy paste, enter list addresses excel zillow, mail list insert addresses excel, list hotel email addresses excel

Om arbejdsgiveren:
( 48 bedømmelser ) Barcelona, Spain

Projekt ID: #18930276

Tildelt til:

emdad4535

Hi There, Hope you are fine today! Please share more details in chat, I am able to start the work now. I am promising for my best work quality with on-time delivery. I am hardworking always and passionate about to wo Flere

$40 USD in 2 dage
(9 bedømmelser)
3.1
rgsiccion

Hi, I could easily provide you with the standardized list within a few hours. I'll start working on it as soon as I get accepted for the job. This shouldn't take me long and you could be sure that most of the fuzzy Flere

$40 USD på 1 dag
(3 bedømmelser)
2.2

37 freelancere byder i gennemsnit $104 på dette job

livegoodlife

Hello Sir I have seen the excel file and i hope is a type of work few hours, If everything's are fine in the given file. Thanks

$50 USD på 1 dag
(276 bedømmelser)
7.9
mirniyazuddin92

Hi there, I can standardize a list of addresses in excel. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$150 USD in 3 dage
(404 bedømmelser)
7.9
Dhruvika111

Greetings! Dear sir,I believe honesty is the best policy. My main target is to supply high-quality work with reasonable cost. I am expert on Email Collection, Data Entry, Internet Research. I have more than 4 years Flere

$50 USD på 1 dag
(434 bedømmelser)
7.9
sergiuloghin

Hello! I can finish the task in 1 day. I can start now. I will standardize your file without error. You will not be dissapointed, I have a big 34% rehire rate. Thank you!

$66 USD på 1 dag
(251 bedømmelser)
7.6
sohandas

Hello, this is strictly data manipulation task and i can do this using python, can you please message me so that we can discuss more? well i need 1-2 days MAX, thanks!

$200 USD in 2 dage
(280 bedømmelser)
7.3
dgled

I am a financial expert and guru in Excel/VBA/Macro. I have the skills to upload databases from text files into Excel and to clean them automatically and/or to separate info in some columns. I am an expert and guru in Flere

$250 USD in 3 dage
(76 bedømmelser)
7.0
leelakalidas32

Hello Sir, I have read your project details and i think i am the right person which you are looking for.i have done many same project, you can check my [login to view URL] is my guarantee,if you want free samples then p Flere

$100 USD på 1 dag
(285 bedømmelser)
7.1
hdlong66

Hello, I can help to standardize your list of addresses in excel as described. Please drop a PM if you’re interested. Best regards, Hoang

$100 USD in 2 dage
(163 bedømmelser)
7.0
polarjin2017

Hello? How are you? I have seen the project - "Excel task: standarize a list of addresses in excel (150.000 aprox.)." I have been working in these fields((Data Entry, Data Processing, Excel, Web Scraping, Web Searc Flere

$155 USD in 3 dage
(91 bedømmelser)
6.7
shafaqat11

Hello Sir, Thank you for posting the project. First! Your satisfaction is my top priority. I am interested in it. If you give me chance then i can start right now and able to provide best results. In short, I cou Flere

$45 USD på 1 dag
(117 bedømmelser)
6.2
datadexterous

Hello there! I have read the project description carefully and would like to be considered for your project. I can filter & format the data according to the provided guideline with 100% accuracy. I have a team of Flere

$100 USD på 1 dag
(146 bedømmelser)
6.3
seoguru17

I read your requirement and I can get this done with in a day. Please award the job and I will send you the output file

$55 USD på 1 dag
(101 bedømmelser)
6.4
Gonesh

Dear sir I perused your job offer and see the attached files. I already did 90% work is complete to your file. I'll provide sample work in interviews. I am able to complete this task within your mean time. Lookin Flere

$85 USD på 1 dag
(105 bedømmelser)
5.8
KavTan

Hello there, I understand that you require to split data, clean city names and add missing details in a large excel file. I am a professional having Advance Excel skills and can complete your task in 48 hours. L Flere

$250 USD in 2 dage
(50 bedømmelser)
5.7
pm9887

Hi, As per given details Its data entry task. I have great experience in all kind of backend support I am good in lead generation, internet research, market research, data entry, data processing and all kind of backe Flere

$100 USD in 3 dage
(66 bedømmelser)
5.6
Stephenrajs

Hi there, I have a Team. I can do it. I have done many related projects like this. If you are provide this work, it will help my career also. Give me a chance to do this. Waiting for your precious reply. Thank Flere

$155 USD in 3 dage
(93 bedømmelser)
5.0
PallaviH

Hi, I gone through task description and attached excel and csv. I understood your requirement. I can do this job perfectly within budget and within time frame. thanks Pallavi

$55 USD in 2 dage
(30 bedømmelser)
4.8
marionadersal

I have checked the attached files .Hello Esteemed Client I am very organised person, I am efficient in Microsoft Excel. I am a hard worker, type quickly, and can ensure your data is entered accurately I am very accura Flere

$100 USD på 1 dag
(20 bedømmelser)
4.4
OutsourceMan

Hello Sir/ Mam, My name is Neha from “Hire Wordpress Experts”. We are the team of 18+ employees and over past 10 years We are in the top 4% of freelancers based on our earnings and reviews. We specialize in: Flere

$155 USD in 2 dage
(11 bedømmelser)
4.8
durgapukamalakar

Hello Sir/Madam Data is in tagging mode. I can give you the output in required mode on deadline time (2-3 days). Please come to chat to discuss more. Thank you.

$150 USD in 3 dage
(48 bedømmelser)
5.0