SOLVED

Export SharePoint List on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-323759%22%20slang%3D%22en-US%22%3EExport%20SharePoint%20List%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-323759%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20in%20a%20Mac-only%20environment%20and%20need%20to%20extract%20SharePoint%20list%20data%20for%20eventual%20manipulation%20in%20Excel.%20The%20%22Export%20to%20Excel%22%20function%20does%20not%20work%20on%20Macs%20and%20the%20%22workaround%22%20to%20this%20limitation%20is%20to%20export%20it%20using%20Windows%2C%20which%20is%20not%20an%20option%20for%20us.%20Nor%20can%20we%20connect%20to%20the%20SharePoint%20list%20using%20Excel%2C%20since%20PowerQuery%20isn't%20available%20in%20Excel%20for%20Mac.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20for%20suggestions%20how%20to%20get%20our%20data%20out%20of%20SharePoint%20in%20some%20(any!)%20format%20that%20can%20be%20ingested%20by%20Excel.%20CSV%20would%20be%20fine.%20Open%20to%20using%20Flow%20and%2For%20PowerApps%2C%20but%20needs%20to%20be%20fairly%20simple.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-323759%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-323833%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20List%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-323833%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20idea%2C%20Robin.%20I%20was%20able%20to%26nbsp%3Bcreate%20a%20proof-of-concept%20Flow%20that%20updated%20an%20Excel%20on%20my%20OneDrive%20with%20the%20list%20items%20I%20needed.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-323800%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20List%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-323800%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20just%20a%20Flow%20newbie%2C%20but%20I'd%20try%20something%20like%20this%20-%20haven't%20tested%20it%20but%20might%20give%20you%20some%20ideas%3F%3C%2FP%3E%3CP%3EManually%20trigger%20a%20flow%3C%2FP%3E%3CP%3EGet%20Items%20from%20the%20SharePoint%20list%3C%2FP%3E%3CP%3EApply%20to%20each%20-%20'value'%20is%20the%20list%20of%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3BInsert%20row%20-%20give%20it%20the%20excel%20file%20name%20and%20figure%20out%20the%20mapping%20between%20the%20rows%20and%20the%20values%20in%20the%20SharePoint%20list%20row.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20693px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F70633i553376E1523309DB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22To%20Excel.PNG%22%20title%3D%22To%20Excel.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1058657%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20List%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1058657%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266505%22%20target%3D%22_blank%22%3E%40debit72%3C%2FA%3E%26nbsp%3BI%20tried%20this%20solution%2C%20but%20insert%20row%20is%20nowhere%20to%20be%20found%20anymore%2C%20and%20I%20get%20API%20errors%20when%20I%20try%20to%20connect.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1058876%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20List%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1058876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F125908%22%20target%3D%22_blank%22%3E%40Arin%20Komins%3C%2FA%3E%26nbsp%3BLooks%20like%20it's%20been%20renamed%20this%20year.%20Use%20the%20action%20'add%20a%20row%20into%20a%20table'%20-%20you'll%20need%20to%20pre-create%20a%20table%20in%20your%20sheet%20so%20the%20rows%20have%20somewhere%20to%20attach%20to.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1060007%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20List%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1060007%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F189854%22%20target%3D%22_blank%22%3E%40Robin%20Nilsson%3C%2FA%3E%26nbsp%3BThanks!%26nbsp%3B%20Do%20you%20need%20to%20prepopulate%20columns%20in%20the%20table%20with%20certain%20columns%3F%26nbsp%3B%20I%20found%20an%20old%20reference%20for%20the%20insert%20a%20row%20which%20stated%20you%20needed%20title%2C%20empid%2C%20employeename%2C%20department%20in%20the%20table.%26nbsp%3B%20Once%20I%20added%20those%2C%20it%20seems%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1060454%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20List%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1060454%22%20slang%3D%22en-US%22%3EWow%2C%20they've%20really%20changed%20the%20excel%20connector%2C%20I%20don't%20remember%20all%20those%20options%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20just%20did%20a%20test%20and%20didn't%20need%20to%20do%20any%20kind%20of%20prepopulate%20on%20the%20table%20in%20Excel.%20I%20did%20create%20the%20table%20in%20the%20excel%20file%20first%20and%20gave%20the%20columns%20headings.%20Then%20the%20'add%20row'%20parameters%20showed%20up%20correctly%20instead%20of%20being%20labeled%20'Column%201%2C%20Column%202....'%3CBR%20%2F%3E%3CBR%20%2F%3EI%20noticed%20when%20I%20was%20testing%20that%20when%20I%20tried%20to%20do%20it%20from%20a%20trigger%20of%20'selected%20item'%20in%20a%20SharePoint%20list%2C%20that%20didn't%20work.%20That%20only%20gave%20me%20the%20information%20related%20to%20the%20person%20triggering%20the%20action.%20I%20had%20to%20do%20a%20get%20item%20to%20get%20my%20columns%20of%20information%20to%20insert.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1060858%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20List%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1060858%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F189854%22%20target%3D%22_blank%22%3E%40Robin%20Nilsson%3C%2FA%3E%26nbsp%3BI%20managed%20to%20get%20mine%20working%20using%20Created%20as%20my%20ID%20column...but%20yes%2C%20they%20very%20much%20changed%20the%20connector.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20if%20only%20we%20could%20get%20a%20%22clear%20rows%22%20action!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485902%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20List%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F189854%22%20target%3D%22_blank%22%3E%40Robin%20Nilsson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20There%2C%3C%2FP%3E%3CP%3EI%20am%20also%20using%20a%20Mac%20and%20wondering%20how%20to%20export%20a%20sharepoint%20list%20-%20the%20reason%20I%20want%20to%20is%20to%20get%20the%20many%20headings%20from%20my%20list%20so%20I%20can%20set%20up%20a%20Flow%20to%20import%20data%20from%20the%20list%20into%20Excel%20as%20items%20are%20added.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20use%20Flow%20to%20export%20the%20column%20headings%3F%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

10 Replies
best response confirmed by debit72 (New Contributor)
Solution

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.To Excel.PNG

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. 

@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.

Wow, they've really changed the excel connector, I don't remember all those options :)

I just did a test and didn't need to do any kind of prepopulate on the table in Excel. I did create the table in the excel file first and gave the columns headings. Then the 'add row' parameters showed up correctly instead of being labeled 'Column 1, Column 2....'

I noticed when I was testing that when I tried to do it from a trigger of 'selected item' in a SharePoint list, that didn't work. That only gave me the information related to the person triggering the action. I had to do a get item to get my columns of information to insert.

@Robin Nilsson I managed to get mine working using Created as my ID column...but yes, they very much changed the connector.

 

Now if only we could get a "clear rows" action!

@Robin Nilsson 

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

@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 Hey, how do you export to CSV on a mac?