Export detailed metadata from Windows Explorer to Excel Spreadsheet

A previous video at Export list of file names from Window... explained how to easily extract file path information (including file names) to an Excel spreadsheet. This video explains how to extract detailed metadata (not just file path but also size, date modified, etc.) to an Excel spreadsheet.

The method explained uses free software (https://www.jam-software.com/filelist/) from Jam Software and the command line.

The magic words / code needed, as explained in the video, is as follows, but note that Youtube does not allow the greater than sign (a.k.a. angle bracket) in video descriptions so you should replace the arrow icon in the following code with a regular greater than sign as shown in the video:

FileList.exe /USECOLUMNS NAME,FULLPATH,LASTCHANGE,EXTENSION,SIZE,AUTHORS,System.Photo.DateTaken  ➤ outputmike.txt

The following is a list of additional file attributes (on the left) with corresponding code (on the right) to include in the command. This is not a complete list because Youtube only allows 5000 character long video descriptions. Check the Filelist documentation for a full list.

Name - System.ItemNameDisplay
Size - System.Size
Item type - System.ItemType
Date modified - System.DateModified
Date created - System.DateCreated
Date accessed - System.DateAccessed
Owner - System.FileOwner
Date taken - System.Photo.DateTaken
Contributing artists - System.Music.Artist
Album - System.Music.AlbumTitle
Year - System.Media.Year
Genre - System.Music.Genre
Tags - System.Keywords
Rating - System.Rating
Authors - System.Author
Title - System.Title
Subject - System.Subject
Copyright - System.Copyright
System.Music.TrackNumber
Length - System.Media.Duration
Camera model - System.Photo.CameraModel
Dimensions - System.Image.Dimensions
Camera maker - System.Photo.CameraManufacturer
Company - System.Company
File description - System.FileDescription
Client ID - System.Document.ClientID
Contributors - System.Document.Contributor
Content created - System.Document.DateCreated
Last printed - System.Document.DatePrinted
Date last saved - System.Document.DateSaved
Word count - System.Document.WordCount
Due date - System.DueDate
End date - System.EndDate
File count - System.FileCount
File extension - System.FileExtension
Filename - System.FileName
File version - System.FileVersion
Horizontal resolution - System.Image.HorizontalResolution
Width - System.Image.HorizontalSize
Vertical resolution - System.Image.VerticalResolution
Height - System.Image.VerticalSize
Is attachment - System.IsAttachment
Is deleted - System.IsDeleted
Encryption status - System.IsEncrypted
Has flag - System.IsFlagged
Is completed - System.IsFlaggedComplete
Incomplete - System.IsIncomplete
Read status - System.IsRead
Shared - System.IsShared
Creators - System.ItemAuthors
Date - System.ItemDate
Folder name - System.ItemFolderNameDisplay
Folder path - System.ItemFolderPathDisplay
Folder - System.ItemFolderPathDisplayNarrow
Participants - System.ItemParticipants
Path - System.ItemPathDisplay
By location - System.ItemSearchLocation
URL - System.Link.TargetUrl
Media created - System.Media.DateEncoded
Date released - System.Media.DateReleased
Encoded by - System.Media.EncodedBy
Episode number - System.Media.EpisodeNumber
Producers - System.Media.Producer
Publisher - System.Media.Publisher
Season number - System.Media.SeasonNumber
Subtitle - System.Media.SubTitle
User web URL - System.Media.UserWebUrl
Writers - System.Media.Writer
Attachments - System.Message.AttachmentNames
Bcc addresses - System.Message.BccAddress
Bcc - System.Message.BccName
Cc addresses - System.Message.CcAddress
Cc - System.Message.CcName
Conversation ID - System.Message.ConversationID
Date received - System.Message.DateReceived
Date sent - System.Message.DateSent
From addresses - System.Message.FromAddress
From - System.Message.FromName
Has attachments - System.Message.HasAttachments
Sender address - System.Message.SenderAddress
Sender name - System.Message.SenderName
Store - System.Message.Store
To addresses - System.Message.ToAddress
To do title - System.Message.ToDoTitle
To - System.Message.ToName
Album artist - System.Music.AlbumArtist
Sort album artist - System.Music.AlbumArtistSortOverride
Album ID - System.Music.AlbumID
Sort album - System.Music.AlbumTitleSortOverride
Sort contributing artists - System.Music.ArtistSortOverride
Beats-per-minute - System.Music.BeatsPerMinute
Composers - System.Music.Composer
Sort composer - System.Music.ComposerSortOverride
Disc - System.Music.DiscNumber
Initial key - System.Music.InitialKey
Part of a compilation - System.Music.IsCompilation
Mood - System.Music.Mood
Part of set - System.Music.PartOfSet
Period - System.Music.Period
Color - System.Note.Color
Parental rating - System.ParentalRating
Parental rating reason - System.ParentalRatingReason
Space used - System.PercentFull
EXIF version - System.Photo.EXIFVersion

• #education
• #metadata
• #command_line
• #excel