Feedback by UserVoice

Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

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. Add Power BI Dataflows as a data source in "Get & Transform Data"

    Please add Power BI Dataflows as a data source so that I can import data from a Dataflow into the local spreadsheet/data model.

    https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use

    349 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

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

    Thanks everyone for showing a lot of passion about Dataflows data connector in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.

    Guy Hunkin
    Principal Program Manager
    Excel Team

  2. Add support for custom data connectors (Power Query M extensions)

    Custom Data Connectors mechanism is being developed by Power BI Desktop team:

    Excel's Get & Transform engine (Power Query) should have support for .mez/.pqx extensions too.

    118 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

    10 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add short month name and short day name in Power Query

    In Power Query, you can convert a date in year, month, day, first day of the month, day of the week, .... You can also convert a date in month name or in day name.

    But there is no option to convert a date with the short name (Jan, Feb, Mar, ...) and the same for the day (Mon, Tue, Wed, ...)

    Is it possible to add these options on the ribbon?

    43 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 →

    Thanks everyone for showing a lot of passion for adding short month name and short day name to the Power Query in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.

    Inbar Privman,
    Program Manager, Excel Team

  4. Improve Queries and Connections Task Pane

    Having used the newfangled Queries and Connections pane for some time now I find it is time to add some suggestions

    My issues:


    1. The pane does not remember its size
      It opens really narrow on my system, displaying only a (very) small part of the connection and query names so my first action every friggin time is to drag it wider.


    2. No multi select
      in the old connections window you can control or shift-click multiple connections to delete them. For maintenance this is a very useful feature I miss regularly.


    3. It isn't application-centric
      If I open a new workbook with…

    36 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

    5 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 some of these suggestions.

    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]

  5. Add UnDo to PowerQuery

    PowerQuery is one of the best improvements added to current EXCEL! When importing data from almost all relevant sources, I can undo each single step of data-Import or transformation, even in non-temporal order.
    BUT: if i drop a hole query, delete a table or something that is not in the steps list, or if i delete a step: this cannot be undone.
    Please allow UNDO for
    deleting queries
    deleting steps
    changing steps
    (not adding wrong steps, this can be undone with deleting the step)

    This would be a very great improvement! Today i deleted a query with many, many steps…

    61 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 →

    Thanks everyone for showing a lot of passion for adding undo button to the Power Query editor in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.

    Inbar Privman,
    Program Manager, Excel Team

  6. "Power BI Service" as a data source in "Get & Transform"

    It would be awesome if "Power BI Service" is added as a data source under "Get Data" in "Get & Transform Data" in Excel. Though the source availability is already there with "Power BI Publisher Add-in" but it is buggy and hard to deploy on large number of laptops/desktops. Also, it is practically very difficult to educate down the line users about re-enabling this add-in via COM Add-ins in case it disappears from the ribbon which is very frequent in case of this add-in. We have been struggling with this for a long period of time now.

    Considering "Power BI…

    39 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

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

    Hi Deepak,

    Thanks for logging this issue. I agree this would be quite useful, especially as Power BI is emerging as a hub for business data.

    This request is slightly different than what PBI Desktop does. PBI Desktop essentially provides a Live Connect essentially deferring the model to the service and limiting the experience to visualizations so it’s not importing data into the report. So there’re two possible outcomes you could be looking for:
    1. Allow users to import data into Excel as query tables, just like one can from an external store like SQL Server or Oracle. This provides fine grained data retrieval.
    2. Create a new PivotTable that summarizes data on PBI service.

    The PBI Publisher addin performs #2. Is that what you’re looking for? Or would you rather have #1 if you had to choose?

    Others coming new to this suggestion, please be sure to add your…

  7. Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

    The Query Editor allows you to easily create Year, Month, Month Name etc, but many people need Fiscal Month Number and Fiscal year

    46 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

    4 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add a setting/option where all CSV/delimited files are opened as "Text"

    Add a setting called
    "Open text-delimited files (CSV, etc) as text only, with no type inference."

    When this setting is active, then every column's format will be "Text" when a CSV or other such file is opened, so that the initial view is exactly the text represented in the CSV.

    70 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

    31 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base