Share via

Import data from a PDF file into Excel for Mac.

Anonymous
2025-02-06T13:28:39+00:00

I have a Microsoft Office 365 subscription and need to import data from a PDF file into Excel for Mac. I'm using the latest version, 16.93.1, but unfortunately, it doesn't have the option to Get Data from PDF. Could anyone assist me with this?

Microsoft 365 and Office | Excel | Other | MacOS

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. Bob Jones AKA CyberTaz MVP 430.2K Reputation points
    2025-02-10T15:38:58+00:00

    The link I provided in my initial reply explains the only procedure currently available. You don't mention even having read that reply.

    Microsoft produces software for both their own [Windows] operating System as well as for the Mac operating system. There are distinct differences which dictate that the respective programs never will have identical feature sets.

    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Jones AKA CyberTaz MVP 430.2K Reputation points
    2025-02-06T18:12:40+00:00

    Please see one of the existing Answers on the issue, such as:

    Power Query - Mac - Get File -> PDF - Microsoft Community

    0 comments
  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2025-02-07T20:44:09+00:00

    Portable Document Format (PDF) is a container that can hold data in a a variety of ways. Quite often, it's text that can be copied and pasted into an Excel worksheet, which in turn can be used as a PowerQuery data source.

    Sometimes the data is a picture that can be copied and pasted into a worksheet, as well. Then you can use the get data from picture feature in Excel to restore the data to a worksheet.

    The trick is figuring out what format the data is really in and getting it out of the PDF and into a useable format.

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2025-02-10T13:59:38+00:00

    Thank you for taking the time to explain what a PDF document is. I appreciate the effort, but I am still encountering an issue. Despite having the latest version of Microsoft Office 365, I don't have the option to "Get Data from PDF" in Excel. I would greatly appreciate any guidance or clarification from someone. I don't understand why Microsoft doesn't offer a direct solution as its their project.

    0 comments