Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PDF to Excel

Status
Not open for further replies.

chemimpex

IS-IT--Management
Feb 23, 2006
18
US
What is the best way to convert a PDF file to excel. I have a report in PDF that I want to convert to Excel. Pls help and thanks for your time.

If anything can go wrong, it WILL.
 
Do you need to keep special formatting - tables, shading, special fonts? If you only need the data and want to extract data to work with it, there is a program that I use called Monarch which allows you to extract data from PDF files as well as text and other data files and also allows for sorting, creating calculated fields and summarizing the data, and can link to external data files to act as lookup tables too. You can then export the results to Excel, Access, text and other formats. List prices for Standard and Pro range between 500-600 though. But depending on how often you need to extract/manipulate data it can be worth it as you can also set it up to be automated with command lines, vba, etc.

 
In Acrobat Pro go the Help menu/Complete Acrobat help.

Click Search and use Excel as the search term. You'll get a result. Copying and pasting tables, that tells you how to do all sort of things with tables, including moving it to Excel. That copy paste title is deceiving as there's much more - ucing the Acrobat table tool.

Using OSX 10.3.9 on a G4
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top