I have an excel list of 7000+ locations in Germany.
I want to ensure the value of the field CITY in each record is standardised to one unique, correct value.
Some 830 records do not have a standardised value: those need to be changed on the excel file.
For example I have one record where the city has been entered as ABENDSBERG: the correct value should be ABENSBERG. The postal code can help you identify the correct value which should be present on a list of valid location names that i have taken from the national statistics institute.
I need a person that finds the correct value for the 830 records that have an incorrect value. So this is a relatively small task.
The person I am looking for is German mother tongue, speaks English fluently (I do not speak German well enough), is very familiar with Excel, is very thorough, accurate, patient, precise. I don't want a techie to write a script, i am looking for a person to do data scrubbing, one by one.
We will communicate over the phone, email, whatsapp, whatever works.
I expect this task to be completed in about 1 week or less. In fact it should not take more than a day based on previous experiences.
The file attached hopefully is enough to give an idea. Wrong value in H, correct value in K.