+ Reply to Thread
Results 1 to 15 of 15

Extract data/information from multiple PDF files to Excel

  1. #1
    Registered User
    Join Date
    08-10-2017
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    44

    Extract data/information from multiple PDF files to Excel

    Dear All,

    Please help me how to extract data/information from multiple pdf files to excel.

    Your assistance is highly appreciated.

    Thanks You,
    Mike
    Last edited by kylechace; 11-30-2021 at 10:33 PM.

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Extract data/information from multiple PDF files to Excel

    Are you still using Excel 2007? If not please update for us to give you the best answer.

  3. #3
    Registered User
    Join Date
    08-10-2017
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    44

    Re: Extract data/information from multiple PDF files to Excel

    yes, i'm still using the Excel 2007 version.

    thanks DJunqueria for your reply.

  4. #4
    Registered User
    Join Date
    08-10-2017
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    44

    Re: Extract data/information from multiple PDF files to Excel

    here is the picture of sample pdf and the encircle in red are the data that i need to extract in excel file.

    SAMPLE FILE.JPG

  5. #5
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Extract data/information from multiple PDF files to Excel

    I think you will need to go for VBA code, so maybe you would be better on a VBA topic.

  6. #6
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Extract data/information from multiple PDF files to Excel

    with excel2007 ???
    Is the pdf an image ??? Hopefully not !
    With PQ (starting in excel2010), it is sometimes possible.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  7. #7
    Registered User
    Join Date
    08-10-2017
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    44

    Re: Extract data/information from multiple PDF files to Excel

    Thank you for the recommendation DJunqueira

  8. #8
    Registered User
    Join Date
    08-10-2017
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    44

    Re: Extract data/information from multiple PDF files to Excel

    Quote Originally Posted by bsalv View Post
    with excel2007 ???
    Is the pdf an image ??? Hopefully not !
    With PQ (starting in excel2010), it is sometimes possible.
    Apologies if the example of pdf is in image format.

  9. #9
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Extract data/information from multiple PDF files to Excel

    i wanted to know if you original pdf, not the screenshot here, is a readable pdf created by excel or another program or just a scan (=image).
    In the last case, you can use OCR-software with poor reability.
    try https://www.newocr.com/

  10. #10
    Registered User
    Join Date
    08-10-2017
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    44

    Re: Extract data/information from multiple PDF files to Excel

    Quote Originally Posted by bsalv View Post
    i wanted to know if you original pdf, not the screenshot here, is a readable pdf created by excel or another program or just a scan (=image).
    In the last case, you can use OCR-software with poor reability.
    try https://www.newocr.com/
    Thanks for response bsalv. here is the original pdf file for your reference.
    Attached Files Attached Files

  11. #11
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Extract data/information from multiple PDF files to Excel

    I hope all data is dummy
    Otherwise it 'll be deleted

    with link above
    DELA CRUZ, JUAN
    111, SAN ROQUE, SAN ISIDRO CITY,

    MANILA
    Foreign Address : N/A *** ; Male
    Date of Birth : 05/02/1984
    Place of Birth : CALUMPIT, BULACAN
    Contact No. (Foreign) : N/A Civil Status : SINGLE
    (Local) : 09081112456 Sample Number ' 264931382000
    EMPLOYER/ORGANIZED GROUP INFORMATION
    SAMPLE ONLY : 123456789
    Name of Employer/Organized >: SAMPLE COMPANY NAME
    Group Business Address ; SAMPLE COMPANY ADDRESS
    Telephone Number : 12345678910
    ID NUMBER $: 049000148858

    DEPENDENT INFORMATION

    ** NO DECLARED DEPENDENT/S **

    *e* NOTHING FOLLOWS **
    with PQ, see attachment
    Attached Files Attached Files
    Last edited by bsalv; 12-02-2021 at 04:34 AM.

  12. #12
    Registered User
    Join Date
    08-10-2017
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    44

    Re: Extract data/information from multiple PDF files to Excel

    Thank you. Is this working for 2007 version?

  13. #13
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Extract data/information from multiple PDF files to Excel

    i suppose that's too old, PQ started in excel2010.

    With PQ or with OCR, that takes more time then manually entering those 3 data, so my advice ...

  14. #14
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Extract data/information from multiple PDF files to Excel

    Power Query, Excel 365 with Insider edition by the way, otherwise no PQ reading PDF.

  15. #15
    Registered User
    Join Date
    08-10-2017
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    44

    Re: Extract data/information from multiple PDF files to Excel

    I guess its time for me to upgrade my excel. Your recommendation is highly appreciate.

    Thank you bsalv and DJunqueira.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract data – Multiple Files – to Single File – in Excel
    By Nostradamus in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-11-2017, 12:00 PM
  2. [SOLVED] Extract data from multiple external excel files
    By rxk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-03-2016, 11:06 PM
  3. Extract data from Multiple excel files
    By rajani85 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2015, 02:48 PM
  4. Extract Data from Multiple Closed Excel Files
    By Gittelman in forum Excel General
    Replies: 2
    Last Post: 07-29-2014, 12:09 AM
  5. Extract Data From Multiple Excel Files -> One File
    By ozzabozza in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2013, 10:20 AM
  6. Extract Data From Multiple Excel Files -> One File
    By Michael via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2012, 01:02 PM

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