Export a windows folder to a csv file
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
|