We have 1,053,402 lead entries in CSV files that we need formatted correctly per the following requirements.
The spreadsheets include numerous columns of data but we only want the data detailed below with only two columns required as a minimum if none of the other desired data are available.
The spreadsheets are to be formatted into the following columns:
1. lawyer.first_name, (REQUIRED)
2. lawyer.last_name, (If Available)
3. [login to view URL], (REQUIRED)
4. [login to view URL], (If Available)
5. lawyer.firm_name, (If Available)
6. [login to view URL], (If Available)
7. [login to view URL], (If Available)
8. [login to view URL], (If Available)
9. [login to view URL], (If Available)
10. lawyer.type_of_law (If Available)
- Web search may be required for unique entries that do not have the minimum required "lawyer.first_name" or "[login to view URL]" for a lead to be valid.
- Names to be formatted correctly. First names must be identified as "lawyer.first_name". Wrong data such as "initials", middle names, or "last names" must not be listed as "lawyer.first_name".
- If the name is formatted like: "Formoso Donald B" then Formoso is the last name and Donald is the first name. B is middle initial but not important.
- If the name is formatted like "John H Downs Atty" then John is first name H is middle initial and Downs is last name. "Atty" stands for Attorney and is not important to the list. They may also list Esq or spell out Attorney but we do not need that information.
- Missing "lawyer.first_name" and lawyer.last_name may be derived from the email addresses, other included data or web searching
- Merge leads with duplicate emails.
- Finished data to be separated and delivered in multiple CSV files with each having no more than 10k leads to meet our import restrictions.
- Please see the attached sample of the data to be formatted.
If you are able to complete and deliver this project this week, please submit a competitive bid for the total amount.
17 freelancers are bidding on average $453 for this job
Hello, I have read the job description and am able to deliver the job within this week Please send me a message so that we can discuss more. Many thanks Susan.
Hello sir, - I am confident about this project, I can start right now. Hoping that you will review my cover letter and feedback, I am looking forward to hearing from you. Kind Regards
Hello, I am Dileep Kumar Gupta . I am well expert person to do the work like Data Entry , Copy pasting , Microsoft word work , Excel Work .I do my work with more efficiency .
I have an excellent speed in MS Excel and have been working with excel for the past 15 years. And also have been working as a Data Analytics Manager, which involves lot of data works to be done in MS Excel.
I am hard worker, I will submit my document within time frame, I will use Microsoft word of 2016. I am hard worker, I will submit my document within time frame, I will use Microsoft word of 2016.