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



Column4=Postal Code


In this example shown it will be like this:

Column1=Street=Knutton Lane



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.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Captura de dados na web, Busca na Web

Veja mais: 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

Acerca do Empregador:
( 48 comentários ) Barcelona, Spain

ID do Projeto: #18930276

Concedido a:


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 Mais

$40 USD em 2 dias
(9 Comentários)

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 Mais

$40 USD em 1 dia
(3 Comentários)

37 freelancers estão ofertando em média $104 para esse trabalho


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 em 1 dia
(276 Comentários)

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 dias
(404 Comentários)

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 Mais

$50 USD em 1 dia
(434 Comentários)

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 em 1 dia
(251 Comentários)

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 dias
(280 Comentários)

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 Mais

$250 USD in 3 dias
(76 Comentários)

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 Mais

$100 USD em 1 dia
(285 Comentários)

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 dias
(163 Comentários)

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 Mais

$155 USD in 3 dias
(91 Comentários)

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 Mais

$45 USD em 1 dia
(117 Comentários)

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 Mais

$100 USD em 1 dia
(146 Comentários)

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 em 1 dia
(101 Comentários)

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 Mais

$85 USD em 1 dia
(105 Comentários)

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 Mais

$250 USD in 2 dias
(50 Comentários)

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 Mais

$100 USD in 3 dias
(66 Comentários)

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 Mais

$155 USD in 3 dias
(93 Comentários)

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 dias
(30 Comentários)

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 Mais

$100 USD em 1 dia
(20 Comentários)

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: Mais

$155 USD in 2 dias
(11 Comentários)

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 dias
(48 Comentários)