Feedback by UserVoice

Paul

My feedback

  1. 3,846 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    987 comments  ·  Excel for Mac » Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    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.

    Paul supported this idea  · 
    An error occurred while saving the comment
    Paul commented  · 

    Just to add my voice to this request. JSON output is becoming more and more common, and we need tools that will allow us to take this output and import it into spreadsheets without having to write our own JSON deserialisation code.

Feedback and Knowledge Base