CSV spreadsheet data formatting -- 2

Închis Postat la acum 3 ani S-au achitat serviciile după ce au fost prestate
Închis 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.

Procesare date Introducere date Excel Web Scraping Căutare Web

ID Proiect: #27462431

Detalii despre proiect

16 propuneri Proiect la distanță Activ acum 3 ani

16 freelanceri plasează o ofertă medie de 513$ pentru proiect

MyAwesomeTeam

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

$538 USD în 3 zile
(26 recenzii)
5.3
CrazyProger

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

$500 USD în 7 zile
(3 recenzii)
3.0
dear1982

I can do and finish this project. I have a lot of experience in in excel, word, PDF, copy typing, data entry, web search, Virtual Assistant , internet marketing and data processing I'll complete this project in 5 days Mai multe

$250 USD în 5 zile
(0 recenzii)
0.0
nikisawant8086

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.

$900 USD în 7 zile
(0 recenzii)
0.0
Bolajijohnson

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

$450 USD în 7 zile
(0 recenzii)
0.0
Muessy

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.

$533 USD în 4 zile
(0 recenzii)
0.0
blessedkhetran

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

$494 USD în 2 zile
(0 recenzii)
0.0
grsekhar21

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.

$500 USD în 7 zile
(0 recenzii)
0.0
yogeshwfh56

I can work this project with in given timeline. I have knowledge to change the csv file .You can trust on me.

$500 USD în 5 zile
(0 recenzii)
0.0
goktugcetin

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).

$500 USD în 4 zile
(0 recenzii)
0.0
gabrielvgrigoras

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

$250 USD în 7 zile
(0 recenzii)
0.0
moni1969

Hello, I have gone through the details of the project. Has good experience in preparing excel sheets. With all the formula inputs and creating the master sheets as required by the clients to the satisfactory level. Th Mai multe

$500 USD în 7 zile
(0 recenzii)
0.0
myclin19

Project looks interesting and I have good handson experience in working with csv to excel file conversions. Since I am a full time freelancer you can count on me to deliver this project on time. Looking forward to hear Mai multe

$600 USD în 4 zile
(0 recenzii)
0.0
koucharal

I have many years experience in Administration and Secretary roles both in the UK and now I live in Cyprus

$500 USD în 7 zile
(0 recenzii)
0.0