Export detailed metadata from Windows Explorer to Excel Spreadsheet

[@freedompreacher6023]

I spent several hours today trying to figure out how to get that blasted "Title" from the metadata into an Excel file. This is a fabulous solution, thank you many times over for posting this!

[@johnmaggio7976]

Just as a note - This can also be used on networked drives. It will not take a unc path (\\yourdrive) but if you assign a drive letter to a folder, you can do a CD /d v:\music music for me is on my synology NAS and I mapped V to the folder. I also wanted to list the bit rate of all the MP3 files and the column is called Bit Rate in explorer. Filelist does not like the space so I used bitrate and it worked. So it looks like any column that explorer can display can be used. Thanks for this very good tutorial.

[@GrahamSmith463]

You are a life saver. Thanks for this!

[@carlos_mann]

So this will work with the metadata that is already embedded into the mp3 file? I'm trying to get a printable list of my mp3s, (artist, title, comments). What he did works, ill be using a synology nas as well

[@cesarmontes3406]

Man you have saved my life because I´m running a forensic audit in which I´m presenting evidences and with this I can demonstrate the evidence comes from a reliable source.

[@kirksurant2769]

This executeable is something I have been needing for YEARS. Up until now I had been using dir to output to a text file and parsing the data manually in Excel. However I have never been able to find a good way to get the duration ("Length") for the media data. It is a bit confusing with the way the list of details desired is layed out (ie: I couldnt find FullPath in the list AND I was unsure whether to use just Length or System.Media.Duration or both (Length-System.Media.Duration). Yet when i saw the 1st comment where the person was asking for Length and your answer, I kinda figured it out. All in all this is a great video. Short, to the point, and gets the job done well. You have done a very great service for me personally, and to the world; and for that, I thank you so very much. God Bless

[@j-center837]

I am trying to get the duration but getting weird numbers. How did you fix it?

[@gilson7959]

​@@j-center837 This is duration in 100-nanosecond units. First you have to convert into seconds using the formula: =[@Duration]/10000000, and then in Microsoft Excel to convert into time duration format use this: =[@Seconds]/(60*60*24) and change the format to Duration

[@nathang7485]

Since the virus pandemic I now am required to work at home. So, I really appreciate these short cuts while I focus on paperwork :) These short tutorial videos are helping me immensely. I hope you and your family are staying safe during this troubling time.

[@philranger9825]

instead of executing CMD from the windows menu, type "cmd" and enter in the directory name and it will open a command window already in that folder.

[@MichaelDewTechTips]

Wow, thanks Phil, excellent trick I did not know that! To make sure it is super super clear to everybody else, navigate to the folder in Windows Explorer containing the files and subfolders you want to run the FileList operation on, and then in the address bar of that Windows Explorer window, type "cmd". That will open up the command prompt with the path / directory already set to what you want it to be. Thanks again Phil.

[@barbaraparker7129]

THANK YOU! Using your instructions I was able to export over 1000+ files and the Metadata! You Rock!

[@constitution6239]

Thank you for having uploaded many useful videos, which includes your Playlist of "JD 3-1 educational."

[@christopherwong6174]

THANK YOU!! I've wanted this tool for my music files for years. THANK YOU!! Excellent tutorial and information.

[@atiquebinzohur7402]

Great video. I needed the duration of hundreds of videos. I figured out how to do that from your video. Thanks again for this!

[@A_A78]

thank you very much for this video 💖. it helps me a lot.

[@krithigashiva7499]

Thank you so much. I was particularly searching for length of the media data and got it.

[@danielalbrecht8875]

Daniel Albrecht That saves me so much time. FANTASTIC ! Many thanks for your beautiful video. All the best.

[@kannanaiyar5291]

Brilliant.Thank you. I have been trying to find something like this for a while now. I seem to have several copies of the same photos in different folders, but sometimes the same file name does not mean the same photo. Knowing the Date Taken makes it very easy.

[@carlitocarlito9748]

Kannan, I use ztree to help solve this issue, it allows you to copy to a single folder from many other folder listings

[@paulsouthern547]

Thanks for sharing Mike - solves an age-old problem I've had.

[@roniux007]

Exactly what I'm looking for, thanks for share and teach this procedure. With other commands like "System.Document.DateCreated" instead "System.Photo.DateTaken" I could obtained the content date when the file was created, from many MS word files, finally a completely masively comparing.

[@sunnyboy1428]

Hi Michael, when I'm trying to export video length using System.Media.Duration the output file has some long numbers for the duration like "17608850000" or "19030290000" Please advise what am I doing wrong?

[@MichaelDewTechTips]

Sorry, never dealt with that before, and not sure what is going on there. I thought it might be the duration seconds, but the number is too big for that. Sorry cannot be more help.

[@rowanjoseph9902]

Found any Solution ?

[@gilson7959]

​@@rowanjoseph9902 ​ This is duration in 100-nanosecond units. First you have to convert into seconds using the formula: =[@Duration]/10000000, and then in Microsoft Excel to convert into time duration format use this: =[@Seconds]/(60*60*24) and change the format to Duration

[@Sarahlinii]

@@gilson7959 Where do we type that formula into in order to even make the calculations/changes to have length properly reflect what is shown in windows explorer? I'm having the same issue for example, once the info is exported to excel a video length 04:24:56 is shown as "158961260000" in the length column. I can't do anything with that information. Any help would be appreciated, I'm not familiar with many formulas or codes, etc., in excel.

[@kishorekumarjonnalagadda7797]

Would this work for 2.3 million files in my file system?

[@debcodding8609]

Excellent video -- saved me a lot of manipulation time! Thanks.

[@alexerpeixoto7449]

Mate, you saved my life. Thank you so much.

[@mcadutub]

Thanks for making this Excellent tutorial. For unknown reason, I can only do 6000 entries at a time. For instance my library has 33000 songs. When I execute the cmd with 3 columns, filename, size and length (_FileList.exe /USECOLUMNS NAME,SIZE,System.Media.Duration > _flacmp3nfo.txt) excel only takes about 6000 entries and not in alphabetical order. So I have to split my library to chunk of 6000 files at a time. Anyway, it little bit more work but still way better that without having the song duration. 😁

[@AshishSharma-rd6ze]

Finally found some legit tutorial.

[@davidp98]

Excellent, clear instructions and exactly what I needed thank you.

[@jam-software]

Wow! Thank you very much for this great tutorial.

[@tn25mfan]

Thanks for the great software! Is there a command for photos>properties>details>comments? I enter GPS coordinates in that location and need them in Excel spreadsheet. Thanks!

[@assamazam5151]

This is great! Very helpful for my current project. I wonder if there is a way to make a BAT file with this in it.

[@CpuAnalyst]

QUESTION: Does it only extract the metadata from the directory where you paste the FileList.exe file, or does it also extract the metadata from the sub-directories within THAT folder? Thanx in advance... I have over 34,500 audio files categorized into 900 Directories, and sub-directories The data I'm trying to extract is as follows... ALBUM - ARTIST - TITTLE - SIZE - LENGTH - YEAR - GENRE - INITIAL KEY - BPM - BITRATE Thank you for posting these helpful videos.

[@MichaelDewTechTips]

It also pulls data out of files in the sub-directories. Perhaps make a small sample folder tree to experiment on to start with.

[@CpuAnalyst]

@@MichaelDewTechTips Awesome: Thanx for the help.

[@Samoaplaya]

this guide was really helpful! albeit also a little odd to see "Receipts (Rona)" in there, considering this was made a year before 'rona' was in our vernacular.

[@alexbelomlinsky7591]

Thank you for sharing! Any idea why System.Title does not carry over my info from the source files?

[@anonUK]

Thanks for this, this is fantastic. Btw, my help file from Jam Software doesn't show any info in the RH pane. Microsoft offers some assistance on other categories to search for- but is there anywhere else I can get a similar list please?

[@MichaelDewTechTips]

Are you saying that you cannot get the help file for FileList to work? You should be able to download it from www.jam-software.com/filelist.

[@dr.melodicadavidbrancazio8860]

Super helpful, thanks!

[@ArthurGarrenton]

Thank you, it works like a charm.

[@blrsub]

Thanks Mike for the useful video. What is the code for the file attribute "Comments"?

[@abdulrahmanmoughalless2306]

I was wondering if there is any program that does this automatically, that is, when I copy any file to the folders, the program extracts the metadata to the excel database

[@reddlief]

Michael I have a question and great videos by the way. Excel and even file attributes are different country to country. For instance, European date configuration is D/M whereas my country (USA) is M/D...I've only watched 2 of your files that hit my problem square on, so I apologize if this comes up in your library of videos that I will finish watching!

[@reddlief]

I just hit the more button in comments, and you've listed all the commands and attributes as shown in the video!!!!! What a resource. I only wish I'd have this 30 years ago!

[@batista98854]

Really Thanks a lot. Saved hours of time.

[@selectionbreakdown7024]

Dear Sir How about creating a list of files based on the date modified? Just search for files modified in the year 2022.

[@MichaelDewTechTips]

I think the Jam software can only search by folder i.e. it pulls out data for all files in the folder (and its subfolders) irrespective of the dates of the files. After you get the full details of all files from the Jam Software report you could then screen for files with particular dates.

[@chrisg758]

Super helpful, thank you!

[@johndaniels5407]

That was very helpful!! Thank you so much. God bless you.

[@sandeepsaini2994]

How to get a lenght of Video

[@daviddemers9463]

So how do I get the info from the comments column?

[@chakirpiro7168]

Very helpful, thank you

[@Hitmanu-yq9if]

Thanks for the amazing video. Would you please mention how to add the "LENGTH" column to the details? It would be highly appreciated.

[@MichaelDewTechTips]

Do you mean audio or video file duration? If so, try add "System.Media.Duration" into the string of fields separated by commas, and no spaces.

[@madhockeyman]

@@MichaelDewTechTips Yes, that is what I think she meant and what I was looking for as well. You hit it spot on! Thanks!

[@zohararafi3527]

@@MichaelDewTechTips Thanks for the video. How about if it's an audio file duration? Is it the same code?

[@MichaelDewTechTips]

@@zohararafi3527 could be, else try "Length - System.Media.Duration".

[@MultiDuypro]

@@MichaelDewTechTips Thank you so much

[@khalifrhodes5073]

Do you have a copy of the filelist 4.3. They fixed the way the file is output in the 4.3.1 . If anyone has the 4.3 file that would be great.

[@tokirakis]

Is it possible to take the coordinates from the photo? The photos are from a drone.

[@KQCNT]

Im trying to add Frame Width since "System.Image.HorizontalSize" has no info in my video files. Do you know what would be the correct "system" code?

[@MichaelDewTechTips]

No, sorry, I do not know that one.

[@JosepCarrizo]

Very useful! thanks so much

[@digitalsausage5590]

Good utility, and very useful. But for photos, I can get everything EXCEPT the F-Stop value to export. It can be displayed in Explorer, but using filelist I can't figure out the right property/field name to fetch F-Stop/Aperture. Anyone else figured that out?

[@tomvarrun7322]

Thanks man,it works

[@matthewwheeler878]

Michael, it's great to have this useful demo. I just tried it with a non-local (network attached, mapped) directory. Unfortunately, I got an invalid parameter error for /USECOLUMNS. Any insight? Maybe a developer support issue. Thanks.

[@MohamedAshraf-vh3jo]

THANK YOU SO MUCH!

[@teamofficialvisindometadat7554]

Thanks Brother, it's realy help

[@atiq-ur-rehmanmuhammad3259]

Great ................ Thank you very much

[@turnswood]

Hey Michael, this is great. I use the other video showing save as path all the time and recently found the need to get some metadata from my jpegs. Is there a way that you've found to extract all the metadata that is available? Once I had that I could parse what I need in Excel. Maybe a better way of asking that question is - is your list above all of the System. - names all-inclusive or are there more? Thanks - I have looked for other scripts that bring in Powershell that didn't work as I wanted and this is very simple. I have used Jam's other program TreeSize Free for viewing directory sizes and use it all the time. Irv in Florida

[@MichaelDewTechTips]

no, sorry, I do not know of a single command to bring in "all available" metadata, you could check the jam software guide for the software, but it may be that you have to specify the metadata items you want one by one using the specified commands.

[@Melkhalifaaa]

Hmm would adding the page count per file possible?

[@MichaelDewTechTips]

Try adding System.Document.PageCount to the command, for sure it works to pull pdf file page counts, and may also work for some other file types, but obviously not for photograph files, etc.

[@Artist77osi]

how to get Titles of the font from font metadata

[@LeonMire]

Not sure if this works anymore. I ran the command sequence and was told "Access is denied. This file can't run on your PC." Running Windows 10.

[@MichaelDewTechTips]

Pretty sure it still works. Are you sure you were in the correct drive? If not, try the change directory command.

[@jakehansen605]

does anyone know what the attribute codes are for pulling photo latitude and longitude? Thanks

[@MichaelDewTechTips]

Not sure, but I think that is not possible with this tool, may need a more sophisticated photo metadata tool for that.

[@jakehansen605]

@@MichaelDewTechTips Thanks for the response, I used the exiftool to extract X Y info

[@geneholmes8176]

Very informative and convenient. I am looking to extract the data shown in the "Statistics" tab on file explorer properties but no column is available showing this tab information. This information tab shows editing person, dates and total editing time. This pertains to autocad drawings but this should not affect the data extraction because it is shown in the properties. I have screen shot PDF's showing the tab but am at a loss as to how to find or export this tab information to Excel or .txt. I could send the PDF's for review if desired.

[@MichaelDewTechTips]

Not sure I can be of any help on this, did you look at the full list of commands available in the Jam Software user guide?

[@atpu555ananthan5]

Thanks for your video, which looked promising, but it only downloaded 1335 line of data! I am not sure why. There are several thousand more files in the folder!

[@MichaelDewTechTips]

I have had that problem only very seldom (perhaps only once, can't even recall). Try restarting your computer. If that does not help, it may be a problem file that is causing it to crash. Split the data up into subfolders and run the routine on the different subfolders and you may be able to detect where the problem file is.

[@atpu555ananthan5]

@@MichaelDewTechTips Thank you! Will try it.

[@Raptor3Falcon]

dimensions not working for mp4 files

[@anmac6910]

can you expand and customize this list to include date created, date accessed of folders as well ? what other fields can this show ?

[@MichaelDewTechTips]

Yes, read the content in the video description right below the video.

[@insidedetails6101]

Great work, I have a question, can I copy the file names like in the video and then organize them inside Excel and apply that inside folders

[@MichaelDewTechTips]

There is another video on this channel that has a link to a spreadsheet that will sorta allow you to do what you describe

[@Sarahlinii]

I'm finding that whenever I try this, I follow the instructions fully and go to load the .txt file into Excel and find that the list of files is not complete. For example, I have over 700 files in just one folder yet when the info. is exported it only shows 160 or so. I've no idea how to fix this but it keeps happening and does not give me a complete list of files/folders most of the time. I've spent so much time so far trying to figure out where I'm going wrong, but I've no clue! Oh, to add, I'm trying to get lists of files/folders off of my backup External Hard Drives for work. I'm not sure if that influences how FileList, etc., operates or not. Any help would be great!

[@MichaelDewTechTips]

Could be one strange file causing it to crash, perhaps look at the last file in your list of 160, and then also at the next one, and consider moving those off the hard drive and try again (?)

[@Sarahlinii]

@@MichaelDewTechTips Thanks for the reply and the tip, I'll give that a try! It seems to have the same issue with files that aren't on any external drives also. I just tried earlier with several hundred videos I have on my computer and it again only shows a partial list. I'll see if I can figure it out utilizing your tip. Thanks again :)

[@JAY_SRI_HARI]

Is it possible to know the size of page of pdf whether A3 OR A4

[@MichaelDewTechTips]

Looking at the list of codes for what can be extracted by this software, I do not think that is possible with this software. Seems like www.softpedia.com/get/Office-tools/PDF/PDFInfoGUI.shtml might be free software that could do it but I have no experience with that software and not even assessed whether it is trustworthy. PDF Shell tools can do it, www.rttsoftware.com/shelltools.html, but that is paid software. I use PDF shell tools for lots of things and I love it.

[@jeffsteidl757]

I have a question on this. This pulls the data in. I would like to not only pull it into excel, but do a mass change on the information, then do a mass change on the files with the new data. I have a lot of files that need changed on a mass scale. example is a song list. I have many songs in a file but the tags are sloppy. I would like to adjust them in excel then export or change the files on a mass scale. If this something you have done a video on or can pint me in the right direction? Thanks!

[@MichaelDewTechTips]

No, I have not done a video on that, although it would be possible to build such a spreadsheet. The closest I have done to that is a spreadsheet that can bulk change just the file names: kzbin.info/www/bejne/rGPKn3uAaLeMrqs

[@shreyasiparikh1544]

THANK U, CAN YOU HELP ? WHAT SHOULD WE WRITE TO GET IMAGE DIMENSION? IN PIXELS ? or Inches (Width and Length)

[@MichaelDewTechTips]

I think this tool extracts mostly system metadata, for image properties you may have more luck with ExifTool by Phil Harvey (for photograph metadata) , try google that...good luck...

[@sridharan445]

Thank you. Very useful. But I am not getting the details for drives that are connected via USB say 'G:" or "F:". Am I making any mistake?

[@MichaelDewTechTips]

you may need to change the command prompt to the drive that you want to extract the data from using the change drive command e.g. to change to F drive type F: at the command prompt and then press enter, then, to type cd for change directory and paste the path of the top level folder and then press enter

[@aysenmustafa6973]

this is very useful but I keep getting error messages when trying to add the columns, Date Last Saved and Total Editing time, I have tried 'DATELASTSAVED' and 'System.Document.DateLastSaved'. What am I doing wrong?

[@MichaelDewTechTips]

Not sure, perhaps you are including spaces that should not be there? And did you use the > character correctly and not the funny arrow that I had to use in the KZbin description because KZbin does not allow use of > in the video description?

[@harndbuster300]

I have a folder of emails extracted from outlook. Do you know how to extract the date the email was created in to excel aswel as the metadata?

[@MichaelDewTechTips]

Did you try adding "System.Message.DateSent" to the line of code?

[@harndbuster300]

@@MichaelDewTechTips yeh it didnt' bring back anything

[@MichaelDewTechTips]

@@harndbuster300 hmmm...is this just a collection of .msg files in a folder and you just want to extract "date sent" info? Is this a one time project or something you will want to do this repeatedly from time to time? If you put all of the files into a cloud folder (e.g. Dropbox, Google Drive, etc.) and email the link to me at legaltree at gmail I can take a look at extracting the data, perhaps using another tool. It may be your files have something weird going on with them, but if you give me access to the files then I can try and extract what you need.

[@brookehockersmith4685]

I need the spread sheet to update as I add documents in the folder. Is there an way to do that?

[@MichaelDewTechTips]

Not that I know of that is easy to implement. Might be able to do it with Power Query in Excel, but could be tricky depending on what metadata you are looking to import. Sorry cannot be of more help.

[@ovealexander2346]

Thanks, very helpful. As always a great solution always begs the question of more. Where might I find a full (or at least expanded) list of metadata columns to extract? I am for example right now interested in camera make and model and my best guesses at what that might look like (e.g. System.Photo.CameraMake) hasn't worked.

[@MichaelDewTechTips]

Check the Filelist documentation on the Jam software website for a full list. Also, for photos you may want to use an ExifTool e.g. the one by Phil Harvey

[@omkarmemane5737]

@@MichaelDewTechTips Hello Sir...first of all thanks a lot for for this video...this helped a lot...can you please paste link of filelist documentation....actually I wanted code for extracting comments as available in file description

[@choosedean]

@@MichaelDewTechTips I cannot find a full list on the Jam Software website. Can you provide a different resource?

[@MichaelDewTechTips]

@@omkarmemane5737 To get a full list of all of the metadata variables that could be pulled from various types of files (i.e. a full list of supported shell columns), you can use the “/PRINTSHELLCOLUMNLIST” parameter i.e. put FileList.exe in a folder and then change to that directory on the command line and then run the following command on the command line: FileList.exe /PRINTSHELLCOLUMNLIST > outputmike.txt

[@abdulrahmanmoughalless2306]

thanx a lot

[@freshprinceofsolair]

how do you get the length of the video file as well? when i type LENGTH it says unknown column

[@MichaelDewTechTips]

Did you try "System.Media.Duration" as per the earlier comment?

[@vaggeto]

Hello! When I check their documentation and website, it shows far less column choices than you have in the description. Do you know specifically where the full list can be found? I'm specifically trying to find size on disk vs just size, since it my case I have some files that are corrupted and their size vs size on disk is much different and this tool might help me identify the files I need to correct. Thanks!

[@MichaelDewTechTips]

To get a full list of all of the metadata variables that could be pulled from various types of files (i.e. a full list of supported shell columns), you can use the “/PRINTSHELLCOLUMNLIST” parameter i.e. put FileList.exe in a folder and then change to that directory on the command line and then run the following command on the command line: FileList.exe /PRINTSHELLCOLUMNLIST > outputmike.txt

[@vaggeto]

@@MichaelDewTechTips awesome, thank you so much that will be really helpful! I also found size in disk as system.fileallocationsize in the msdn website.

[@weiheon]

This is very helpful, but i couldn't find the attribute code to output the number of pages. Is there a way to do that?

[@MichaelDewTechTips]

You could try System.Document.PageCount, but it may not extract page data from all document types.

[@weiheon]

@@MichaelDewTechTips It worked brilliantly! Thanks for the tip Mike.

[@roofbolt1]

Great video. But I would also like to capture the list of folders names not only file names. How do I do that?

[@MichaelDewTechTips]

The folder names are in the "Full path" column, see 6:15 in the video. You can separate that data out using "text to columns" with backslash as the delimeter.

[@roofbolt1]

@@MichaelDewTechTips I was hoping to get the folder names as separate rows because I am interested in the owner or creator of the folder.

[@MichaelDewTechTips]

@@roofbolt1 As per the list in the description to the video, you can also use add "System.ItemFolderNameDisplay" to the command to output the folder names.

[@paulshapiro6119]

Is there anyway to include the date files were moved into the current folder location (e.g. the indexed folder) as one of the metadata captured?

[@MichaelDewTechTips]

The "Date Created" data point (as distinct from "Date Modified") is typically the time that the file was created in the current location i.e. "date modified" is when the file contents were modified, and "date created" is when this copy in this folder was created. So you could just pull out date created data.

[@paulshapiro6119]

@@MichaelDewTechTips This is great because I inadvertantly initiated moving a bunch of files between two folders each of which also already had a bunch of files. I stopped the transfer but some files moved. Your strategy above will allow me to identify which files were moves last Tuesday. Thanks!!!!

[@MichaelDewTechTips]

@@paulshapiro6119 you could also just add the "date created" field to the display of Windows Explorer (right click on the headings and then add that field) and then sort by that column directly in windows explorer by double clicking on the column heading i.e. may not need to export the data to achieve your current goal

[@TechWorldTut]

I want to extract multiple video duration from file explorer.

[@MichaelDewTechTips]

Did you try putting the variable System.Media.Duration into the string of code?

[@wfh_millenial]

Thanks for the informative video. I want to extract the metadata under columns “Tags”, is this possible here?

[@MichaelDewTechTips]

Try adding the command "System.Keywords" into the string of data to extract. To get a full list of all of the metadata variables that could be pulled from various types of files (i.e. a full list of supported shell columns), you can use the “/PRINTSHELLCOLUMNLIST” parameter i.e. put FileList.exe in a folder and then change to that directory on the command line and then run the following command on the command line: FileList.exe /PRINTSHELLCOLUMNLIST > outputmike.txt

[@aubrey75092]

@@MichaelDewTechTips THIS was the command I was searching for. I now have the necessary tools to really use this application. Thanks for the video and THANKS for this post. Tremendously useful.

[@alkasharma5045]

Thanks for the tutorial. Is it possible to use it without pasting the exe file in the same folder? I mean, keeping the exe file in a separate folder and extracting the metadata of a separate folder. Not having to paste the exe in a folder every time you have to extract data? Thanks in advance.

[@MichaelDewTechTips]

No, I think that every time you have to put the .exe file in the top level of the folder of the folder tree you want to extract the data from. You could use a macro to write in the file into the necessary folder and then delete it out afterwards, but that requires some complex macros

[@alkasharma5045]

@@MichaelDewTechTips Thanks for your reply :-) I checked some videos on YT showing how two commands can be run in CMD. Can something like that be done running the exe from a different location?

[@MichaelDewTechTips]

@@alkasharma5045 Sorry, not sure, I am not an expert on the command line!

[@alkasharma5045]

@@MichaelDewTechTips No worries. Thanks for this video. It is of great help.

[@Anisotropy.A]

@@alkasharma5045 Google "windows 10 path variable" and add FileList.exe

[@kennethschriever9820]

Anyone know what's the command line for exporting the bitrate from a mp3 file (using "FileList")?

[@juanavendano6552]

System.Audio.EncodingBitrate

[@kennethschriever9820]

THANKS! That worked.

[@BigBeezy]

cannot use this for a network drive

[@MichaelDewTechTips]

I believe you can, but at the dos prompt you first need to change to the network drive using the cd command

[@tamiascales8891]

Using an external software is the only way to do this?

[@MichaelDewTechTips]

It may be that if one knows the commands to put into the command line you could do it directly and without third party software, but the software works so well, and is free, and is the best option I am aware of.

[@waynelfuller49]

It's frustrating that I always seem to need 3rd party software to do these things. If the 3rd party can do this, why can't I?

[@Hanstein.]

Yeah. Tell me when you have the solutions that doesn't require 3rd party malware

[@acttony]

didnt work for me, it says length is an unknown column

[@MichaelDewTechTips]

It seems you have tried to include an additional file attribute of "length", but that is not a proper attribute and may be why you are getting an error. See list of permitted attributes in the video description.

[@acttony]

@@MichaelDewTechTips Thank you I figured it out, it's working now

[@markrickert9040]

Nice, but it seems the JAM software has limited capacity, particularly about 1kb of data then cuts off any more file data from being retrieved, second it seems that it doesn't retrieve all property data just selected data, most importantly for me the "tags" and "comments" data is not retrieved. Otherwise the video and the original one were vary useful, thank you.

[@MichaelDewTechTips]

Interesting, I have never found JAM software to cut off file data, even when running it on thousands of files, but perhaps your file data was more detailed that what I have used it for. I have never tried to retrieve tags or comments, but as per the instructions for that software in the help file you can modify the columns of the output table, so it may be that you just have to change the code to make it spit out that additional data. To get a full list of all of the metadata variables that could be pulled from various types of files (i.e. a full list of supported shell columns), you can use the “/PRINTSHELLCOLUMNLIST” parameter i.e. put FileList.exe in a folder and then change to that directory on the command line and then run the following command on the command line: FileList.exe /PRINTSHELLCOLUMNLIST > outputmike.txt It seems to me that comments and tags are both on the list i.e. System.Comment and System.Keywords, but it may be those commands will not actually extract what you are looking for...

[@tn25mfan]

I would love to know how to show the comment data as well because that's where I enter GPS coordinates. Please reply here if anyone figures out how to do this! Thanks!

[@patriciagregg445]

@@MichaelDewTechTips System.Comment worked! Thank you so much for the video and comment!

[@evrentuskan]

System.Keywords; for "tags" System.Comment; for "comments" both can be retrieved

[@generalbarry]

Microsoft Windows [Version 10.0.19043.1348] (c) Microsoft Corporation. All rights reserved. C:\Users\ME>I:\MUSIC STORAGE FILES 'I:\MUSIC' is not recognized as an internal or external command, operable program or batch file. C:\Users\ME> OK, what am I doing wrong?

[@kishorekumarjonnalagadda7797]

Hi Mike, This video really helps to extract metadata of huge volumes of files. Could you please help me how I can list folder name of each file into a column. for example , my file system is like saving employees personal docs. each folder name is employee id. So I wanted to list down the employee ids as well with the filenames. 1234 --> identity.doc 5678 --> passport.doc The above two folders 1234 and 5678 exists as follows E:\files\1234\identity.doc and E:\files\5678\passport.doc

[@MichaelDewTechTips]

If you are able to get the data into excel (although it sounds like it may be too much data for excel to manage) you should be able to create a column that lists just the folder names using regular excel functionality e.g. mid, left, right, formulas, or use "text to columns" tool on the data tab of the ribbon and separate by backslash.

[@emn8or]

Thanks for this Michael. I've found it useful but not having much luck applying it to my needs. I followed your video and copied the commands with success. But I need to get a list of mp4 files in a directory including their files name and length (in hh:mm:ss) as listed in the "length column in windows. And I saw the entry you made for length as Length - System.Media.Duration. What command do i need for this? I thought it would be "FileList.exe /USECOLUMNS NAME,FULLPATH,EXTENSION,LENGTH,System.Media.Duration > test1.txt" but I get the error " Error 3: The system cannot find the path specified: NAME,FULLPATH,EXTENSION,LENGTH,System.Media.Duration" Any tips please?

[@MichaelDewTechTips]

Are you sure you have the file Filelist.exe in the same folder as containing the files that you want to extract the data from? Have you been able to extract duration information from any mp4 files? I confirm that I have been able to extract duration data from mp4 files (although not all mp4 files have that data available).

[@emn8or]

Hi @MichaelDewTechTips thanks for your prompt reply. Yes, the .exe file is in the same directory and I have been able to extract other info as per your example, but when I add the length command, I get those errors as listed. The mp4 files definately do have info of their duration in the windows explorer culumn. I just ried agin by leaving out the word "LENGTH" and using the command FileList.exe /USECOLUMNS NAME,FULLPATH,EXTENSION,System.Media.Duration > test1.txt My example mp4 files were this time 3 files 60secs, 90secs and 120 secs long. And I do get a workable result now of "Name","Full Path","Extension","Length" "01=060secs.mp4","C:\Transfers\test\01=060secs.mp4",".mp4","600110000" "02=090secs.mp4","C:\Transfers\test\02=090secs.mp4",".mp4","900060000" "03=120secs.mp4","C:\Transfers\test\03=120secs.mp4",".mp4","1200000000" So it does work now but only when I omit "LENGTH" and gives me a value of length with a lot of traling numbers. (ie the 60 sec file reads "600110000"). I guess I can use this and omit the trailing digits in Excel unless I can come up with a betther solution. Thanks again for your assistance.

[@gregorywkent]

Thanks for this. I'm looking to pull this information for audio files and am looking to include the 'title' and '#' columns. How would you account for that in the code?

[@MichaelDewTechTips]

Try "Title - System.Title", see also the video description and the FileList user documentation.

[@gregorywkent]

@@MichaelDewTechTips Apologies, missed the list in the description. Worked like a charm, thank you.