In Progress

School Directory PDF to Excel File

The project entails taking a 290 page State School Directory of Private and Public Schools and extracting the following information out of it. The Directory is in a PDF form. Directory will be given to the winner FreeLAncer at the time of selecting him/her. The targeted information in the School Directory is clearly listed by school under each School District Heading. There are 1500 Public Schools and 300 Private Schools listed in directory. The FreeLAncer should use some sort of data grabber (like List Grabber, Address Grabber or software of choice) to highlight the data and extract the data of each school out of the directory and place it in an Excel spreadsheet which is attached below. If you have a better way of doing it great, but the end product must be in an Excel Spreadsheet.

All data in the directory are in columns and rows starting with the first School District on page 55. Below is the data to be extracted and inputted in the Excel Spreadsheet:

School Name

District number of School

Principal Name (Included Salutation Mr or Mrs Separately)

Address of School

City

State

Zip

Phone

Fax

Email of Principal (must include)

When you finish ALL of the Public Schools entries in the Excel Spreadsheet now go to "Type of School" (Column N) and place the word "Public" in Column N on each school.

When you transition to Private Schools which begins on Page 270 you will perform the same function after going through the whole private list. Then go to "Type of School" (Column N) and place the word "Private" in Column on each of the Private School entries. Note: Headmaster for Private School is the same as Principal. There are no emails for Private School Headmaster. Is there a way to go to each Private School Website and find the email of the Headmaster. This is required in the job. I must have the email of the Headmaster please.

Thank you for viewing. I look forward to working with you!

Skills: Data Entry, Data Mining, Editing, Excel

See more: school directory excel, school directory pdf, project school pdf file, schools directory pdf, excel school phone number, email directory pdf, schools directory excel, excel directory pdf, email directory school pdf, list schools excel file, file directory excel, email pdf directory, private pdf excel, schools first, school project first page, number freelancer, list grabber software, freelancer zip file, freelancer word excel, freelancer pdf word, freelancer excel spreadsheet, freelancer excel like, freelancer excel job, freelancer city, find freelancer list

About the Employer:
( 2 reviews ) Alpharetta, United States

Project ID: #1275785