How do I transfer data in a pdf file into an excel workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
Open the .pdf file in Acrobat Reader.
Edit > SelectAll
Ctrl-C (to copy)
Switch to Excel, cell A1
Ctrl-V (to paste)

You now have a 1 column TEXT file in Excel........it can be "broken out"
using the Data > TextToColumns feature......

Vaya con Dios,
Chuck, CABGx3
 
A post from Jason Morin........

You can convert the pdf to an html file, and then open it
up in Excel. Of course you'll lose formatting but you can
reconstruct it with formulas and/or macros.

You need to download pdf995 to start the process:

http://www.pdf995.com/

HTH
Jason
Atlanta, GA


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best Tool to Repair Corrupted PDF Files 0
Which is the best RPMSG to PDF converter in 2026? 0
How can we convert OST to PDF file format? 1
Insert multiple .dat files into one pdf without losing color of their graphs 0
Excel to PDF taking too long 1
excel to pdf taking too long in 2007 1
Need to import a table done in PDF into Excel 4
News USB4 announced, will double data transfer speed 3

Back
Top