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: open csv file in excel without formatting, csv format, csv file format, how to keep text format in csv, csv format example, csv file example, convert csv to excel, how do i keep a long number format on a csv file?, 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, data structure find unique words, php create save csv form data

Tentang Majikan:
( 0 ulasan ) Zurich, Switzerland

ID Projek: #27474857

7 pekerja bebas membida secara purata $16/jam untuk pekerjaan ini


Hello, I am an expert in web search, web scraping, data processing, data entry, formatting, and Excel. I can efficiently do web search for unique entries, format the names correctly according to the stated requirement Lagi

$15 USD / jam
(13 Ulasan)

I can make a script which does exactly this, are there set amount of formats? I can have this complete in less than a week in a total of $1100 negotiable Hey there, i am developer from the UK with over 9 years experie Lagi

$20 USD / jam
(11 Ulasan)

hello sir... i can format you spredsheet in a short time.. plz talk to for further work... thanks and regards

$15 USD / jam
(73 Ulasan)

Hope I can serve you better with my expert knowledge and skill in data entry, processing and analysis.

$17 USD / jam
(0 Ulasan)

Hello Sir. I am a final year studen of Law and this work that you assigned me for, it seems very exciting. As a Lawyer I have always aimed at precision and we know how important every research and drafting is importan Lagi

$16 USD / jam
(0 Ulasan)

Hi, I am new here but I did several offline project. I have good knowledge of excel formatting. I will complete within time limit with your desired quality. Please message me.. we can talk for your project. Thank You.

$15 USD / jam
(0 Ulasan)

Hello, I'm a new Freelancer looking to do some projects around here. I have many years experience already working with CSV, Excel files, VBA, macros in high profile companies. Also, I have some experience into web rese Lagi

$15 USD / jam
(0 Ulasan)