Closed

CSV spreadsheet data formatting -- 2

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.

Skills: Data Processing, Data Entry, Excel, Web Scraping, Web Search

See more: mysql using csv update data, excel data formatting macro, google spreadsheet data entry, difference csv csv file data java, gridview data formatting aspnet 2005, perl script insert csv file data mysql, excel spreadsheet data entry, csv form data php, csv joomla data entry, spreadsheet data entry job offering companies, php create save csv form data, excel filling spreadsheet data macro, csv inprt data virtuemart example, create csv form data, importing csv file data grid, fill in a spreadsheet with data phase 2, google spreadsheet data entry -- 2, google spreadsheet data entry 2, magento 2 we can t save the address email has a wrong format

About the Employer:
( 0 reviews ) Nairobi, Kenya

Project ID: #27462431

17 freelancers are bidding on average $518 for this job

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 in 3 days
(24 Reviews)
5.2
ITL2020

Dear Recruiter, Greetings. I have gone through the project requirements posted by you under the title: ‘CSV spreadsheet data formatting -- 2’ and I am really interested in applying for the same. I am a Full Stack Dev More

$550 USD in 8 days
(5 Reviews)
3.4
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 More

$500 USD in 7 days
(2 Reviews)
2.8
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 in 4 days
(0 Reviews)
0.0
(0 Reviews)
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 More

$600 USD in 4 days
(0 Reviews)
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 More

$500 USD in 7 days
(0 Reviews)
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 More

$250 USD in 7 days
(0 Reviews)
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 in 7 days
(0 Reviews)
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 in 5 days
(0 Reviews)
0.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 More

$250 USD in 5 days
(0 Reviews)
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 . More

$494 USD in 2 days
(0 Reviews)
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 in 4 days
(0 Reviews)
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 in 7 days
(0 Reviews)
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 in 7 days
(0 Reviews)
0.0
zgheibcharbell

i am ready to do the task that you mentioned and ready to start any time. Please contact me on chat so we can discuss further

$600 USD in 7 days
(0 Reviews)
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 in 7 days
(0 Reviews)
0.0