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 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 →
  2. 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.

    20 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 →
  3. 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.

    20 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 →
  4. 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!

    21 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 →
  5. 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 →
  6. 4 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 →
  7. Support for OpenAPI

    It would be nice to add support for the OpenAPI standard for Get & Transform. OData is nice but OpenAPI is also becoming pretty prevalent.

    https://www.openapis.org/

    3 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 →
  8. Relative paths to text connections

    Option to have relative paths to connect to text files to import data.

    We have an xlsx file with several connections to csv files with generic names.
    We want to be able to move (or share) this file to other directories, and the xlsx file to be able to read the csv files (with the same generic names) in the new directory.

    I have posted this issue here:
    https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msomac/csv-files-paths-in-excel-2016-for-mac/215241e7-6599-4971-b598-b7e5bd2dc45d

    3 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. Repetitive Text Imports

    The Import Wizard is fine for ad hoc, 1-off imports, but I now receive weekly TXT files with a consistent layout. There should be a way for me to "build a macro" or some "template" for the Import Wizard to use (so that I don't have to tell it each week where all the columns in these TXT files are). Set it up once, and then use that Template to import the TXT files in following weeks.

    2 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 →
  10. 2 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 →
  11. 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 →
  12. [num, txt, raw] = XLSREAD(filename.xlsx); should return equally-sized variables

    NUM is a numerical array containing the numeric values from the spreadsheet. Super useful! Because it's numeric, non-numeric values need to be dealt with somehow, so they're converted to NaN. Also great! I can work with that!

    Here's the problem: any non-numeric values on the exterior of the spreadsheet (or, equivalently, of RAW) are omitted instead of being converted to NaN. THIS RUINS EVERYTHING. Indexing become messy, messy guesswork, because NUM is a different size than TXT and RAW. Please just have the function return NaNs, so that NUM can be the same size as TXT and RAW.

    1 vote
    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 →
1 3 Next →
  • Don't see your idea?

Feedback and Knowledge Base