Populate data on CSV from Emails
- or -
Post a project like this2565
$10
- Posted:
- Proposals: 4
- Remote
- #1498056
- Completed
Description
Experience Level: Entry
Estimated project duration: 1 day or less
General information for the business: Led Lighting Products
Industry: Business
Description of excel work: The process is pretty simple and has to be carefully written to avoid mistakes with wrong emails or websites written in the Excel. The most important are emails has to be correct. Check email, check email headers to verify the FROM. If the email comes from Alibaba servers, check signatures. If there's not information then write it on the tab in the Excel named Missing Information
We will provide access to 1 email account where there are around 100 emails from Led Light Factories from China
As all information is coming messy and not organized we will put all that into a CSV for importing into our CRM for proper contacting them. I need from each email
1) Copy the contact information and put it in the correspondence column in the Excel file, information like Name, Last Name, Email, URL, Address, Phone (including international calling codes).
2) Check if they have provided clean, individual, photos of products or collages, define by a keyword in the last column. Definition of the keywords to use will be given in the second sheet of the Excel
3) TAG them in a column accordingly by led china, led hong kong, led Europe
4) TAG them in a column accordingly by sample_yes, sample_no, sample_na
5) Each contact that has been written, verify and complete has to be labeled in the email account with the Label: CSV. Only those with the information completely in the CSV should have that label and a number of emails with that label should match the rows in the Excel
Extra notes: I would like the attention to detail in putting the information correct and if required verify websites domains if they are active or not by just open the website and verify the website.
If you have any doubt or question, contact me immediately do not assume or take any decision that will lead to waste time, but if the decision is wisely made then I will be grateful.
if the job is done professionally I may have more data manipulation work at large scale and a possible collaboration on monthly basics
Deadlines are not negotiable
Industry: Business
Description of excel work: The process is pretty simple and has to be carefully written to avoid mistakes with wrong emails or websites written in the Excel. The most important are emails has to be correct. Check email, check email headers to verify the FROM. If the email comes from Alibaba servers, check signatures. If there's not information then write it on the tab in the Excel named Missing Information
We will provide access to 1 email account where there are around 100 emails from Led Light Factories from China
As all information is coming messy and not organized we will put all that into a CSV for importing into our CRM for proper contacting them. I need from each email
1) Copy the contact information and put it in the correspondence column in the Excel file, information like Name, Last Name, Email, URL, Address, Phone (including international calling codes).
2) Check if they have provided clean, individual, photos of products or collages, define by a keyword in the last column. Definition of the keywords to use will be given in the second sheet of the Excel
3) TAG them in a column accordingly by led china, led hong kong, led Europe
4) TAG them in a column accordingly by sample_yes, sample_no, sample_na
5) Each contact that has been written, verify and complete has to be labeled in the email account with the Label: CSV. Only those with the information completely in the CSV should have that label and a number of emails with that label should match the rows in the Excel
Extra notes: I would like the attention to detail in putting the information correct and if required verify websites domains if they are active or not by just open the website and verify the website.
If you have any doubt or question, contact me immediately do not assume or take any decision that will lead to waste time, but if the decision is wisely made then I will be grateful.
if the job is done professionally I may have more data manipulation work at large scale and a possible collaboration on monthly basics
Deadlines are not negotiable
John F.
100% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
33%
Last project
28 Mar 2017
Spain
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