Feedback by UserVoice

hokie

My feedback

  1. 4,031 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

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

    Hi all! We are happy to let you know that in addition to refreshing your data from supported sources, you can now import data from local files such as Excel workbooks, and Text and CSV files with Power Query in Excel for Mac. This new functionality is available to Beta channel users running version 16.50 (build 21050400) or later.
    You can check out the blog for this new feature here: https://insider.office.com/en-us/blog/import-data-from-local-files-with-power-query-in-excel-for-mac
    For more information about Power Query features that are currently supported in Excel for Mac, please take a look at the following support article: https://support.microsoft.com/office/7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5

    Inbar Privman
    Product Manager, Excel Team

    An error occurred while saving the comment
    hokie commented  · 

    Excel 16.41 for mac:
    "At this stage you can refresh from text, CSV..." it's an absolute lie, it does not work.
    Query created on Excel for windows (it works with a windows path) but it does not work with a osx path in a Mac.
    let
    Source = Csv.Document(File.Contents("/Users/username/filename.csv"),[Delimiter="#(tab)", Columns=15, Encoding=65001, QuoteStyle=QuoteStyle.None])
    in
    Source

Feedback and Knowledge Base