Feedback by UserVoice

Excel for Mac

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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

    For days when prices are not available such as hols - instead of a n/a please use 0. Whilst trying to do an average of stock history prices is there is a n/a int eh column no formulas work as there is a n/a in a cell

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  2. do not convert space char(32) to Non Blanking Space char(202) on data import/paste

    Excel for Mac converts 'regular' spaces [ char(32) ] to Non Blanking Spaces [if using MacOS Roman ] which is char(202). Those characters are not removed by TRIM. The conversion is extremely problematic for data import / export and data clensing. This behaviour is platform, character set specific. I've seen it also happen on Windows where the regular space, when using UTF-8, is converted to Char(160).

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  3. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  4. Make decimal separator selectable

    In Excel Windows you can choose between point or comma as decimal separator. In Excel Mac you cannot. About half of the world uses comma like Sweden and imported documents from the U.S. and some other countries always cause a lot of problems. So please let me set point or comma as decimal separator for each document.

    The ideal solution would of course be a new separator that would be standard all over the world and Microsoft together with international bodies.
    https://en.wikipedia.org/wiki/Decimal_separator

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  5. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  6. Include connectivity to cryptocurrency price updates

    Include dynamic connectivity to cryptocurrency price updates via API

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  7. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. Excel for Mac change defaul CSV import separator

    Every time I open a CSV file on my Mac I need to reformat the file as the default separator is a TAB. I suggest including a setting to change the default CSV separator configuration. Ref.: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-for-mac-permanently-change-text-imp-wizard/59a02758-a758-4e13-9b0c-6e748fd5a43d

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow me to upload my excel worksheets to my drive multiple times.

    Allow me to upload my excel worksheets to my drive multiple times. Please.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  10. Increase capability of STOCKHISTORY function

    The STOCKHISTORY function is great for getting the price history of one stock. Three suggestions:
    1. It could offer more utility if it could get the stock history for multiple stocks, and align the values with respect to dates. For example, if I wanted monthly close values for 8 stocks over a 4-year time range, it could return an array of 9 columns (1 date and 8 stock values) and 49 rows (1 header row and 48 monthly data rows).
    2. In addition to "daily", "weekly" and "monthly", it would be nice to have interval choices of "quarterly" and "yearly". …

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  11. Stock quotes

    I have created a spreadsheet with stock quotes linked to it, I have discovered that when I protect the page the stocks will no longer update unless I unprotect the sheet. I think I could probably unprotect the individual cells and then it should work, but that would prevent the page from being protected from kids that may wander onto it.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  12. Get Excel to work with Yahoo Finance Web Page doing Web Query

    I’m **** a Web Query on Office 365 (Excel) for Mac using Yahoo Finance to get my data to insert into my Excel spreadsheet. Yahoo Finance webpage has 9 tabs. Only the Summary Tab works for my Web Query. When I use the Performance Tab which is the one that has the data that I want for my Web Query, it doesn’t work. This is not password protected as it just another tab on the Web Page. Can the MS Developers get this to work.
    The "performance" tab on Yahoo Finance has the financial data that the "summary tab" does…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  13. Get Excel to work with Yahoo Finance Web Page doing Web Query

    I’m **** a Web Query on Office 365 (Excel) for Mac using Yahoo Finance to get my data to insert into my Excel spreadsheet. Yahoo Finance webpage has 9 tabs. Only the Summary Tab works for my Web Query. When I use the Performance Tab which is the one that has the data that I want for my Web Query, it doesn’t work. This is not password protected as it just another tab on the Web Page. Can the MS Developers get this to work.
    The "performance" tab on Yahoo Finance has the financial data that the "summary tab" does…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  14. SQL ODBC for Excel Mac with M1 chip

    Hello,
    It seems SQL ODBC driver is not working (or even included) in the latest version of Excel for M1 chip.
    Would you have visibility on when this feature would become available please?
    Thank you,
    vince

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  15. Ability to import xml files

    We have to jump through hoops to import a xml file in Excel for Mac. What I can find is basically not understandable. I am paying a yearly subscription and expect more than this. Once I learn how to use Numbers and Pages I will be cancelling my subscription. I will learn how to use those before I continue struggling with this.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add Apple Card to Money in Excel

    I cannot seem to add the Apple Card to Money in Excel (probably Apple's fault), but they have recently made it possible to access my account without being forced to use my phone, so maybe its possible now.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add The Federal Thrift Savings Plan to choices for investments in Plaid

    I can not include my account in the TSP account to the budget program

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  19. Data Types Missing for MacOS (i.e. Food, Chemistry, Element, Space etc.)

    Data Types for MacOS are only Stocks and Geography. For Windows there are more data types available. Why is that? Is there a fix anyone knows? I am running the latest MacOS and Excel Office 365. Any help is appreciated!

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  20. Importación de tablas de páginas web

    Excel para Mac no puede importar datos de páginas web. Debería ser posible. ¡Gracias!

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6 7
  • Don't see your idea?

Feedback and Knowledge Base