Are you an Excel for Mac Power Query user? Are you frustrated with missing Get Data functionality (compared to Excel for Windows)?
If so, check out this add-in!
Microsoft have done a great job with adding Power Query to Excel on the Mac. However, compared to Power Query in Excel on Windows, when it comes to Get Data, there are several missing options.
This week I came across a free addin called MoreQuery for Mac which attempts redress the balance by adding four additional data sources under Get Data, two of which I’m going to cover in this video – Get Data From Range and Get Data From Folder.
I’d like to say a huge thank you to Suat Ozgur who wrote the addin and Bill Jelen for sharing it on LinkedIn
Download
You can download the addin from: https://www.mrexcel.com/download-center/2023/05/morequery.zip
Installation
- Extract the morequery.xlam file from the download and save it somewhere you will remember.
- Launch Excel, click the Tools menu item and Excel Add-ins button.
- Click the Browse button to locate the add-in, and then click OK.
If you have support queries please contact Suat directly. His email address is embedded in the VBA code of the addin