Share via

Extract specific data from PDF

Anonymous
2023-01-04T17:16:49+00:00

Hi Experts,

I have pdf files with n number of pags and I want to extract a specific line from the data(marked in yellow)

Do you have any suggestions or ideas(Codes) to make this complex work to simple way?

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2023-01-23T01:22:57+00:00

    You can send the PDF file via private message.

    1 person found this answer helpful.
    0 comments

8 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Stefan Blom 339.2K Reputation points MVP Volunteer Moderator
    2023-01-09T10:28:10+00:00

    Which program created the PDF? It may be simpler to extract data from the original file format (if that is a practical option).

    0 comments
  2. Anonymous
    2023-01-09T09:53:38+00:00

    Hi Chandrasekaran,

    Could you share the excel file which export from PDF?

    There is serval way to accomplish it.

    1. Combine the multiple sheets into one with power query and sort with item number.
    2. If it can't be done from power query. Macros may help in doing repeat actions.

    Best Regards,

    Snow Lu

    0 comments
  3. Anonymous
    2023-01-05T05:13:39+00:00

    Hi,

    I am able to extract only one line in the page you can find it in the attachment, but I want to extract multiple lines in multiple pages

     Need to extract all lines marked in yellow

    I hope my question is clear. Thank you and eagerly awaiting for your reply.

    0 comments
  4. Anonymous
    2023-01-05T00:13:01+00:00

    Dear Chandrasekaran. Gokul,

    Greetings! Thank you for posting in Microsoft forum.

    If you wanted to extract only few lines, then the most basic method of extracting data from a PDF file to Excel or Word is to simply copy and paste. This consists of opening the PDF, selecting the relevant text, and copying and pasting it into an Excel/Word file. 

    It is difficult to extract only a specific line from PDF but if you want to extract all the data from PDF, you can import a PDF directly into Excel and extracting data from it can also be a good option.

    1. Open the Excel spreadsheet
    2. Select the tabData> Get data > From file > From PDF
    3. Select the PDF file and select Import
    4. Then you will see a Navigator panel with the tables and pages in your PDF, along with a preview
    5. Select the table and click on ‘’Load’’. The table is imported to the Excel sheet.

    If my understanding above is not consistent with yours, you can also post back and point that out.

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely,

    Neha | Microsoft Community Moderator

    0 comments