Transfer contacts from word to excel

Closed

This job consists of moving contact information from a variety of lists in word documents to a single excel form. We have roughly 380 lists of contacts, each list could have anywhere from 5-30 contacts. Contact information in the list is not in a consistent format, some entries contain a lot information and some just names of people or companies. We need all this compiled into a single excel sheet so we can upload it into a new database program. Attached is a sample list and a sample excel file. The contacts are currently organized by the title of the lists and the same contact can be in several different lists. Our objective is to have a single entry per contact in the excel list.

The excel file is broken into two sections: Word Doc Title and Contact Information. The Word Doc Title section only contains information in the title of the word doc and the Contact Information section only contains information from the contact info inside the word doc. The titles of the lists vary and include up to three different pieces of information: the type of real estate, the type of capital, and the geography. Since contacts can be in multiple lists there can be multiple entries for real estate type, capital type, and geography under the same contact. For example an entry could have several columns such as Real Estate Type 1, Real Estate Type 2, Real Estate Type 3, etc. Each column only has one entry.

Here's a list of Real Estate Types:

Apartment (multifamily is apartment), Retail, Office, Industrial, Hotel (hospitality is hotel), Land Development, Land, Amusement Park, Gas Station, Golf, Hospital, Health Care, Medical Office, Building, NNN, Condominium (or Condo), Owner User, Parking, Pre-development, Pre-entitlement, Resort, Senior Care, Assisted Living, Skilled Nursing, Self Storage, SFR, Student Housing, Workforce housing, Church, Core, Core Plus, Value Add, Infrastructure, Note Purchase

Here's a list of Capital Types:

Construction, Equity, Life Insurance or life co, life company, life), Bridge, Agency, DUS, FHA, Senior, Mezzanine (or Mezz), Preferred Equity, Bank, Hard Money, Permanent, DIP, Full Capital Stack, Factoring, Opportunity, High Leverage, High Yield, Non recourse, note hypothication

Geography is obvious.

So a word doc with the title "Land Opportunity Mezz" would mean that every contact in the file would have an entry for "Land" in the Real Estate Type Column, "Opportunity" in the Capital Type 1 column, and "Mezzanine" in the Capital Type 2 column. There's no limit to the number of columns for each contact as long as every contact name is only listed once. The only time that a contact would be listed more than once is if the name is listed under more than one company. In that situation duplicate the entry with the same info except a different company name. Please put any duplicate entries in bold.

Since not all contact info is complete just input the available information and leave anything missing blank. So if the email and phone are listed but no address, just leave the address cell empty. If a cell phone or mobile phone number is listed put in the mobile phone column, if not just put the phone numbers in the phone columns.

Ignore word docs that don't have any of the Real Estate Types or Capital Types listed above in the title.

Please let me know what you would charge for this work and the estimated completion date. If you're selected, I'll send you a single word doc and I'd like to see you transfer the data. If it looks correct we'll have you do the work. If you have questions please email them.

Skills: Data Entry, Excel

See more: number data entry, what is medical data entry, what is hospitality, what is a data entry form in a database, what is a condo, what do you mean by data entry, the gas company, stack real life example, sample word form, sample stack program in c, people from above, nursing job, name transfer, mobile life insurance, mobile gas, medical data entry job, medical data entry companies, life estate, land a job, industrial bank, health insurance data entry work, gas office, excel job agency, equity bank, duplicate data entry

Project ID: #4180773

65 freelancers are bidding on average $91 for this job

FINGERRPRINT

Gone through your attachment, we are interested in working in your project. Please check your inbox.

$200 USD in 10 days
(116 Reviews)
7.1
Innovative116

Hi. I am interested in the project. Please check private message for more details. Thank you

$69 USD in 1 day
(85 Reviews)
6.8
opu00

I have read your whole project description and looked through your sample word and excel file and I think I can handle this project with care and Accurately. Can you please send me a word file so that I can submit some More

$120 USD in 7 days
(154 Reviews)
6.3
vsona

Greetings! Thank you very much for giving us an opportunity to bid for your project. Please refer to PMB for our detailed bid.

$125 USD in 4 days
(64 Reviews)
5.8
jeweljitu

Hello, Very Nice job. I read your job posting with interest.please check your inbox. Thank & Regards Jewel

$45 USD in 2 days
(94 Reviews)
5.8
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$98 USD in 9 days
(56 Reviews)
5.7
Webxpert4u

Hi, Would love love to work on this project. Thanks, Kiran

$100 USD in 1 day
(71 Reviews)
5.4
pkcyber

See your PMB

$50 USD in 1 day
(18 Reviews)
5.1
binaryromel

===== Understand your project. Do same job previous. Check PM for details. =====

$50 USD in 2 days
(45 Reviews)
5.1
deepbluetech

I can take on the job. Let me know.

$100 USD in 4 days
(65 Reviews)
5.0
Nhcuong

hi, I can do it with high accuracy. Best regards, Cuong NH

$200 USD in 15 days
(19 Reviews)
4.9
BrothersTeam

Hello Pls check the private message for detailed proposal from the expert. Thanks

$30 USD in 1 day
(60 Reviews)
4.5
Shah101

Hello, I am ready to start, please check pmb, thanks.

$30 USD in 1 day
(62 Reviews)
4.5
bluefox4ever

Dear Hiring Manager, I'm ready to start the project. Please read PM for details. Regards, Oliver

$100 USD in 7 days
(12 Reviews)
4.4
rabiasagi

hi, highly experienced worker here!

$180 USD in 10 days
(22 Reviews)
4.3
Nevergivesup

plz check pm

$30 USD in 1 day
(11 Reviews)
4.1
amraf

I am willing to start the project immediately.

$100 USD in 7 days
(6 Reviews)
3.8
pakee

Ready to start immediately. Consider it done with 100% accuracy and neatly. I am IT professional and have extensive expertise and experience in word and excel sheets. I can do it in 2 days with 100% accuracy and time d More

$55 USD in 2 days
(19 Reviews)
3.8
cosconeaionut

Hi I can do this . Quality is assured!

$40 USD in 1 day
(6 Reviews)
3.6
afua23

I can get this done for you with utmost accuracy. I have read the entire description and taken a look at the attached file and convinced myself that i can get this done right

$80 USD in 2 days
(13 Reviews)
3.5