Last Updated: October 19, 2017
When you click Export to Excel to export a SharePoint list on a Mac, it doesn't open the file in Excel for Mac and instead downloads the query.iqy file. This is working as expected as the internet query connection is not supported by Excel for Mac.
If you have Excel for Windows, you can save the file as XLSX and then open it in Excel for Mac. You'll be able to see the data but you won't be able to refresh the data connection.
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.