CSV Spreadsheet Data Formatting

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. 

Навыки: Excel, Ввод данных, Обработка данных, Веб-скрейпинг, Поиск в Интернете

Показать больше: open csv file in excel without formatting, csv file format, convert csv to excel, how to keep text format in csv, how do i keep a long number format on a csv file?, csv format example, csv format, csv file example, php create table csv data, excel data formatting macro, import csv data sql server table, excel spreadsheet vba data entry form, mysql read delimited csv data, website csv data feed reader, csv data capture, create invoice import csv data, csv data compiler, csv data feed web page, excel chart provide csv data, gridview data formatting aspnet 2005

О работодателе:
( 0 отзыв(-а, -ов) ) Lagos, Nigeria

ID проекта: #27482986

8 фрилансеров(-а) готовы выполнить эту работу в среднем за $17/час

(111 отзывов(-а))

Hello, Thanks for Reviewing my Bid. I have understood your " CSV Spreadsheet Data Formatting " project. & I can fulfill your requirements. I have years of data entry, data formatting, processing, Ecommerce product l Больше

$15 USD / час
(23 отзывов(-а))

I am expert in data entry work and word document converter in pdf file I am interested with your work and I am try best for work

$20 USD / час
(0 отзывов(-а))

I have read your project description and also how it should be written. Be assured of no duplicate files and I can do this within 5days. This will take 2 hours per day so that it can be good quality work. Thank you

$15 USD / час
(0 отзывов(-а))

Dear Sir/Madam, I understand what to do. I am young and eager to finish this job as soon as possible

$20 USD / час
(0 отзывов(-а))

Hello sir, I have gone through the requirements. it is interesting and text processing task. ( comparison, flag important missing details etc). Hire based on discussion. don't pay if result not as per requirements. L Больше

$15 USD / час
(0 отзывов(-а))

having the strong knowledge in data entry will help me to complete the project on time with quality in work.

$15 USD / час
(0 отзывов(-а))

Hi! I am perfect for this job as I've worked the past couple of years on spreadsheets for Companies like Suzuki, PepsiCo, JFL, HCL. I've formatted even the toughest CSV data with precision. I'm pursuing Chartered Accou Больше

$17 USD / час
(0 отзывов(-а))