Hello my learned friends at the microsoft forum. This is not strictly an excel related question, but I thought I could start here. I have attached a pdf screen snapshot of a microsoft folder on my desktop. The real file is much larger, this is just a sample to illustrate what I want to do. The folder contains file information on several music files and the attributes are name (or filename) then song title, then contributing artist, and album. I want to export this microsoft file list and all the associated attributes to a CSV file so I can further edit it in excel.



I realize I can use cmd or powershell to direct the filename to excel, but thats only part of what I need to do, I need to have this folder open in excel with a column for filename, title, contributing artist, and album. In other words I need to turn this windows folder into an excel spreadsheet with seperate columns for all the existing attributes listed. Any suggestions on how this can be done? Many thanks

Attached Files

folderforexcelforumpdf.pdf (46.6 KB, 7 views)