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]
30 comments
-
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
-
Sanjay Gupta
commented
We are a MAC organization and this is presenting a hug challange for us. Please fix this at the ealriest.
-
Nomthandazo
commented
please enable this feature as it is a crucial part of daily work.
-
Jeff Kiefer
commented
Why is this not possible? Come on MSFT. It is so frustrating to pay full price for a product without access to numerous capabilities that are in the Windows version.
-
Emmitt Houston
commented
Why wouldn't MSFT want to make the user experience as seamless as possible in their products regardless of OS. Productivity within the product shouldn't be restricted to your operating system. I understand that if it truly were that easy they would have done it. Being someone who uses the product cross-platform, it's annoying to run into constant "gotcha's".
-
Anonymous
commented
When you Export a list from SharePoint it creates a .iqy file which Excel for Mac cannot use to import the list from SharePoint. Please add this or at provide a workaround for Mac users.
Thanks
Nick -
cdsmythe
commented
In our Education community we run SharePoint across all schools for students, parents and staff. We also have a mix of Windows and Mac users. Having the same functionality to Export to Excel from a SharePoint List on both platforms would be logical. Its a common need we have and this has been requested for years now in SharePoint and Excel forums. The delay isnt making Mac users switch to Windows its making our users switch from SharePoint to locally saved spreadsheets.
-
Trevor
commented
It's hard to get buy-in to make use of SharePoint lists and workflows if the data is then 'trapped' within SharePoint and can't be exported to excel (users sure love to put things in excel).
Frankly, I'm flabbergasted that this isn't seen as more of an issue. We're an all Mac shop, trying to make O365 work for us, but obnoxious issues like this really throw a wrench into things.
-
Steve Hancock
commented
I have a large client and the staff are staggered that it is not possible to export a SharePoint list to Excel on a Mac. As a Microsoft Partner I feel extremely embarrassed and am at a loss to even start trying to explain it. As Mitch mentioned - this should not need a vote - it is blindingly obvious.