Copy and reformat tables from a PDF to a spreadsheet

Job ID: 37617533

Budget: $10 – $30 USD

I would like data describing participants in national reading and math tests copied and reformatted from a PDF to a spreadsheet.

-------------------------------------------------------------------------------------------
HERE ARE THE INSTRUCTIONS FOR THE READING TEST

Pages 17-23 of this PDF --
https://www.nationsreportcard.gov/reading/supportive_files/2022_technical_appendix_reading.pdf
-- contains tables summarizing the "Percentage of fourth-grade public school students identified as students with disabilities and/or English learners excluded and assessed in NAEP reading..by state/jurisdiction".

I would like these tables copied into a spreadsheet.

The PDF has a separate table for each year, but in the spreadsheet I would like all the tables combined in a single table that gives the year in a column on the left.

--------------------------------------------------------------------------------------
HERE ARE THE INSTRUCTIONS FOR THE MATH TEST

The instructions are exactly the same, except that the PDF is here:
https://www.nationsreportcard.gov/mathematics/supportive_files/2022_technical_appendix_math.pdf

The math tables have the same titles as the reading tables (except that the math tables use the word "Math" instead of "Reading".

The math tables have the same format and appear on the same pages, pp. 17-23.
Related categories: Data Entry Excel PDF