In Progress

Manually correct US addresses in Excel file

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.

Skills: Data Entry

See more: correct addresses excel, excel correct address, excel correct addresses, proper addresses excel, we excel, per h, numbers function, function numbers, automated logic, experienced using excel, addresses excel, companies excel file, n excel, what happen, strong g, lk1811, info g, g cleaning, excel us, excel function, excel automate, do excel, file cut paste, cut paste file, function automate

About the Employer:
( 46 reviews ) San Francisco, United States

Project ID: #197375

Awarded to:


Please check PM

$100 USD in 3 days
(62 Reviews)

62 freelancers are bidding on average $185 for this job


Hello, I am very familiar with US addresses. Can be done with ease. Thanks.

$150 USD in 10 days
(53 Reviews)

Please check PMB for details, Thank You

$150 USD in 5 days
(77 Reviews)

please read pm

$225 USD in 5 days
(12 Reviews)

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.

$100 USD in 7 days
(21 Reviews)

please see pm thx

$300 USD in 10 days
(12 Reviews)

Hi, Please PMB for bid details. Thanks.

$120 USD in 7 days
(9 Reviews)

Please see PM for details.

$200 USD in 4 days
(8 Reviews)

Hello! please check pmb for details...thanks!

$300 USD in 7 days
(2 Reviews)

Kindly see pmb.

$200 USD in 30 days
(6 Reviews)

Please see PMB

$100 USD in 5 days
(9 Reviews)

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

$150 USD in 5 days
(1 Review)

Please see detail on PMB. Regards

$295 USD in 15 days
(1 Review)

checked, its very easy for me.

$240 USD in 3 days
(4 Reviews)

Hi, PatrickKahuna! I am very well versed with Excel and have an excellent command of the English language. I am very familiar with US addresses so I guess I can do this project without a hitch. Just keep in touch. More

$100 USD in 10 days
(2 Reviews)

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

$100 USD in 10 days
(1 Review)

We are very interested to do this. Shiv Rajput

$270 USD in 10 days
(3 Reviews)

Hello, Please view PMB, Thx.

$200 USD in 10 days
(4 Reviews)

Please see PM for details of bid.

$250 USD in 5 days
(2 Reviews)

Please check your PM for details. Thank you.

$300 USD in 5 days
(1 Review)

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

$270 USD in 7 days
(1 Review)