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. 

Kemahiran: Excel, Pemasukan Data, Pemprosesan Data, Pengikisan Web, Carian Web

Lihat lagi: php create table csv data, excel data formatting macro, import csv data sql server table, csv file format, convert csv to excel, csv format excel, how to keep text format in csv, how to create a csv file in excel, how to save leading zeros in csv format, csv format example, csv file example, 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

Tentang Majikan:
( 0 ulasan ) Lagos, Nigeria

ID Projek: #27483045

10 pekerja bebas membida secara purata $21/jam untuk pekerjaan ini


Hello there! Happy to bid here since I have the capability to wrap up your project on your timeline. I am a python developer and have rich experience in Data mining & manipulating.... So I think you’d better discuss w Lagi

$20 USD / jam
(2 Ulasan)

Hello, I have read your proposal and it fits my profile. I am a naval engineer, I speak perfect English. I have extensive experience as a virtual assistant, an expert in mathematics, technical support, extensive knowle Lagi

$20 USD / jam
(1 Ulasan)

Can do work within given time limit with accuracy. I am having very good speed in typing and also have good working knowledge of Microsoft Office like Word, Excel, Power Point etc.

$17 USD / jam
(0 Ulasan)

I am good in VBA and C# script . Once you provide the project will deliver as soon as possible. Will be available anytime..

$28 USD / jam
(0 Ulasan)

Hi, I can complete this in 10 - 12 hours. I have more than 11 years of experience in BI and Analytics with expertise in Tableau, Qlik, Power BI, Web Development, Web Maintenance, Content Management, Data Entry and SQ Lagi

$20 USD / jam
(0 Ulasan)

I have went through your requirement and I can complete it on with high quality. pls let me know when we can get started with this project.

$15 USD / jam
(0 Ulasan)

Good day I can work with your project low price on time delivery and good quality sir. you can trust me. Give me this best opportunity for me. let me know more about your project sir.

$22 USD / jam
(0 Ulasan)

Hi,i will complete your required task in one week. I have make CSV Spreadsheet formatting according to your requirement hopefully you accept my bid and i will be try to satisfy you in this work .i have done this job re Lagi

$20 USD / jam
(0 Ulasan)

Hi, I am experienced with Data Entry, Data Copy & Paste, Web scrapping, Seo Report, HR tasks. Greetings.... I am Sourabh, I have read your proposal and would like to work on it ASAP. I will work with quality and ac Lagi

$17 USD / jam
(0 Ulasan)

i am best at my work .i am expert in data processing,data entry and excel. i will give u my best.i i have done diploma in this work . i am very honest in my job . i am sure u will give me work. Lagi

$26 USD / jam
(0 Ulasan)