Feedback by UserVoice

 

How can we improve Excel for Mac?

← Excel for Mac

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.

95 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    David Holroyd shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Admin, Office.com) responded  · 

    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]

    10 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Forgot password?
      Create a password
      Signed in as (Sign out)
      Close
      Close
      Submitting...
      • Mitch Cohen commented  ·   ·  Flag as inappropriate

        Dear friends at Microsoft. Votes should not be ncessary for this. It should be obvious that this is needed. I'm not sure what PowerQuery is or why one needs to look there. We need to be able to export data from a Sharepoint list. Period. Frankly, this should be independent of Excel.

      • Robin Thakur commented  ·   ·  Flag as inappropriate

        This needs to work properly across platforms (as per Microsoft's current mantra) I was totally shocked that such basic functionality that has existed forever in the SharePoint world has been stripped out on a Mac. This won't get users to install Windows, I will get them to dump SharePoint.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I have spent hours on this looking for a workaround, but it doesn't exist. The fact that Mac users are unable to perform a very simple function like exporting lists to excel is staggering. This is a very basic function and shouldn't be exclusive to Windows users. This needs to be fixed ASAP.

      • George commented  ·   ·  Flag as inappropriate

        Upvote this. I somehow managed to get the .igy file but it won't open in excel it is greyed out.

      • Adam Duggan commented  ·   ·  Flag as inappropriate

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

      Excel for Mac: Data Import

      Feedback and Knowledge Base

      (thinking…)