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:

LK1811

Please check PM

$100 USD in 3 days
(62 Reviews)
6.4

62 freelancers are bidding on average $185 for this job

JordanEnt

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

$150 USD in 10 days
(53 Reviews)
6.4
dataconsultants

Please check PMB for details, Thank You

$150 USD in 5 days
(77 Reviews)
5.5
mabbittc

please read pm

$225 USD in 5 days
(12 Reviews)
4.9
noreen

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)
4.5
soniamit

please see pm thx

$300 USD in 10 days
(12 Reviews)
4.3
Venkyb

Hi, Please PMB for bid details. Thanks.

$120 USD in 7 days
(9 Reviews)
4.1
RainbowSearches

Please see PM for details.

$200 USD in 4 days
(8 Reviews)
3.9
orangestudios

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

$300 USD in 7 days
(2 Reviews)
3.8
sureshmalankar

Kindly see pmb.

$200 USD in 30 days
(6 Reviews)
3.7
ITRACK

Please see PMB

$100 USD in 5 days
(9 Reviews)
3.6
barber64127

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)
3.5
ExactSystems

Please see detail on PMB. Regards

$295 USD in 15 days
(1 Review)
3.4
wincent

checked, its very easy for me.

$240 USD in 3 days
(4 Reviews)
3.3
lyza0327

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)
3.0
ritzpatel28

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)
2.9
Alphatec

We are very interested to do this. Shiv Rajput

$270 USD in 10 days
(3 Reviews)
2.7
dentryexp

Hello, Please view PMB, Thx.

$200 USD in 10 days
(4 Reviews)
2.5
TiareF

Please see PM for details of bid.

$250 USD in 5 days
(2 Reviews)
1.7
rjbeaulieu

Please check your PM for details. Thank you.

$300 USD in 5 days
(1 Review)
1.5
Acmesoftsolution

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)
1.6