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, 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

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

Proje NO: #197375

Seçilen:

LK1811

Please check PM

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

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

JordanEnt

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

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

Please check PMB for details, Thank You

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

please read pm

in 5 gün içinde225$ USD
(12 Değerlendirme)
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.

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

please see pm thx

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

Hi, Please PMB for bid details. Thanks.

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

Please see PM for details.

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

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

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

Kindly see pmb.

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

Please see PMB

in 5 gün içinde100$ USD
(9 Değerlendirme)
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. Daha fazlası

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

Please see detail on PMB. Regards

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

checked, its very easy for me.

in 3 gün içinde240$ USD
(4 Değerlendirme)
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. Daha fazlası

in 10 gün içinde100$ USD
(2 Değerlendirme)
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

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

We are very interested to do this. Shiv Rajput

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

Hello, Please view PMB, Thx.

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

Please see PM for details of bid.

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

Please check your PM for details. Thank you.

in 5 gün içinde300$ USD
(1 Değerlendirme)
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 Daha fazlası

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