This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I would like to export data from a large list of files I have into a csv or xls format. I need to export the title and also filename - there are a number of tutorials on how to export the filename only but can't find any way of exporting other metadata. Any help greatly appreciated.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hello Jaan, thi sis Emily.
If you have Excel, it allows you to get /import data from many sources, including folder.
Open your Excel, go to Data tab. Click on Get Data > From File > From Folder. Then pick the folder you want to export from. You will get a small pop up preview window, you can click load to have it load it your excel sheet. That should give you more than just file names with this method. Hope it helps.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 34%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELF%3C/text%3E%3C/svg%3E)
Just use a tagging program, such as M3Tag, TagScanner, or Tag&Rename. All of them have an export option.
The above three programs are mainly used for music files, but may also have support for video files.
For general metadata management, there's also Metadata++.
Hi Jaan,
Which metadata fields do you want to export? Is this a music folder?
Hi, i was trying to figure out the same thing. i have a large ssd with a bunch of movies sorted into folders inside folders inside more folders, but wanted to export the length of each video. would you have any advice?
Thanks Emily, I have managed to import the data using desktop version. I am specifically after the 'title' detail to be listed and I can't work out how to add this. There are various options for adding an additional column to the data but none of them include any way to pull this metadata from what I can see. The 'title' info is readily available in file explorer - any suggestions?
Thanks again for your help.
Thank you, I have excel 365 now and had 2013 prior, neither seem to have this option as below:
