Looking over this thread , I think I have done a poor job of explaining what I am trying to do. I have a windows folder that contains some mp3 files. Using windows and going into this folder I can select certain metatdata properties from the files. I want to have the folder show title, contributing artist, file size, Album, Author, and things like this.

I can select the metadata properties I want and they show up in the windows folder. Now I want to take the windows folder, with the existing selected metadata propeeties, and export that to a spreadsheet, and I want the spreadsheet to show all the metadata properties I have selected organized into columns that can be sorted or otherwise changed. . When trying to use power query to do this, my output of the wiondows folder only contains certain metadata fields, not all the ones I have selected, and some I haven't selected. So either I am using power query wrong, or power query does not do this for me, in which case maybe I need a different program.

Hopefully my new explanation makes more sense. Thanks again all