Allow exporting of Sharepoint lists
It would be great if you could export a Sharepoint list to Excel for Mac. At present you have to use Excel on a PC - as I believe this requires some kind of ActiveX component.
David Holroyd
shared this idea
Thanks for the suggestion and the votes. We will continue to monitor the votes to help prioritize this along with other data connection requests. You may want to add a comment about connecting to SharePoint in the thread discussing PowerQuery.
Steve K [MS Excel]
38 comments
-
Anonymous
commented
Windows-only limitations are a major headache for our mixed environment - we are heavily promoting Sharepoint to our users, and specifically lists instead of Excel sheets... but then if we need the data, Mac users go crazy. Let us export our data please.
-
Phil C
commented
Way to drop the ball Microsoft, you have a powerful SharePoint tool yet you're ignoring a large chuck of the market Mac Users. Mac users make up about 10% of the market place, of that subset a small fraction recognize they're not able to do some basic functions. Stupid!
-
Anonymous
commented
This is causing me a problem in making reports to stakeholders on other teams. Sure would like to see this prioritized.
-
Anonymous
commented
It is truly astonishing that every single product I use can create some usable export format to use in excel (at least csv, or text delimited) on my mac but the makers of excel can't figure out how to do it. How lazy can you be?
-
Paul
commented
Why even show export button at all if it doesn't work? It is like you are trolling your users.
-
Anonymous
commented
Please. Add.
-
Anonymous
commented
Sigh ............over 4 years this has been waiting. Sad.
-
AdDmeaNs
commented
Vote on this functionality will not be clear.... Why ? Because customer have Macs since long time and don't know this. But professional of O365 know this functionality in SharePoint, I have several customers with this problem they don't think to stop to buy Mac, but they are seriously to switch on G-Suite.... And the biggest stupid thing that is not possible to make a flow to have an automatic export from SharePoint list to excel through Power automate. I've tried and obtain just a CSV files without all the information...(ODATA... with multiple choices, sure that you have tried too ;-) )
I don't know why it's not possible to add a setting in SharePoint to just export Excel files ? Not in .iqy format bu just an excel or a csv file. It's becoming painful... -
Anonymous
commented
I am so sick of stumbling across issues from Microsoft that aren't supported because I am on a Mac, this is so frustrating! This is discrimination ;-) ;-)
-
KC
commented
this is lame. please add iqy support
-
Gonzalo
commented
So I guess this is not fixed yet and it doesn't seem to be a priority since the original post is from July 2016, and at February 2020 STILL hasn't been fixed... Great job!!
-
Leah
commented
I'm having trouble using Sharepoint to download and upload excel files on my Mac. I can actually download the .iqy file successfully on Mac, but then Excel needs to be able to connect back to SharePoint to query that external data source. That doesn't work. This is an important feature to support for people on the Mac to be able to make use of SharePoint lists.
-
Matt Busfield
commented
Frustrating that this lack of consistency across platforms could encourage our staff to lose trust in Sharepoint. They could be forgiven for feeling their data is 'locked in' and inaccessible on a proprietary platform. Exactly the kind of reason why people start adopting more open web-based solutions. Hence more shadow IT
-
Anonymous
commented
I have voted on multiple threads with this same issue. It is ridiculous that this has not been addressed.
-
Michael Del Corso
commented
Any device, any time, right Microsoft? Come on, this is such basic, fundamental functionality that I cannot believe it still does not exist. This really just is evidence that you do not care about anything other than Windows.
-
Anonymous
commented
Really Microsoft, this is such a basic requirement. Lots of companies use Sharepoint but also are mac shops/
-
LA Smith
commented
Incredibly irritating when you work exclusively in Mac territory...
-
Kyle E
commented
Mitch yes this does require a Windows device, but as I say in my script use this with a windows server so you only need one windows device for all Windows devices. You would use some software to server out the software like Citrix, Parallels RAS, or Microsoft Remote Apps.
-
Mitch Cohen
commented
Hi Kyle. Your script, as you note, requires a Windows PC. But, with a Windows PC, we can download the file as a CSV without the script. What is the added value of the script?
-
Kyle E
commented
Guys I have a workaround that may work for you. See this: https://github.com/kylejericson/Windows/blob/master/SharePoint%20Exporter.ps1