Suljettu

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.

Taidot: Excel, Tiedonsyöttö, tietojenkäsittely, Tietojen kaavinta verkosta, verkkohaku

Näytä lisää: mysql using csv update data, excel data formatting macro, google spreadsheet data entry, how to create a csv file in excel, how to save leading zeros in csv format, csv format example, sample csv file, csv files lose formatting after save, csv format excel, csv file format, csv file example, 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

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #27471922

13 freelancers are bidding on average $18/hour for this job

akritisood94

Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project Lisää

$20 USD / tunti
(128 arvostelua)
6.1
nemanjadj20

Hello? I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # create Lisää

$25 USD / tunti
(10 arvostelua)
4.8
rahulkashyaprk02

Hi!! I have read your requirements and I can assure that I will deliver your project on time. I am a professional and I know the importance of quality and time. Please consider my profile and give me at least one chan Lisää

$20 USD / tunti
(0 arvostelua)
0.0
BalaMuraleee

Hi There, Good Day! I am an SEO and an excel expert. I can format the spreadsheet columns as per your instructions. will also eliminate duplicates and find the valid lead. I ensure to submit the output in Multiple CS Lisää

$16 USD / tunti
(0 arvostelua)
2.0
tasnimrhidy20

Hello, I am Tasnim. I am a full time professional freelancer and expert in lead generation. I have completed many lead collecting projects in other marketplace. If you give me the order, you wont be disappointed. I c Lisää

$15 USD / tunti
(0 arvostelua)
0.0
taufikhasan184

I want to do this work.I always believe to keep my clients satisfy.I am new in freelancer.com But I have been teaching on data entry, Microsoft Office, Excel and web design for 3 years. So I have work experience. I hop Lisää

$20 USD / tunti
(0 arvostelua)
0.0
mmateen94

Hey! I have read your requirements. I totally understand what you need. I am unable to see any of the attachment as it would be great if you can send. I have expertise and certified excel professional. I believe I ca Lisää

$15 USD / tunti
(0 arvostelua)
0.0
kimball1999

Hi! I have read your job description carefully and I assure you that I am a perfect fit for your project. I will be able to provide you best results. Message me so that we can discuss more about your project. Regards Lisää

$15 USD / tunti
(0 arvostelua)
0.0
manijob17

Dear Sir, I am polymer enginer and did job as Sr Executive in company,have a responsibility to manage production activity and entries every day and summarize all production reports after the ending of the [login to view URL] la Lisää

$20 USD / tunti
(0 arvostelua)
0.0
lahmane

Hello, i have an experience in data entry and i believe i can complet this job this week for a total amount of $600

$20 USD / tunti
(0 arvostelua)
0.0
kailashka

I have worked for many respected clients doing data entry/data mining, lead generation and web search for many years. I can understand, follow instructions very well and handle large quantity of work. I am experienced Lisää

$19 USD / tunti
(0 arvostelua)
0.0
smile4Qureshi

HI , I AM DATA ANYLISER AND ALSO DATA SCINTIST. I DID WORK RELATED TASK . I WILL DO IT . I READ YOUR WORK DISCRIPTION CAREFULLY. THIS WORK IS EASY FOR ME . CONTACT ME FOR THIS PROJECT BEST REGARDS ADIL NAWAZ THANK YO Lisää

$20 USD / tunti
(0 arvostelua)
0.0
scorpion004ss

Hi, I have experience in web automation, data analysis, data formatting and web designing. I will be very happy to work for your project and I will give my best efforts and deliver before the time. Thank you. Will us Lisää

$15 USD / tunti
(0 arvostelua)
0.0