Update excel database of approximately 3,500 contacts
- or -
Post a project like this4152
$$
- Posted:
- Proposals: 37
- Remote
- #193315
- Awarded
Virtual Admin Assistant, Data Entry, Data Extraction, SEO, Translation, Data research, Wordpress
Mumbai
321108329938274454285248306041307843321366326611326741372213368447369856
Description
Experience Level: Intermediate
Objective: To create one, detailed, database in Excel of approximately 3,500 contacts. Each contact will have 25 fields associated with it. The project should start immediately and be completed within 2 weeks (negotiable).
The primary database (.xlsx) with 3,246 contact names and addresses (currently 12 fields per contact)that needs updating with the following:
1. A second database (.docx)of 900 contact names and addresses that (a) needs to be crossed checked with the primary database and any contacts that are missing are on this secondary database and missing from the primary, need to be included in the primary. (b) Each of the 900 contacts on the secondary list belong to a trade association. This information needs to be added to the primary database in the relevant trade association field.
3. A third database (.xlsx) has 1436 contact names and addresses. (a) This needs to be crossed checked with the primary database and any contacts that are on this third database and missing from the primary, need to be included in the primary. (b) The information in 4 fields from the third database, needed to be added against the relevant contact in the primary database.
4. Each of the 3,246+ contacts will belong to one of 10 categories. 22% belongs to 1, 16% to another, 8% (?) to say 7 sub-sets of another, and the remaining 54% to another. This information needs to be included on the primary database.
5. Find the email addresses for the key contact at each organisation. 45% currently missing.
6. Update the 'county' field. Approximately 40% missing. The remaining address and postcode information is available.
7. The contact name in the primary database needs to be split into 4 fields: Contact salutation, Contact first name, Contact second name, Contact surname.
Please provide a fixed cost and timescale for completing the above task.
Information will be supplied in the form of .xlsx, .docx, and useful URLs which will help you find the information you need. I am readily available during the project to answer any queries should they arise.
The primary database (.xlsx) with 3,246 contact names and addresses (currently 12 fields per contact)that needs updating with the following:
1. A second database (.docx)of 900 contact names and addresses that (a) needs to be crossed checked with the primary database and any contacts that are missing are on this secondary database and missing from the primary, need to be included in the primary. (b) Each of the 900 contacts on the secondary list belong to a trade association. This information needs to be added to the primary database in the relevant trade association field.
3. A third database (.xlsx) has 1436 contact names and addresses. (a) This needs to be crossed checked with the primary database and any contacts that are on this third database and missing from the primary, need to be included in the primary. (b) The information in 4 fields from the third database, needed to be added against the relevant contact in the primary database.
4. Each of the 3,246+ contacts will belong to one of 10 categories. 22% belongs to 1, 16% to another, 8% (?) to say 7 sub-sets of another, and the remaining 54% to another. This information needs to be included on the primary database.
5. Find the email addresses for the key contact at each organisation. 45% currently missing.
6. Update the 'county' field. Approximately 40% missing. The remaining address and postcode information is available.
7. The contact name in the primary database needs to be split into 4 fields: Contact salutation, Contact first name, Contact second name, Contact surname.
Please provide a fixed cost and timescale for completing the above task.
Information will be supplied in the form of .xlsx, .docx, and useful URLs which will help you find the information you need. I am readily available during the project to answer any queries should they arise.
Kim B.
100% (2)Projects Completed
5
Freelancers worked with
4
Projects awarded
27%
Last project
29 Aug 2014
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies