How to import data table from PDF on Excel for MAC

Michael Merritt 0 Reputation points
2026-01-30T21:55:01.0033333+00:00

How to import data table from PDF on Excel for MAC

Microsoft 365 and Office | Excel | For home | MacOS
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Bob Jones AKA CyberTaz MVP 432.3K Reputation points
    2026-01-31T15:08:52.6666667+00:00

    You can try using the From Picture tool in the Get & Transform Data group on the Data tab of the Ribbon. Results will vary depending on the actual PDF structure.

    Another approach using the same tool is to open the PDF in a reader, copy the table then use the From Clipboard option.

    0 comments No comments

  2. Q&A Assist
    2026-01-30T21:56:08.5033333+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    Excel for Mac does not support extracting data from PDF files. Therefore, you won't be able to import a data table directly from a PDF into Excel on a Mac. This limitation is important to note when working with PDF files in Excel for Mac.


    References:

    0 comments No comments

Your answer

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