+ Reply to Thread
Results 1 to 5 of 5

PDF to Excel

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Office 365
    Posts
    124

    PDF to Excel

    Hi,

    I am looking to see if anyone have a good way of converting a lot of PDF files to Excel using some sort of stand-alone software or other methods.
    I have over 100 PDF files that I need to extract data from and all of the PDFs have the same format.
    I have attached a sample PDF file for review.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: PDF to Excel

    The file looks scanned, I doubt if you will be able to convert it to excel.

    Google "Covert PDF to excel"

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: PDF to Excel

    An Excel export using Acrobat DC is attached.

    I'm sure it can be automated using the Acrobat library in Excel.
    Attached Files Attached Files
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Office 365
    Posts
    124

    Re: PDF to Excel

    I do not have an Adobe license, and the free version will not let me convert.
    The layout of this excel file is better than what I had using ABLE2EXTRACT PROFESSIONAL 12 trial addition.

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: PDF to Excel

    .
    Hopefully, one of these will work for you ..


    This will let you do 25 for free : https://pdftables.com/pdf-to-excel-vba

    Complete VBA project (untested here) :
    Please Login or Register  to view this content.
    Complete VBA project (untested here) :
    Please Login or Register  to view this content.
    Another online service : https://convert.world/

    Another method : https://exceloffthegrid.com/copy-a-d...df-into-excel/

    One last macro (untested here) : http://quickvba.blogspot.com/2010/12...-in-excel.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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