Convert PDF to Excel

[Kansa]

HI,

I am following the instructions found on the website below to convert PDF to Excel. I am only able to copy one page at a time in Adobe using the 'Table/Formatted text tool' option. How can I copy all pages in one go?

http://www.library.mcgill.ca/edrs/services/publications/howto/PDFtoXLS/PDFtoExcel.html

Thanks

 

[macropod]

Hi Kansa,

I suspect you can't, becasue the adobe format doesn't recognise the table as continuing over several pages. As far as the pdf file is concerned, each page is independent of any other in this respect.

You may be able to get around this by copying the multi-page table as text and pasting into an application like Word (or even notepad) as an intermediate step. In Word/notepad, you'll be able to delete extraneous stuff like page headers/footers that invariably get copied as part of the process. After you've done that, you may then be able to copy the material from there into Excel.

Cheers

 

[Kansa]

HI

Thanks for the quick reply. I tried copying all the pages into Notepad and then into Excel. The Excel file looked pretty messed up unless I manually do adjustments as you said in the Notepad file.

Thanks anyway.
Kansa