Feedback by UserVoice

 

Ernest

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Get external data from the web

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Ernest shared this idea  · 

  2. Add support for Get & Transform (formerly Power Query)

    3,540 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    917 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.

    Refer to the following blog post for more details:
    https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840

    I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.

    Ernest commented  · 

    I'm trying to get external data from the web in office 2019 office on a mac. I have saved a plain test web query but when I run it I don’t nt get the data I want upload but instead d the hyperlink address in A1.

Feedback and Knowledge Base

(thinking…)