Manually correct US addresses in Excel file
$100-300 USD
Paid on delivery
Purpose of Work
• We have rough address and company name data and we need to clean it. Unfortunately, this is largely a manual process
• To the extent the information is available have: 1) cleaned Company name; 2) Contact name (relatively rare); and 3) Address (all in one column)
• The nature of the work—using judgment regarding names and addresses makes only some of this work capable of being automated
Requirements to do the work:
• Strong familiarity of US addresses
• Excellent english
• Strong knowledge and comfort with working in Excel
• Knowledge of basic Excel short-cuts (cut, paste, etc.)
• Ability to work at least 10 hours per week
What needs to be done
Company Name (column E in yellow)
• The company name is currently composed of the website url with the “www” and “.com” truncated. As a result, there are no spaces, when there often should be.
•The Logic:
o If the address info in column G also has a company name replace the contents of what is in the Company name field with that
o If there is company name in the address field, look at the truncated company URL and if appropriate apply spaces and capitalize if necessary (note: you can use the “proper” function in excel to automate capitalizing)
Address (column G in Blue)
•The Address info is very rough. Here is the logic to fix it
o Columns G, H, I, through column P have potential address. Look at column D (the location of the phone number) to guide the decision of which address to use.
o Once the proper address has been identified (if there is one) clean it up by removing non-address related info (such as company names, other text, phone numbers etc.)
Contact Name (column F in Green)
• This will happen less often, but sometimes an individual’s name will be identified in the address. If this happens, but that name in the contact name column.
If selected I will send you a file with 20,000+ Addresses to clean. Please provide a bid for 20 hours worth of data cleaning work.
Project ID: #197375
About the project
Awarded to:
62 freelancers are bidding on average $185 for this job
Professional data entry and data processing, I'm wroking in a BPO company, doing some work like this, I can do this well, looking forwards to work with you. thank you.
I am a clerical professional with over ten years of experience. Past positions include that of Data Analyst for Sprint Nextel. I have college and professional education and knowledge of Excel and all of its functions. More
Dear SIR/MADAM, I am looking for Data Entry Conversion work. I have 6 years experience in data entry field. Trust me that I will give you quality work and speed. Please check you PMB. Thanks
Hello and thank you allowing for our company. AcmeSoft is an Indian Web Development and web design company that activates both on the local and foreign market, providing its customers with visual concepts and eye catch More
