Power Query lets you perform a series of steps to transform your Excel data.

One of the possible steps that surprised me was that I could list out the files in my computer! 

This is useful if you want to do some analysis on your file list (i.e. finding a file, checking which files have the biggest size to clear up space).

DOWNLOAD EXCEL WORKBOOK

 

Let’s go through the steps in detail:

STEP 1: Go to Data > New Query > From File > From Folder

(In Excel 2010 & 2013 you need to go to Power Query > From File > From Folder)

inventory-01

 

STEP 2: Type in the path you want to list the files from.  You can also Browse for the folder.  Click OK.

inventory-02

STEP 3: This will give you a preview the file list.  Click Edit to examine it more inside the Power Query editor.

inventory-03

STEP 4: You are now inside the Power Query Window.

You can add more information into your Table by clicking the Icon beside Attributes.

inventory-05

 

For example we want to include the Size column.  Uncheck (Select All Columns) and check Size.  Click OK.

inventory-05

 

The size column is now shown.

inventory-06

 

STEP 5: Click Close & Load from the Home tab and this will automatically open up a brand new worksheet in your Excel workbook with the new data.

inventory-07

 

You now have your spanking new file list!

inventory-08

 

HELPFUL RESOURCE:

380x230

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn