Feedback by UserVoice

Excel for the web

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 web version of Excel's feedback 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. Power Query: Make it easier to connect to files on OneDrive and SharePoint

    Connecting to Excel files stored on OneDrive and SharePoint is a difficult and confusing experience. While it is possible, it is far too difficult.

    As more and more move to working in an online environment we need a simple way of connecting.

    282 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

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

    Thank you for showing passion for Power Query and various improvements! We are indeed looking to implement this suggestion.

    In general, we’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like these ideas.

    Thanks!
    Jonathan Kahati
    [PM @ Excel]

  2. Refresh queries from Excel Online

    We would like suggest you enable feature of refreshing the query on the excel online app.
    User created a file that creates/refreshes a query into a SharePoint site, all works fine when you are under Excel desktop app, but if you open the same file an try to refresh queries from Excel Online, it throws an error saying the external data refresh failed.
    It would seem that having the capability to refresh a query would be a common feature not specific to the desktop version. This is a bit disappointing, and makes online Excel a less attractive product.

    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 →
  3. add additional durations for "return()"

    Stock data information is great!

    the maximum duration for return is presently 5 year. Would be very helpful if 10 year and 15 year durations could be added.

    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. Create IMPORTRANGE function much like google sheets

    I don't see an equivalent of Google's IMPORTRANGE to index data live from another workbook.

    27 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

    3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  5. import data from text file into excel online

    To all,

    I wished that excel online had the ability to import data from a TXT or CSV file from a location in onedrive. This would be a game changer for me and some of my personal reports.

    tks,

    Eduardo Simas

    6 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 →
  6. Implement an analytic tool for Excel online

    The analytic too for Excel client doesn’t work for Excel online. I would like you to implement an analytic tool for Excel online.

    8 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 →
  7. When I type a character in the formula bar and convert it, it doesn't enter in the cell.

    *English follows Japanese

    ■Title(件名):
    数式バーに文字を入力し変換してもセルに入力されない。
    When I type a character in the formula bar and convert it, it doesn't enter in the cell.

    ■Description(内容):
    iPad で Excel ファイルを Excel for the web で開いた場合、数式バーに文字を入力し変換してもセルには変換前の文字が入力される。
    変換後の文字が入力されるよう機能の改善を希望します。

    When you open an Excel file in Excel for the web on an iPad, the cell is entered before the conversion character when you type and convert characters in the formula bar.
    Please improve the function so that the converted character is entered.

    5 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 →
  8. Data Streamer for Mac

    So many Mac users, how about allowing us to stream data as well?

    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

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  9. Excel stocks data type tab

    Hi I was wondering if you could add the following to the drop down boxes on the Excel Stocks Tab

    Year open or YTD yield
    200 SMA value
    50 SMA value
    20 SMA value
    Bollenger Band amt
    RSI

    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. full parity between Power Query from Power BI and Power Query Excel

    Power BI always gets new M functions and features first. The Power Query editor in Excel however, lacks behind a lot. Many functions that are generally available in Power BI desktop never make it to Power Query Excel.

    for example: the M function Html.Table has been available more that 2 years in Power BI desktop. But sadly still isn't supported in Excel 365.

    Please make all functions and features of the Power Query editor in the free software "power BI desktop" also available in the paid subscription of "Excel 365".

    5 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 →
  11. Update workbook external-source data automatically

    we have a master workbook which linked some external workbook cells with "=()" function. We are using powerBI to get data from the master workbook for visualization, but data doesn't get refreshed until we open the master workbook. Hope the data can be refreshed without having to open the master excel workbook.

    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. 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. Please add 'full HTML formatting' option in excel 365 to import data from web

    Please add 'full HTML formatting' option in excel 365 to import data from web

    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 →
  14. 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. 2029 Rule defeats Windows Regional Defaults (using 2016 for PC)

    Enable copy/paste of two digit years to arrive in Excel in the desired century (20xx vs. 19xx).

    My issue is copy/pasting from another app into Excel where the '2029 Rule' overrides Windows Regional Settings. The rule causes data coming in from another App (e.g., MS Project) to paste as 19xx for any date after 12/31/2029. Though displayed as two digits, the values in the source app stored as four digits. More importantly, regional setting defaults clearly direct the correct interpretation of later two digit dates into the 21st century.

    The easiest workaround is to update the source data to display…

    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

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  16. Insert image in a cell

    Insert Image in a cell, with various options of adding the file to the cell, like from camera or from a gallery or from a any one drive.
    This option is currently available in google and can be implemented in MS-Excel, due to this the productivity is enormous in construction industry.

    I request upon to bring it as soon as possible.

    9 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 →
  17. stock data: include Singapore stock exchange

    stock data: include Singapore stock exchange

    7 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

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  18. Access to Charles Schwab

    Charles Schwab (not a small company) is one of the institutions you list to link from to Excel Money. Yet, when I attempt to it says it can't because of multi-factor authentication. I phoned Schwab (Schwab Bank is my primary bank; without access, Excel Money is useless to me) and Schwab said you would have to request access. Incidentally, my small credit union accesses my Schwab accounts (brokerage and bank) and regularly updates balances in credit union data automatically. So there must be a way. If my small credit union can do it, I'm sure MS can!

    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. Enable the Power Query as a native web experience

    It would be nice if we can have a native Power query experience on the web. You have it in Flow called Power Query. Cant we add this as a tab. And also allow people to use Power Pivot in the Excel Workbook. To start if we can import csv files , excel files and json files from a one drive or sharepoint list. Later from Azure blobs would be very nice.

    This will help doing alot of manual work. Can we also increase

    8 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 →
  20. cells to link in excel files online

    We need the cells to link in excel files online.

    Necesitamos que las celdas de vinculen en archivos excel online.

    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 →
← Previous 1 3 4 5 6 7
  • Don't see your idea?

Feedback and Knowledge Base