Closed

CSV Spreadsheet Data Formatting -- 2

NOTICE: Please read the specification, review the provided sample then submit your TOTAL bid and time to complete. DO NOT MAKE A FAKE GENERIC BID - YOU WILL BE BLOCKED.

We have 1,053,402 lead entries (minus duplicates which we suspect will leave less than half) 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. While we expect more than half to be duplicates, we also expect many to not have an email or name that would need to be found.

- 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: Excel, Data Entry, Data Processing, Web Scraping, Web Search

See more: mysql using csv update data, excel data formatting macro, google spreadsheet data entry, csv format example, how to create a csv file in excel, csv format, why does my exported csv data get converted to weird formats?, csv file format, how do i keep a long number format on a csv file?, csv file example, how to keep number format in csv file, 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

About the Employer:
( 0 reviews ) Lagos, Nigeria

Project ID: #27497502

7 freelancers are bidding on average $19/hour for this job

bhakaremanthan

Sir i would like to help you in managing the sheets i can do it in google docs and also in excel. So please allow me to help you in the job which is beign recruited by you. thanks

$17 USD / hour
(0 Reviews)
0.0
ADITIPARDAL90

Hi, I am an entrepreneur from Delhi engaged in network marketing business. I am also a qualified Company secretary and a former investment banker. Being in these diversified roles, has given me a good grasp over exc More

$20 USD / hour
(0 Reviews)
0.0
Abhisheknadar24

I have 1 year of experience as data entry officer Sir I Can do this work completed .Trust guy for india.

$15 USD / hour
(0 Reviews)
0.0
debeset1

10+ yrs of experience in MS Excel and VBA for Macros. Competent in data transformation and data management for multiple industry majors, using MS Excel. Also experienced in building automated solutions on MS Excel.

$20 USD / hour
(0 Reviews)
0.0
rishabhjjain38

Hello My name is rishabh jain. I am writing to you for the position of data entry expert that you are looking for an urgent basis. Data entry job is my passion and I have 6+ years of experiences in this field that mak More

$20 USD / hour
(0 Reviews)
0.0
ladhar75

i am a engineering student having specialization in computer science and engineering and regularly working on Microsoft office (word Excel PowerPoint) and made a loy of projects in data mining which requires a lot of e More

$15 USD / hour
(0 Reviews)
0.0
pendyalaswapna76

I deal with US Health care member operations. My job is to validate the member details. So, I am sure that I can full your requirements in data formation. Thank you.

$24 USD / hour
(0 Reviews)
0.0