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.

Beceriler: Veri Girişi, Veri İşleme, Excel, Web Scraping, İnternet Araştırması

Daha fazlasını gör: 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

İşveren Hakkında:
( 48 değerlendirme ) Barcelona, Spain

Proje NO: #18930276



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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 40%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(9 Değerlendirme)

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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(3 Değerlendirme)

Bu iş için 37 freelancer ortalamada $104 teklif veriyor


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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(276 Değerlendirme)

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 gün içinde
(404 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(434 Değerlendirme)

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!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(251 Değerlendirme)

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 gün içinde
(280 Değerlendirme)

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 Daha Fazla

$250 USD in 3 gün içinde
(76 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(285 Değerlendirme)

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 gün içinde
(163 Değerlendirme)

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 Daha Fazla

$155 USD in 3 gün içinde
(91 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(117 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(146 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(101 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(105 Değerlendirme)

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 Daha Fazla

$250 USD in 2 gün içinde
(50 Değerlendirme)

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 Daha Fazla

$100 USD in 3 gün içinde
(66 Değerlendirme)

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 Daha Fazla

$155 USD in 3 gün içinde
(93 Değerlendirme)

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 gün içinde
(30 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(20 Değerlendirme)

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: Daha Fazla

$155 USD in 2 gün içinde
(11 Değerlendirme)

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 gün içinde
(48 Değerlendirme)