SharePoint list Export to Excel on Mac

Question

Hello All,

Is there any feature that we can export SharePoint list data to Excel on Mac? Thanks

---

Knowledge is power.Information is wealth.

Answer 1

Hi SharePoint2016,

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.

Below article for your reference:

https://support.office.com/en-us/article/can-t-export-a-sharepoint-list-to-excel-for-mac-641b0eab-2b7d-490e-9f42-c216b053edb9

You can use the codeplex solution to export as well.

https://archive.codeplex.com/?p=sharepointexporttoexcelinmacos

Thanks & Regards,

---

sharath aluri

Answer 2

I don’t think its a proper solution when we cannot the refresh the data. How about get external from a SharePoint list?

---

Knowledge is power.Information is wealth.

Answer 3

Get external data**

---

Knowledge is power.Information is wealth.

Answer 4

I am kind of confused with your question. you are asking how the end users get the data ? if that is your question well i say it is what it is that is the Microsoft article i sent you. Assist me if you think that's not the question you asked.

Thanks & Regards,

---

sharath aluri

Answer 5

Yes Sharath. Users has to see the data on Excel on demand.

---

Knowledge is power.Information is wealth.

Answer 6

Thank you for the confirmation. I can only say you have to use the work around process for Mac Users, I don't think is there any other way other then i have provided.

Thanks & Regards,

---

sharath aluri

Answer 7

Anything about Excel viewer webpart

---

Knowledge is power.Information is wealth.

Answer 8

I am confused you said you need to export list data to excel in Mac. how come that has any relation with excel viewer webpart ?

Thanks & Regards,

---

sharath aluri

Answer 9

any custom code?

---

Knowledge is power.Information is wealth.

Answer 10

No need of custom code and i don't think any code will work as well. You can use the workaround from below codeplex for SharePoint Export to Excel in MacOS.

https://archive.codeplex.com/?p=sharepointexporttoexcelinmacos

Thanks & Regards,

---

sharath aluri

Answer 11

Hi SharePoint 2016, 

If a reply helps you, please remember to mark it as an answer. 

Thanks for your understanding.

Best Regards,

Lisa Chen

---

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [e-mail].

SharePoint Server 2019 has been released, you can click here to download it.
Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

Answer 12

Hi Lisa,

I went to that link , but its a VS Sln file. Do you want me to deploy it to the site?

---

Knowledge is power.Information is wealth.

Answer 13

This is WSP which is not going to work on SPO. I am looking for some add-in /spfx code.

---

Knowledge is power.Information is wealth.

Answer 14

Hello Sharath,

I found a very simple solution. Straight forwarded and No-code solution. Works perfectly fine in browser and desktop app both on Windows and Mac.

I am sharing the simple solution here so that it will be benefited for everyone. 

Microsoft FLOW

---

Knowledge is power.Information is wealth.

Answer 15

Please share the Flow