Do some Excel Work.
$10-100 USD
Πληρώθηκε κατά την παράδοση
Take multiple *.csv files and merge the files. The files are exports from contacts in iPhone(s) and Microsoft Outlook 2013 using Google Business Apps.
The finished project should be a single *.csv file that can be imported to Outlook 2013 to update / replace all contacts.
(1) The file should match the attached template. All formatting should match standard United States English standards. Microsoft Outlook 2013 is the environment. The formats should be as follows:
1. Naming convention - should be a single first name, middle initial and last name - example Bob M. Smith A number in the name or special character is not acceptable. The first letter of the first and last name should be capitalized and then all other letters lower case. The middle initial is capital followed by a period ".". If there is a Title then it should be Dr. or Mr. or Mrs. or Ms. or Miss. etc. There should never be a Title without an ending "." period.
2. Address should be in the following format - #, ##, ###, ####, or ###### and Street Address, Suite ###, or #### Example – 1234 Main Street, Suite 200 or 12345 Main Avenue, Suite 2000 Never should there be another format and Avenue, Street, etc should always be completely typed out.
3. Zip code should be ##### or #####-#### Never another format.
4. State should be typed out in Full. Example – TX should be Texas or CA should be California
5. Country should be typed out completely. United States of America
6. If the address is listed twice or if the home is the same as the work address, please delete duplicates and leave only a WorkAddress. The default would be the WorkAddress data.
7. Every cell should use a uniform standard and prior to beginning the project we ask that you submit a proposed sample of how you would ultimately deliver a sample of rows/data. We will approve the sample.
8. Questions should be submitted at this time as well. Uniform standards are expected.
9. Cells / Columns that are phone numbers should be in the following format only (###) ###-#### If there is an extension then please add that extension in Column AG or the Business Phone 2 Column.
10. Anniversary (column AX) should be blank. Delete all anniversary cells.
11. Birthday (column BA) should be a date later than 01/01/1960. If before delete, if later than that date and a valid date please leave the data in the cell.
12. Email addresses should be listed one time. If a duplicate is listed in email 2 then please delete. Column BF, BG should remain in all cases. BI should show only Firstname and Lastname but never the email address. SMTP should be the default.
13. Column CD should be Normal, CE should be FALSE and CH should be Normal.
14. Please remove all duplicates and any questions regarding the data need to be directed to us in a single file listing question. Excel format of questions should be sent prior to starting the project.
15. Optional – use a script to test phone numbers and email addresses so we can confirm the emails are working emails and the phone numbers are working as well. Any test must be done so as to not interrupt the person or contact them directly.
The finished product is a single *.csv file that matches the template format exactly. No columns can be deleted only data removed, cleaned up or formatted. All data must comply with US standards for formatting when in question. Capital letters start each name, city, state, etc. Thank you
Ταυτότητα Εργασίας: #8277705
Σχετικά με την εργασία
40 freelancers κάνουν προσφορές κατά μέσο όρο $56 για αυτή τη δουλειά
how many csvs do u have in total? how many csvs do u have in total? how many csvs do u have in total? how many csvs do u have in total? how many csvs do u have in total? how many csvs do u have in total? how many Περισσότερα
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Περισσότερα
I have completed many projects in Excel. I have read your project description in detail. I will follow all the instructions given therein. You have not mentioned the total number of records involved. The cost would de Περισσότερα
interested to take this work, attached CSV form where data has to be collected could have given better idea about work/duration and bidding amount
I started working in Excel since the start of my career in 1998. MS Office used to come along-with Windows 95 installation at that time. I have experience in developing data enter/edit functionality in MS Excel using V Περισσότερα
Dear Employer, I saw the sample file. It can be done within few hours only. I had a same problem when i switch contacts from My Apple to MS Outlook. I used Excel Macro to do that. Hope I can reuse the code. Ple Περισσότερα
Hello, I want to help you with this job. I will not have much time in this week, but I will do my best to finish job in 7 days. I am cheap and good. Problem is only one - probably I will not finish in 3-4 days (holi Περισσότερα
We could handle your data entry job effectively and efficiently. you can contact us with more information about the job. Thank you
I'm a very fast worker, all will be done manually. If you do this often, however, we could look into automating the process via Software.
i will complete this task as soon as possible as per your expectation without any kind of error in this project.
Hello, I could do this job, but only one question: how many files are you talking about? Thanks Luca Villa
i have experienced of online data entry i am expert in this field i have experience of three years.i am result oriented and honest person every one can trust me,hard worker and honest man here for your service give me Περισσότερα
I will help you to finishing your report in 14 days. and i will give you the best result of your report. My priority is quality
Dear Hiring Manager, We are very much interested in your job post involving these skills. We have good experience in data entry, web research, Google documents and MS Office. Our agency's freelancers typing speed is Περισσότερα
