In Progress

Enter data from PDF to MS Excel

I am looking for help digitizing data from several PDFs into Microsoft Excel.

Required skills: Ability to open PDFs and open/save Excel spreadsheets; Ability to read and understand English text; Speed and accuracy entering numerical data

Total time required: Estimated 70-94 hours (depending on your speed)

Specifically, I am trying to encode data on U.S. agriculture from the 1930 U.S. Census into an Excel spreadsheet. There are 47 statistics that I would like to record, each of which is observed for 1,057 counties (covering 12 different U.S. states). This data can be found in PDF tables that I have carefully organized and will provide to whoever is hired. There are a total of 9 tables per state; each of these tables has an identical format across states. There is therefore a grand total of 9 tables x 12 states = 108 PDF files. To see a sample table, click here: [url removed, login to view]

I have constructed a blank Excel spreadsheet with a separate worksheet for every state, which you can view here: [url removed, login to view] In each state worksheet, there is a row for the name of every statistic that I want to record and a column for every county in the state. In each cell of this spreadsheet, I’d like to have someone enter the value of the statistic for the county given by the column heading. Note that the name of the PDF with the data for a given row is provided in the left-most column of every worksheet. (This information is meant to make it easier to find the right data to enter into the spreadsheet.)

To clarify the requirements of this job, I provide an example of what is involved. For this example, let’s suppose we are entering data for North Dakota (ND) from the PDF file I have linked above ([url removed, login to view]). To see how it works, do:

1. Open the linked spreadsheet, go to the “ND” worksheet

2. Look at statistics in Column B, rows 4 to 18 of spreadsheet

3. Find the identifier v2t1 in left-most column of spreadsheet

4. Open the linked PDF table named [url removed, login to view]

5. Look at statistics on first page of PDF, compare to spreadsheet

The job is then to enter data on every requested statistic in rows 4 to 18 for every county in North Dakota, copying from the PDF into the designated cells in the spreadsheet. Note that the commas in long numbers don’t have to be copied, i.e. “1,000” should be entered as “1000”.

Once I have a few candidates, I would like to do a quick screening / practice exercise, asking you to look up the value for 4 or 5 different statistics for a particular county. The screening should not take more than a few minutes; if it does, then this job may not be the one for you.

I have myself hand-entered 10 or 12 statistics for all 1,057 counties to get a feel for what this job will be like. I found it to be most efficient to focus on a single statistic at a time and enter data for all 1,057 counties before moving on to the next statistic, but you might have a better idea. It helps to either print out the PDF tables or have them shown on a second monitor. My experience was that it took about 1 hour to enter data for each statistic in every county, though you should conservatively budget for each one to take 2 hours.

I will be paying 10% up-front, an additional 10% for every 6 statistics compiled for all 1,057 counties, and the final 10% when the job is completed. I will be spot-checking the work for typographical errors and allow for a small degree of error, which is probably inevitable for this type of job, but I am expecting highly accurate typing. I would like to see this job finished by October 31 (at the latest). I am generally available discuss the job and take questions that arise from 9:00 a.m. to 7:00 p.m. PST Monday through Friday. It may sometimes take me 2 or 3 hours to respond by email, but never more than a day, including on weekends.

This digitization is for academic research on the diffusion of farm tractors in the 1920s U.S.

Skills: Data Entry, English (US), Excel, PDF

See more: statistics excel help, meant data entry work, want works freelancer, typing minutes, statistic freelancer, organized freelancer, one page freelancer template, pst file, next available freelancer, microsoft freelancer get, microsoft excel spreadsheet, microsoft excel job, microsoft excel help, microsoft academic research, make data entry easier, looking job excel, linked freelancer, want someone data entry

About the Employer:
( 12 reviews ) Cambridge, United States

Project ID: #2529729

Awarded to:

LUretsky

I have 15 years of excel experience.

$450 USD in 20 days
(17 Reviews)
4.7
jkrish

Hi, Thanks for the detailed description. Please check PM. Regards, Krish J.

$450 USD in 23 days
(46 Reviews)
5.9

63 freelancers are bidding on average $394 for this job

captchacompany

Ready to start please provide more details , Thanks

$750 USD in 7 days
(95 Reviews)
8.0
lucky2gaf

Hi, I am expert and have very exclusive tools to make appropriate conversion from attached sample PDF file to like sample Excel file. Please check your PM for more details, thanks.

$500 USD in 10 days
(107 Reviews)
5.9
vsona

Greetings! Thank you very much for giving us an opportunity to bid for your project. Please refer to PMB for our detailed bid.

$325 USD in 15 days
(66 Reviews)
5.8
HardWorker1989

Hello Sir. I am a highly qualified and certified MS Office, Adobe Acrobat, Adobe Photoshop and Adobe Illustrator professional designer and developer. I have read the whole description but I would be needing your More

$350 USD in 25 days
(50 Reviews)
5.8
sonarkaushik

Sir, I can do the project. Refer PMB. with regards

$598 USD in 18 days
(60 Reviews)
5.7
uumairkhalid

Hi.. Expert typist here. Interested in your project. I assure you 100% accurate and good quality work. Ready to start. have a look at PM.Regards

$250 USD in 5 days
(25 Reviews)
5.3
srinichal

I look forward to discuss further

$620 USD in 15 days
(10 Reviews)
4.7
Engineer85

Hi I am interested in the job. Please check PM. Thanks

$390 USD in 21 days
(14 Reviews)
4.5
mindware97

I have read and understood your project requirement. I am a qualified professionals with years of experience in Data entry, Graphic design and web design (HTML/CSS). So far, I have finished more than 100+ various data More

$400 USD in 15 days
(14 Reviews)
4.3
rengrish

Hi Interested in this project. Please check your mailbox.

$250 USD in 10 days
(32 Reviews)
4.3
Assistantjob

More than capable to do the job. Details in PM.

$500 USD in 10 days
(4 Reviews)
3.9
alwayswrite01

Hi dgross03, excellent and professionally trained data entry specialist here. I provide error free data so you don't have to proofread it again. I am very fast, efficient and committed.

$350 USD in 3 days
(7 Reviews)
3.9
ewebinfo

Clearly understood the detailed description of the project work and ready to do.

$250 USD in 5 days
(6 Reviews)
2.0
yogeshrathi1989

I have a very good experience in data entry projects....I have very fast typing speed with high accuracy...Looking forward to work with you....

$300 USD in 3 days
(3 Reviews)
1.5
Jesri

I am a British native English speaker with extensive data entry skills using PDFs and Excel. I am meticulous with my work and always meet my deadlines. I propose to complete this task before your deadline, to give you More

$450 USD in 20 days
(1 Review)
1.4
fifib

Hello, I am interested in completing this job. I have experience with data entry; I have completed a similar job to this one. Also, during my undergrad studies, I have taken a class for Statistics and Data Analysis. More

$350 USD in 15 days
(1 Review)
1.1
ducnq

Hello, We are diligent workers, who are very good at command on MS Excel, MS Word, web research, Data uploading and data gathering. Ready to work for you on this project. 100% Quality within delivery schedule More

$450 USD in 24 days
(0 Reviews)
0.0
Arshaqsoul

First Bid Expert in Excel Have enough free time to complete requirement.

$300 USD in 7 days
(0 Reviews)
0.0
barcibal29

Hi dgross03, Please check your PMB please. Thanks. - Coleen

$500 USD in 24 days
(0 Reviews)
0.0
rahulraghuv

hi, you wont be unsatisfied. Get your work done.

$300 USD in 10 days
(0 Reviews)
0.0