Data Tidy UP
- or -
Post a project like this3819
£20(approx. $25)
- Posted:
- Proposals: 15
- Remote
- #340148
- Awarded
http://www.markitplacements.co.uk/ Sales, Admin, Data Entry, Transcriptionist
Newcastle upon Tyne
Virtual Executive Assistant / CV Writer / Blog Writer/Content Writing/Proofreading/Digital Marketing
Norwich
Data Entry | Data Scraping | Database Clean Up | Excel | Data Research | Data Mining | web research | Data Cleaning
Zagreb
IT Support Engineer/Cloud Support/Web Research/Data Analysis and System Administrator
Montvale
7897594944206924232020245457339865351494374300391559474715500506502724
Description
Experience Level: Entry
Estimated project duration: less than 1 week
We need someone to tidy up an excel spreadsheet of data for us. The spreadsheet contains approximately 2850 lines.
We need someone to go through each line on the spreadsheet and complete details such as adding the first name and last name to the corresponding column, if it is easy to glean this information from the email address. For example, if someone's email address is joe.bloggs@hotmail.com, then we'd need 'Joe' added to the first name column and 'bloggs' added to the last name column.
We also need someone to quickly scan the email addresses and check that they look fine. For example 'هتjoe.bloggs@hotmail.co.uk' would clearly be wrong, or 'joe.bloggs.hotmail.com' would also be wrong as the '@' sign is missing, or 'joe.bloggs@hotmail.co.u' would be wrong as the 'k' would be missing from the 'co.uk' at the end. We'd need someone to scan the email addresses and if it's absolutely clear what the error is, then correct the email address.
We also need someone to be able to write whether they think the email belongs to a male or female in the gender column. If they don't know, leave blank.
Finally, if it looks like the email address belongs to a company rather than an individual, we'd like the company name pasted into the corresponding 'company' column' and also the company industry, if that's obvious (for example, 'nursery', 'photographer').
We need this work completed by Monday.
We need someone to go through each line on the spreadsheet and complete details such as adding the first name and last name to the corresponding column, if it is easy to glean this information from the email address. For example, if someone's email address is joe.bloggs@hotmail.com, then we'd need 'Joe' added to the first name column and 'bloggs' added to the last name column.
We also need someone to quickly scan the email addresses and check that they look fine. For example 'هتjoe.bloggs@hotmail.co.uk' would clearly be wrong, or 'joe.bloggs.hotmail.com' would also be wrong as the '@' sign is missing, or 'joe.bloggs@hotmail.co.u' would be wrong as the 'k' would be missing from the 'co.uk' at the end. We'd need someone to scan the email addresses and if it's absolutely clear what the error is, then correct the email address.
We also need someone to be able to write whether they think the email belongs to a male or female in the gender column. If they don't know, leave blank.
Finally, if it looks like the email address belongs to a company rather than an individual, we'd like the company name pasted into the corresponding 'company' column' and also the company industry, if that's obvious (for example, 'nursery', 'photographer').
We need this work completed by Monday.
Mary Alice M.
89% (11)Projects Completed
24
Freelancers worked with
22
Projects awarded
70%
Last project
5 Jan 2015
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