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?

Microsoft 365 and Office Excel For business Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua 18,060 Reputation points Moderator
    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.