Microsoft 365 and Office | Excel | For home | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How to import data table from PDF on Excel for MAC
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.
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: