Last Updated: October 19, 2017

ISSUE

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.

WORKAROUND

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.

More Resources

Icon Experts (brain, gears)

Ask the experts

Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.

Excel Tech Community

Icon Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.

Excel Forum on Answers

Icon feature request (light bulb, idea)

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

Provide feedback

Fixes or workarounds for recent issues in Excel for Mac

Need more help?

Join the discussion
Ask the community
Get support
Contact Us

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×