CSV spreadsheet data formatting -- 2
$250-750 USD
S-au achitat serviciile după ce au fost prestate
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.
ID Proiect: #27462431
Detalii despre proiect
16 freelanceri plasează o ofertă medie de 513$ pentru proiect
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
I'm an Excel/Excel VBA expert with rich experience in Excel/VBA application. I read the job details extremely carefully. I think I can help you to complete your project with my rich knowledge and experience. I'm rea Mai multe
Hi Sir/ Madam I have a fast typing speed n can complete ur project on time without any mistake. I can start your work right now.
Have been a Microsoft expert for a while now and I believe am the perfect candidate for this project. Send a DM and let's discuss further
Hello, Am interested in this project as I am highly qualified in data entry and I work full time to deliver quality results to my clients whom am very dry to. Please consider my bid.
Hello , i am well experienced in lead generation and all my work is in spread sheet. I can deliver it on time with all the requirements u have put . If u want to see sample of my spreadsheet work i can send that too . Mai multe
I was already done similar data formatting dashboards for outside companies and extracting first name and second name and i can available any time for any calls or demo on this requirements.
I can work this project with in given timeline. I have knowledge to change the csv file .You can trust on me.
Parsing data and scripting is no problem for this project. I will transfer these datas to csv as you said. I can also transfer these datas to django website so you can easily manage datas(optional).
Hello, I have worked since already a couple of years with Excel, VBA, Excel Macros. I am a new Freelancer and eager to deliver some results and get some recognition. You can count on me for finishing this project. Tha Mai multe
I have many years experience in Administration and Secretary roles both in the UK and now I live in Cyprus