Forum Discussion

debit72's avatar
debit72
Copper Contributor
Jan 22, 2019
Solved

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 limitat...
SharePoint Online
  • Robin Nilsson's avatar
    Robin Nilsson
    Jan 22, 2019

    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.

KittyKat1082's avatar
KittyKat1082
Copper Contributor
Apr 23, 2021

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!

  • stephenmwilliams's avatar
    stephenmwilliams
    Copper Contributor
    Mar 15, 2023

    KittyKat1082 Hi - how did you get this to work? I don't find an option available to export to Mac.

    • KittyKat1082's avatar
      KittyKat1082
      Copper Contributor
      Mar 15, 2023

      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.

  • leobcrtico's avatar
    leobcrtico
    Copper Contributor
    Jun 03, 2021

    KittyKat1082 Hey, how do you export to CSV on a mac?

Resources