Devam Ediyor

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.

Beceriler: Veri Girişi

Daha fazlasını görün: correct addresses excel, excel correct address, excel correct addresses, proper addresses excel, www excel, what is manual data entry, what is in, we excel, per h, numbers function, function numbers, excel &, available .com addresses, automated logic, experienced using excel, addresses excel, companies excel file, n excel, what happen, US phone Number, strong g, P&G, names and addresses, lk1811, info g

İşveren Hakkında:
( 46 değerlendirme ) San Francisco, United States

Proje NO: #197375



Please check PM

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

62 freelancer bu iş için ortalamada 185$ teklif veriyor


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

in 10 gün içinde150$ USD
(53 Değerlendirme)

Please check PMB for details, Thank You

in 5 gün içinde150$ USD
(77 Değerlendirme)

please read pm

in 5 gün içinde225$ USD
(12 Değerlendirme)

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.

in 7 gün içinde100$ USD
(21 Değerlendirme)

please see pm thx

in 10 gün içinde300$ USD
(12 Değerlendirme)

Hi, Please PMB for bid details. Thanks.

in 7 gün içinde120$ USD
(9 Değerlendirme)

Please see PM for details.

in 4 gün içinde200$ USD
(8 Değerlendirme)

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

in 7 gün içinde300$ USD
(2 Değerlendirme)

Kindly see pmb.

in 30 gün içinde200$ USD
(6 Değerlendirme)

Please see PMB

in 5 gün içinde100$ USD
(9 Değerlendirme)

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. Daha fazlası

in 5 gün içinde150$ USD
(1 Değerlendirme)

Please see detail on PMB. Regards

in 15 gün içinde295$ USD
(1 Değerlendirme)

checked, its very easy for me.

in 3 gün içinde240$ USD
(4 Değerlendirme)

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. Daha fazlası

in 10 gün içinde100$ USD
(2 Değerlendirme)

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

in 10 gün içinde100$ USD
(1 Değerlendirme)

We are very interested to do this. Shiv Rajput

in 10 gün içinde270$ USD
(3 Değerlendirme)

Hello, Please view PMB, Thx.

in 10 gün içinde200$ USD
(4 Değerlendirme)

Please see PM for details of bid.

in 5 gün içinde250$ USD
(2 Değerlendirme)

Please check your PM for details. Thank you.

in 5 gün içinde300$ USD
(1 Değerlendirme)

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 Daha fazlası

in 7 gün içinde270$ USD
(1 Değerlendirme)