Import data from local files using Power Query in Excel for Mac

Published 05-19-2021 10:00 AM 3,736 Views
Microsoft

We are excited to announce a new update to Power Query (PQ) in Excel for Mac – the ability to import data from local files.  We’ve received many requests for this feature after the introduction of PQ query refresh.  Now you can import data from local files including Excel workbooks and text & CSV files.

 

Getting started

This new functionality is available to Beta channel users running version 16.50 (build 21050400) or later.  See this support article to check which version you’re using.

 

Importing data from local files

You can now import data from local Excel workbooks or text & CSV files.

  1. Click Get Data (Power Query) on the Data tab
  2. Select Excel workbook or Text/CSV in the Choose data source dialog box
  3. Click Browse to select the local file
  4. Select the data you want to import and click the Load button

 

Import data from local filesImport data from local files

 

For a feature deep dive, see Import data from local files with Power Query in Excel for Mac on the Office Insider Blog.

 

Sharing your feedback

Let us know what you think.  Send us your feedback via Send a Smile/Frown button at the top right.

 

Also, subscribe to our Excel Blog and join our Excel Community to stay connected with us and other Excel fans around the world.

 

3 Comments

Step by step PQ for Mac is improving, great to know.

Senior Member

This is very good news - many thanks indeed.  Keep up the good work!

Pieter

Respected Contributor

Great step forward! Anxiously awaiting the day that the greyed out menu options become available

Screenshot 2021-05-26 at 15.45.53.png

%3CLINGO-SUB%20id%3D%22lingo-sub-2369079%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20local%20files%20using%20Power%20Query%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2369079%22%20slang%3D%22en-US%22%3E%3CP%3EStep%20by%20step%20PQ%20for%20Mac%20is%20improving%2C%20great%20to%20know.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2387411%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20local%20files%20using%20Power%20Query%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2387411%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20very%20good%20news%20-%20many%20thanks%20indeed.%26nbsp%3B%20Keep%20up%20the%20good%20work!%3C%2FP%3E%3CP%3EPieter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2387424%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20local%20files%20using%20Power%20Query%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2387424%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20step%20forward!%20Anxiously%20awaiting%20the%20day%20that%20the%20greyed%20out%20menu%20options%20become%20available%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-26%20at%2015.45.53.png%22%20style%3D%22width%3A%20466px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283879i79629EA0BBFC3E58%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-26%20at%2015.45.53.png%22%20alt%3D%22Screenshot%202021-05-26%20at%2015.45.53.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2365521%22%20slang%3D%22en-US%22%3EImport%20data%20from%20local%20files%20using%20Power%20Query%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2365521%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20excited%20to%20announce%20a%20new%20update%20to%20Power%20Query%20(PQ)%20in%20Excel%20for%20Mac%20%E2%80%93%20the%20ability%20to%20import%20data%20from%20local%20files.%26nbsp%3B%20We%E2%80%99ve%20received%20many%20requests%20for%20this%20feature%20after%20the%20introduction%20of%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fget-amp-transform-power-query-in-excel-for-mac-phase-1%2Fba-p%2F876840%22%20target%3D%22_blank%22%3EPQ%20query%20refresh%3C%2FA%3E.%26nbsp%3B%20Now%20you%20can%20import%20data%20from%20local%20files%20including%20Excel%20workbooks%20and%20text%20%26amp%3B%20CSV%20files.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EGetting%20started%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EThis%20new%20functionality%20is%20available%20to%20Beta%20channel%20users%20running%20version%2016.50%E2%80%AF(build%2021050400)%20or%20later.%26nbsp%3B%20See%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fabout-office-what-version-of-office-am-i-using-932788b8-a3ce-44bf-bb09-e334518b8b19%23ID0EAAAACAAA%3DMac%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Esupport%20article%3C%2FA%3E%20to%20check%20which%20version%20you%E2%80%99re%20using.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EImporting%20data%20from%20local%20files%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EYou%20can%20now%20import%20data%20from%20local%20Excel%20workbooks%20or%20text%20%26amp%3B%20CSV%20files.%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EClick%20Get%20Data%20(Power%20Query)%20on%20the%20Data%20tab%3C%2FLI%3E%0A%3CLI%3ESelect%20Excel%20workbook%20or%20Text%2FCSV%20in%20the%20Choose%20data%20source%20dialog%20box%3C%2FLI%3E%0A%3CLI%3EClick%20Browse%20to%20select%20the%20local%20file%3C%2FLI%3E%0A%3CLI%3ESelect%20the%20data%20you%20want%20to%20import%20and%20click%20the%20Load%20button%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PQimportfromlocalfiles.gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281749i523C22EE83812CE5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22PQimportfromlocalfiles.gif%22%20alt%3D%22Import%20data%20from%20local%20files%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EImport%20data%20from%20local%20files%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20a%20feature%20deep%20dive%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-us%2Fblog%2Fimport-data-from-local-files-with-power-query-in-excel-for-mac%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EImport%20data%20from%20local%20files%20with%20Power%20Query%20in%20Excel%20for%20Mac%3C%2FA%3E%20on%20the%20Office%20Insider%20Blog.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESharing%20your%20feedback%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3ELet%20us%20know%20what%20you%20think.%26nbsp%3B%20Send%20us%20your%20feedback%20via%20Send%20a%20Smile%2FFrown%20button%20at%20the%20top%20right.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlso%2C%20subscribe%20to%20our%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlblog%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20Blog%3C%2FA%3E%26nbsp%3Band%20join%20our%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FExcelCommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20Community%3C%2FA%3E%26nbsp%3Bto%20stay%20connected%20with%20us%20and%20other%20Excel%20fans%20around%20the%20world.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2365521%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PQimportfromlocalfiles.gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281748iCE70B8E3EF9DBCEC%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22PQimportfromlocalfiles.gif%22%20alt%3D%22PQimportfromlocalfiles.gif%22%20%2F%3E%3C%2FSPAN%3EImport%20data%20from%20local%20files%20using%20Power%20Query%20in%20Excel%20for%20Mac%20now%20available%20to%20Beta%20channel%20users%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2365521%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎May 26 2021 12:35 PM
Updated by: