Find Jobs
Hire Freelancers

CSV Spreadsheet Data Formatting

$15-25 USD / hour

Closed
Posted over 3 years ago

$15-25 USD / hour

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. 
Project ID: 27497517

About the project

10 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $27 USD/hour for this job
User Avatar
Best knowledge and experience in excel sheet. Can give 6 days in a week. Please confirm if the project is still available.
$50 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am Ejaz Khan Professionally Expert At Microsoft's Office (Word, Excel, PowerPoint). So if you appoint me for your project I will definitely give you excellent results with in short time. Inshallah
$17 USD in 78 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I do will Perform all data entry related tasks including sorting, proofing, updating, mailing and storing. I do Maintain data files accurately and Compile, sort, verify and correct data to be entered. I do Maintain data files accurately and Compile and work Review data for completeness and accuracy. I do Contact buyer of source documents to address data inconsistencies and to gather missing data. I Manage filing and routing of source documents after entry. I Maintain records of work completed. Thanks/Sirazul
$15 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings, I'm new in the genre of freelancing but very fluent and experience in Data entry and Office softwares. Will work with utmost sincerity as I want to prove myself in the freelancing industry.
$39 USD in 28 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Where is the sample ?? Attachment is missing. Please provide me the sample file. Regards, Rana Ghosh
$25 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir I want money for my higher studies that's why I choose this please help me for my studies. I will full on to this. No one is giving me jobs
$23 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Very good freelancer expert so I have very experience so your work as you wish my work 100% satisfied so you trust me and my work OK will you can you after very very glad you so sir I need one chance my I proof intelligence
$25 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am experience in data cleansing using Excel Macro and Microsoft Acces. Also in web crawling, indexing, and scraping.
$28 USD in 56 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day! I can deliver within 3 days as soon as I get the files. Total amount would be 10 hrs by hourly bid rate. Thank you for your time and consideration.
$28 USD in 30 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NIGERIA
Lagos, Nigeria
0.0
0
Member since Sep 24, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.