Feedback by UserVoice

Excel for Mac

Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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.

    159 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    27 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    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]

  2. Support Internet Query Connection (.iqy files)

    It would be helpful for Excel to Mac to support internet query connections.

    When exporting a list from Sharepoint, the .iqy file is downloaded, which I subsequently can't open in Excel for Mac.

    47 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  3. Import CSV with multi-line text cells

    Importing of CSV files which contain multi-line values (line breaks in the text cells) is not possible using the "File" - "Import" wizard. It is however possible if all options (field delimiter and text qualifier) match the system's defaults to import such files by double clicking the CSV. Please fix the Import wizard to allow multi-line text while customising the delimiters.

    33 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  4. Provide data get and tranform including JSON to Excel transformation

    This feature is provided with Windows Excel 2016 but not with Mac. Isn't it time to make the Mac software a first-class citizen with Microsoft. It seems like forever that Microsoft started supporting Mac Office, yet it still does not have all the features. Why not? I am paying you every month. Yet you still don't provide many advanced features. I will consider Pages then.

    21 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  5. get rid of the "Data connections have been disabled" error message that appears every time you import anything.

    get rid of the "Data connections have been disabled" error message that appears every time you import anything.

    19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  6. Open files with alternative extensions

    I'd like to be able to open files with arbitrary file extensions.

    Many files I have or work with are tsv files, but don't always have that extension, and it's not even an option to open them in Excel!

    19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  7. Excel 2016 Please return the "enable: all files" in the text import box so we can import files that have extensions other than .txt

    Excel 2011 had the option at the bottom to switch to "all files" when importing text files so that files that had extensions other than .txt would not be greyed out. This is now gone in Excel 2016 so it is impossible to import text files that have other file extensions unless you rename them (which is very impractical for me).

    Please put the option back! I want to be able to import .dat, .ici, .ocw and so on as I used to on Excel 2011.

    18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add Excel Data Model for Mac users

    Allow mac users to work with Excel Data model.

    Now it is only avaiable for PC users.

    16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow users to set the default format to use for cut and paste

    Currently if I paste data into Excel from the internet or another workbook, the default is to use the source format. If I set the preferences to display format options, I can then select an option to display the data in the destination format. I have to do this every time, but I ALWAYS want to display the data in the destination format - so I need to be able to reset the default to use destination format, but I cannot change this. You need to make the default format user-defined.

    16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  10. Unable to insert pdf files as an objects

    Enabling insert pdf file as an object. Currently only word can be added as an object...

    16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  11. Fix ODBC and/or JDBC Connectivity in Excel for Mac 2016

    Currently Excel for Mac 2016 fails to connect to our system using a JDBC connector provided by OpenLink. This could be brushed off, however Excel for Mac 2011 works perfectly on the same system.

    The connection is made and data is correctly imported using 2011, but not 2016 on the same system. It fails with the following pop-up error via 2016:

    [OpenLink][ODBC][JDBC Server]java.lang.NoClassDefFoundError: com/ibm/as400/access/AS400JDBCDriver

    This would appear to be an OpenLink or Java error, however this is consistently reproducible on the same system with 2016 and works fine on the same system with 2011 via the same file.

    14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add "query from Web" for Mac version

    Add "query from Web" for Mac version

    12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  13. Stock Quotes

    Add formula to add stock quotes in realtime, like google sheets has the ability to do. I don't want to run a excel add-on to find these quotes. This would be very helpful.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  14. stock quotes

    Pull Stock Quotes real time from MS Finance.

    As Microsoft has data already for MS Finance, a simple formula like =GOOGFINANCE can make Excel amazing. Now I switch between Excel and Google Sheets.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  15. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow copy/paste fraction input w/o converting to a freaking date!!!

    Excel for Mac insists upon converting a fraction into a date. Believe or not, people still use fractions, and number/number is not always a date.

    Allow copy/paste fraction input w/o converting to a freaking date!!!

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add option to insert pdf in excel

    Inserting pdf into excel file doesn't work in Mac.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  18. ssas

    Allow Excel for Mac to connect to MS SSAS cubes.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  19. When opening a CSV file, make Excel recognise it as a CSV file!

    Currently when I import data from a CSV file, Excel doesn't recognise that it is CSV even though the file name ends in ".csv"! I have to tell the program that the data file has delimited fields and define the separator as comma for it to import the data correctly. Surely this is basic stuff for a program like Excel?

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  20. Fixed Width Data Import Wizard Needs Scroll Bars Like Windows Version

    The fixed width data import wizard does not allow horizontal or vertical scrolling in the data preview like it does in the Windows version. This makes it impossible to create or edit Connections for complex text data files. I see at least one other person here with the same request and the issue is far from a new one to me.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

Feedback and Knowledge Base