When it comes to importing content from PDF files into Excel, Mac users have had a rough deal…until now (Sidenote: Excel for Windows has been able to do this for years)
In this video, I’ll show you how Power Query in Excel Online now makes importing PDF files much easier for Mac users. No more taking screenshots. No more 3rd party apps. The functionality is there…right inside the web version of Excel
⚠️ Important limitations to be aware of:
- This works in Excel Online (Excel on the Web)
- This does not work in the Excel for Mac desktop app
- You must have a Microsoft 365 business licence
If you use Excel on a Mac and have a need to import data from PDF files, this is a small but important step forward
Download a copy of the file(s) used in this video: https://share.zight.com/RBupjd6O