Forum Discussion
Export SharePoint List on Mac
We are in a Mac-only environment and need to extract SharePoint list data for eventual manipulation in Excel. The "Export to Excel" function does not work on Macs and the "workaround" to this limitation is to export it using Windows, which is not an option for us. Nor can we connect to the SharePoint list using Excel, since PowerQuery isn't available in Excel for Mac.
I'm looking for suggestions how to get our data out of SharePoint in some (any!) format that can be ingested by Excel. CSV would be fine. Open to using Flow and/or PowerApps, but needs to be fairly simple.
I'm just a Flow newbie, but I'd try something like this - haven't tested it but might give you some ideas?
Manually trigger a flow
Get Items from the SharePoint list
Apply to each - 'value' is the list of items.
Insert row - give it the excel file name and figure out the mapping between the rows and the values in the SharePoint list row.
12 Replies
debit72 FYI this feature is now available by default for Macs! There's now an option to Export to CSV that actually works on a Mac. Found that out today!
KittyKat1082 Hi - how did you get this to work? I don't find an option available to export to Mac.
stephenmwilliams in the list you can click the export button and it gives you an option to export to CSV or to PowerBI. I am using Chrome, and a Sharepoint Online site.
KittyKat1082 Hey, how do you export to CSV on a mac?
debit72 I tried this solution, but insert row is nowhere to be found anymore, and I get API errors when I try to connect.
Arin Komins Looks like it's been renamed this year. Use the action 'add a row into a table' - you'll need to pre-create a table in your sheet so the rows have somewhere to attach to.
Robin Nilsson Thanks! Do you need to prepopulate columns in the table with certain columns? I found an old reference for the insert a row which stated you needed title, empid, employeename, department in the table. Once I added those, it seems to work.
I'm just a Flow newbie, but I'd try something like this - haven't tested it but might give you some ideas?
Manually trigger a flow
Get Items from the SharePoint list
Apply to each - 'value' is the list of items.
Insert row - give it the excel file name and figure out the mapping between the rows and the values in the SharePoint list row.
Hi There,
I am also using a Mac and wondering how to export a sharepoint list - the reason I want to is to get the many headings from my list so I can set up a Flow to import data from the list into Excel as items are added.
Is there a way to use Flow to export the column headings?
Thank you
Thanks for the idea, Robin. I was able to create a proof-of-concept Flow that updated an Excel on my OneDrive with the list items I needed.
