+ Reply to Thread
Results 1 to 10 of 10

PDF to Excel

  1. #1
    Forum Contributor wmorrison49's Avatar
    Join Date
    09-25-2007
    Posts
    267

    PDF to Excel

    What is the easiest way to take a table in a PDF and put it into Excel format? I need to automate a report from a PDF table and manually entering the numbers into Excel is doable size-wise but is dangerous because the likelihood of an error is pretty high. All I have is Adobe Reader 8 and Excel 2007.

    Thanks for your help, hopefully this is doable.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good evening wmorrison49

    Quote Originally Posted by wmorrison49
    Thanks for your help, hopefully this is doable.
    Not with what you've got, unless you want to copy the whole table and paste it into Excel and try and sort it out from there ...

    There are more eloquent solutions out there but I've never seen a free one (doesn't mean they don't exist). Have a look here for what Google suggests.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    free conversion at
    http://www.zamzar.com/
    will convert pdf to
    doc - Microsoft Word Document
    html - Hypertext Markup Language
    odt - OpenDocument Text Document
    pcx - Paintbrush Bitmap Image
    png - Portable Network Graphic
    ps - Postscript document
    rtf - Rich Text Format
    txt - Text document
    perhaps rtf then import to excel?
    worth a stab

  4. #4
    Forum Contributor wmorrison49's Avatar
    Join Date
    09-25-2007
    Posts
    267
    Seems like a good site, but how long does it take them to email the converted file? It's been about 20 minutes and haven't gotten anything. Is that just their way of trying to get you to join?

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    didnt take all that long i think it depends on site usage, last time i did it late night and it only took 5 minutes

  6. #6
    Forum Contributor wmorrison49's Avatar
    Join Date
    09-25-2007
    Posts
    267
    It sort of worked for the first column but that mashed everything up into a picture. Oh well, it was worth a shot. Thanks.

  7. #7
    Forum Contributor
    Join Date
    06-25-2007
    Posts
    166
    On a related note...

    I can't export an excel file as a PDF without a separate converter, can I?

  8. #8
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    apparently you can do pdf to excel via word.
    http://www.economicsnetwork.ac.uk/tips/pdf2excel.htm

  9. #9
    Registered User
    Join Date
    10-31-2007
    Posts
    34
    Quote Originally Posted by martindwilson
    apparently you can do pdf to excel via word.
    http://www.economicsnetwork.ac.uk/tips/pdf2excel.htm
    The suggested method works well when copying a table of numbers without any text. Thanks for sharing.

  10. #10
    Registered User
    Join Date
    08-14-2008
    Location
    VietNam
    Posts
    1
    Quote Originally Posted by wmorrison49
    What is the easiest way to take a table in a PDF and put it into Excel format? I need to automate a report from a PDF table and manually entering the numbers into Excel is doable size-wise but is dangerous because the likelihood of an error is pretty high. All I have is Adobe Reader 8 and Excel 2007.

    Thanks for your help, hopefully this is doable.
    You can find here

    Cheer!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1