Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Convert pdf to xl using adobe acrobat

  1. #1
    Join Date
    10th December 2004
    Location
    Arizona, USA
    Posts
    819

    Convert pdf to xl using adobe acrobat

    Hi all
    I have tried many different ways to convert pdf to excel
    the best seems to be to highlight the data in adobe acrobat using the table/fomatted text tool >> right click >> save as ANSI.txt >> open with Excel

    However, will only let me highlight a singel page in the document at a time
    My current document is 200 pages.

    Does anyone know how to beat this limitation or create a batch process?

    btw, I have tried these utilities
    Ghostscript
    Able2Extract
    pdf2txt

    They all failed at negative numbers formatted as such
    ( 200,000) The right parend is output to Col A
    The remainder is output to col B

    In addition, labels such as TJE 098789 Roth are output to three columns instead of 1

    TIA
    marc

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th February 2005
    Location
    The Wrong Coast
    Posts
    130

    Re: Convert pdf to xl using adobe acrobat

    The attached solution takes over after you use something like pdf2txt to get the data out of the .pdf and into Excel. It works for the number part of your problem. It assumes that the delimiter between numbers is a space. It handles up to four columns of numbers, but has instructions to expand that.

    What it does is concatenates all of the fields into one string, then eliminates the extra spaces with a trim and replaces the "(" with a "-" and eliminates the ")" and "," with nested substitutes. It then separates the remaining number text into separate cells and converts them to values.

    The label part of your problem, if delimited with spaces, cannot be fixed automatically unless there are patterns that can be evaluated.

    I hope this helps.

    Steve
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    25th July 2006
    Posts
    1

    Re: Convert pdf to xl using adobe acrobat

    WOA PDF-Excel is a free solution that allows you to use regular expressions and process multiple files.

    This might solve your problem

    check it out at:

    http://www.melbtest.com.au/woa/pdf-excel_download.htm

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    10th December 2004
    Location
    Arizona, USA
    Posts
    819

    Re: Convert pdf to xl using adobe acrobat

    Thanks for answering a post over a year old.
    Only by looking thru CP and review all of my subscriptions did I notice an update.

    You may want to PM the thread starter next time.

    At any rate, long since solved using Able2Extract from InvestInTech.com, and a whole bunch of VBA to clean up the output and format into excel database type structure

    Regards
    -marc

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

    Re: Convert pdf to xl using adobe acrobat

    You may want to PM the thread starter next time.
    NO, please don't. We want ALL answers public, never private regardless of the age of the post. One persons answer can then help 1000's of others with simliar issues.

  6. #6
    Join Date
    10th December 2004
    Location
    Arizona, USA
    Posts
    819

    Re: Convert pdf to xl using adobe acrobat

    Dave -
    I meant PM to alert a reponse to such an old post
    By all means post to the forum.

    -marc

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

    Re: Convert pdf to xl using adobe acrobat

    Ok, sorry, my bad.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Import Part Of PDF Adobe Acrobat File
    By JanKok in forum EXCEL HELP
    Replies: 2
    Last Post: April 3rd, 2008, 06:14
  2. printing from excel into acrobat 6
    By stephenp in forum EXCEL HELP
    Replies: 4
    Last Post: May 27th, 2004, 04:53

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno