Import multiple page PDF doc with headers into Excel, separating data into columns

[DPKologie]

How do I import a PDF document from the web (hundreds of pages), with headers on each page, into Excel, separating the data into appropriate columns? If possible, I would also like to extract data from certain of the pages rather than all of it. Note that the PDF file uses dots as spacers in come columns, and it also uses a comma to separate thousands in the numerical data. So far these things have not allowed the data to correctly line up into meaningful columns.

Here is a link to the PDF document I want to import: https://www2.census.gov/library/publ...cdb07/tabb.pdf

I am interested in the data in pages 20-65 only, as numbered at the bottom of the pages.

As you can see, the headers are at the top of each page. Would each page need to be imported separately? Or can they all be imported together in one file? Also, the dots used as spacers and the commas used to separate thousands have so far proved to be problematic.

Any help would be GREATLY appreciated!

[DPKologie]

Bump no response

[popipipo]

Try a pdf converter:
https://www.freepdfconvert.com/pdf-excel

[DPKologie]

Hi Willem,

Thanks so much for the tip! The PDF converter will do only two pages for free, the remainder is a paid service. Adobe will actually do it for a smaller fee. So I'm evaluating the best way forward. Again, thanks so much. It's good to know this service is available!