Share via

import pdf to excel

polski86 0 Reputation points
2024-07-02T20:42:34.7166667+00:00

why does only show up by the data tb to click get external data, not to get data, and get the option to get a pdf file?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,731 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 11,045 Reputation points Microsoft Vendor
    2024-07-03T05:25:01.58+00:00

    Hi @polski86

    Which version of Office are you using?

    You may go to File > Account > Product Information, check the version name.

    Did you import PDF file via Data tab > Get Data group > From File > From PDF?

    • PDF files need use Power Query to import data.
    • You may choose "Select multiple items" and tick the data options that you need, then click Transform Data to Power Queries.

    User's image

    • When the data is processed, it can be loaded to worksheet.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.