En cours

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. 

Compétences : Saisie de Données, Excel, Recherche sur Internet, Exploitation de Données, Traitement de Données

en voir plus : mysql using csv update data, excel data formatting macro, google spreadsheet data entry, csv file example, csv format example, how to keep text format in csv, convert csv to excel, csv format excel, csv file format, how to create a csv file in excel, sample 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

Concernant l'employeur :
( 2 commentaires ) Mesa, United States

Nº du projet : #27460848

Décerné à:

Innolawrence

Hi. I noted the changes you have made. This task will take me 4 days. Fixed price: $40. ~Original bid~ Hi. I have read and have understood this project. I am able to format your csv the way you instructed: rename col Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 5 jours
(22 Commentaires)
4.0

58 freelancers are bidding on average $76 for this job

(223 Commentaires)
8.0
expertserv

Hello Sir, I do have a team of 10 experts working with me. Ready to START now with a sample for the accuracy and quality check. I will perform an accurate web research to collect the missing details and fomate the e Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(261 Commentaires)
7.4
hdlan

Hi, I have done a sample so you can assess the quality. I would be happy to help you to extract approximately 100,000 entries with first name and email from your database (i.e 10% as per my estimation) ASAP. I am able Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(55 Commentaires)
6.5
onlinejob247

I check the project details and attachment. I am expert in CSV Data Formatting , contact me so I can create few sample before you award the project thanks;

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(140 Commentaires)
6.6
shezy007

I've USA lawyers data in a well formatted form

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(55 Commentaires)
5.2
istiyaqueahmed

Hello sir, I have checked the JD file there not possible to separate f_Name and l_Name automatically. only fast Name possible but there need to be lots of manual task. Please check the sample file I have corrected. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(67 Commentaires)
5.2
Orientwork

hello sir... i cam formate your execl fine as you aaked in projecg xeyaila...plz talk to me plz.. thanla

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(74 Commentaires)
5.2
RushService

Feel fee to contact me for CSV Spreadsheet Data Formatting .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] payment o Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(17 Commentaires)
4.5
khanjzthanjzt

Hi I have read and understood the latitude of the project. I'm a professional web crawler, scrapper and data manipulating expert, have more than 5 years of experience. Allow me to assist you in this project. Warm Regar Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)
4.7
Omar0a

I have 5 professional freelancers and can start right now.... I offer 1 hr sample for u for free to trust quality.. Then when u trust quality we can start and finish in good time

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(35 Commentaires)
4.8
Servicehour24

Dear Employer, You have specified that you need a CSV Spreadsheet Data Formatting. I'm a professional Web Scraper & Internet Researcher with 7+ years of experience. I can assure you that I will provide you high-qualit Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
4.6
arugawade

Greetings Please review my profile. As I have been worked with Medical Billing Industry for more than 6 years, I have a very good experience with names, addressee, firm's and location details that needs to be entered Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(30 Commentaires)
4.7
VbaStudio

Hello. I'm a specialist in Excel and macros programming. I can give format to that csv regardless of its huge amount. I think I can have it in less than a week.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(9 Commentaires)
3.6
yadavexpert53

I can assist you in the best way & according to project requirement. I am an expert and professional in MS Excel & VBA. It includes extracting information from text files, websites, transferring info in to excel, User Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(22 Commentaires)
3.7
FaizaBilal

Hello, Please review my profile, I can do data formatting for you with accuracy and in time Please come to inbox so we can discuss further Thanks Faiza Bilal

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(14 Commentaires)
3.0
jnpkfb

Hi there, I can do this project right now with 100% accuracy. If you need any sample please let me know. I am an Expert in CSV Spreadsheet Data Formatting. i can complete and deliver your project this week I have no Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(11 Commentaires)
2.8
tamannakhala

Hi I understand this 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". - Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
1.7
hoorulain7586

__________________I am available right now______________________ Hi there, Quality and time is my commitment. I have done this many times, I want to say that, I will start right now and funds will be after your satisf Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
1.3
saads1804

Hi sir! Ill do the task. I have Understood the work and the requirements. i can complete this task the quickest and at the lowest price with the best service. i guarantee Thank You! Saad Sohail

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
1.2
gauravsharma2676

Hi sir, I have more then 3 year experience in this field. I am a research analyst i will check the details of every lawyer on internet then put into a sheet. I will give 100 % accurately designed excell sheet wi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
0.6