How to add Export to Excel button in Sharepoint

Question

I want to add a feature to export lists to Excel in Sharepoint. How can I do it?

Answer 1

Dear Muhammad Wibisono Januar

Good day! Thank you for posting in Microsoft Community. We are happy to help you.

Based on your description, generally, we can export list to Excel in SharePoint from the command bar of the list, select Export > Export to Excel.

There have the Export to Excel button in SharePoint directly. For your reference: Export to Excel from SharePoint or Lists - Microsoft Support

If you mean that you want to export multiple lists into one Excel workbook at the same time, we have to tell you that there not a direct way can achieve this requirement directly. But you can use Power Automate to achieve this. Since Power Automate is outside of our support boundaries. If you're interested in Power Automate and willing to try it. For you to be assisted properly, please post your query in Microsoft Power Automate Community - Power Platform Community the supports engineers there have the correct escalation channel, and they are specialized in this. I am sure that our experts from that team can address your query effectively and accurately.

If the scenario above is not consistent with yours, you can also post back and point that.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Stacey | Microsoft Community Moderator

Answer 2

Probably there is a misuderstanding. So, I want to correct this. My sharepoint doesn't have Export to Excel button, I want to add the feature button in my sharepoint using format view, but to no avail. Any how? I use macbook for this one. Thank you.

Answer 3

Dear Muhammad Wibisono Januar

Thank you for your quick response and we also appreciate you spent your precious time providing the detailed information to us.

If you're using SharePoint on Mac, per our test, we have to tell you that the Export to Excel button is not available in the SharePoint Online when you access it in the browser on the Mac.

We do understand the inconvenience cause due to this. We have reported this to the related product team and hope they can speed up the steps to publish the new features for users to have a better experience. We kindly suggest you submit feedback in Word · Community (microsoft.com)) . It is the best platform for the developer team to listen to your opinions and make the products better serve you and others. The Product Team is in-charge of the feedback site, and they are constantly checking the comments and feedback from our customer. Many features have been developed or improved based on users' comment.

But per our search, some user mentioned that maybe can trigger a flow to get data out of SharePoint to excel, for your reference: Export SharePoint List on Mac - Microsoft Community Hub

if you're interested in flow and willing to try it, regarding this is related to Power Automate flow. Please understand that this query is outside of our support boundaries. For you to be assisted properly, please reach out to Power Automate community by visiting this Microsoft Power Automate Community - Power Platform Community , Maybe the engineers in there can provide a solution for you.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Stacey | Microsoft Community Moderator