FileList is a command line utility providing a list of files of the selected path in the CSV format. The list includes the file name, the size, the file path, the last access and change date, date of creation etc. You can easily import all results to a spreadsheet or database. FileList runs on any current Windows operating system starting with Vista.
Online Manual: https://manuals.jam-software.com/filelist/EN/
Filter Lists as Needed: Filter the lists by various criteria like file name, file extension, time stamps, directory level, file size or file attributes.
Create File Lists on the Command Line: FileList can print or export lists of files of a folder or directory tree including metadata of the file.
Include Various Metadata: FileList may include any metadata that Windows Explorer supports, like camera model, artist name or number of pages.
Includes a set of comma-separated columns. For accepted columns, see /USECOLUMNS
to filter files by their file attributes. Only files which have all the given attributes in common will be found in that way (e.g. "/ATTRIBUTEFILTER RS" shows files with attributes "readonly" AND "system file").
All files and folders (*
), readonly (R
), hidden (H
), system (S
), folder (D
), archive (A
), compressed (C
), sparse (P
), temporary (T
), offline (O
), reparse point (L
), Alternate and encrypted (E
),
Allows to specify a format for date values. Available formats are:
Format | Description |
---|---|
DATE | Formats the displayed time to show the date only. |
DATETIMESHORT | Shows the date and time as hours and minutes. |
DATETIMELONG | Shows the date and time including also seconds. |
DATETIMEISO | Formats the displayed time to ISO-Standard. |
TIMESHORT | Formats the displayed time to show hours and minutes only. |
Allows to specify one or more exclude filters, separated with semicolons. Each path must not match any of the filters to be included. The wildcards '*' and '?' may be used. Path fragments like *\System32*.DLL may be used as well.
Outputs full path of each file instead of separate columns for file name and file path.
Allows you to specify one or more filters, separated with semicolons. Each path has to match at least one of the filters to be included. The wildcards '*
' and '?
' may be used. Path fragments like *\System32\*.DLL
may be used as well.
Allows you to set the character used for separating the columns. By default the list separator from the "Regional Settings" of the Windows Control Panel is used. Add the new list separator character after /LISTSEPARATOR
separated by a space.
Use TAB to assign the tabulator as separator between columns. When using the tabulator, columns will also be exported without quotes.
Allows to specify a maximal date for output files. There will only files be displayed which last change date is older than the given date. Use format "yyyy-mm-dd
".
Only files whose directory level is below or equal to the given value will be displayed.
Allows to specify a minimal date for output files. There will only files be displayed which last change date is younger than the given date. Use format "yyyy-mm-dd
".
Only files whose directory level is greater then or equal to the given value will be displayed.
Allows to specify a minimum path length. Files whose full path has less characters then the given value will be excluded from the list.
Allows to specify a minimum file size in Bytes. Files which have a size smaller than the given value will be excluded from the list.
Leaves out the column headers from the output.
Omits the first two lines which determine the location but shows the column headers.
Prints a list of all shell columns available for the specified folder. More information on these columns is available at https://msdn.microsoft.com/en-us/library/windows/desktop/dd561977(v=vs.85).aspx
Allows to specify a list of columns and their order to use. Default columns will not be extended, but replaced.
Accepted are the following predefined columns and all columns available with the shell (referenced by their canonic name):
Column | Description |
---|---|
NAME | Adds a column with the name of each file. |
PATHWITHOUTNAME | Shows the containing path of each file. |
FULLPATH | Adds a column with the combined path and name of each file. |
SIZE | Adds a column with the size of each file. |
ALLOCATED | Adds a column with the size on disk (allocated space) of each file. |
LASTACCESS | Adds a column with the date each file has been last accessed. |
LASTCHANGE | Adds a column with the date each file has been last changed. |
CREATIONDATE | Adds a column with the date each file has been created. |
EXTENSION | Extracts the extension part of each file. |
AUTHORS | Additionally extracts the name of the author from MS Office documents. Do not confuse the author with the owner. The owner is listed in an extra column by default. This switch slows down the creation of the list. |
LASTSAVEDATE | Additionally extracts the last save date from MS Office documents. |
OWNERS | Adds a column that contains the owner of each file. Querying the file owner is unfortunately a slow operation in a Windows domain, this is why file owners are turned off by default. Using this option will significantly slow down the generation of the list. |
DIRLEVEL | Shows the depth of each file. This is relative to the initial path. |
VERSIONS | Additionally extracts the version number. Usually binary files like EXE, DLL or OCX files contain a version number. |
ATTRIBUTES | Includes a column with the attributes that are set for each file. Options are: readonly (R), hidden (H), system (S), folder (D), archive (A), compressed (C), sparse (P), temporary (T), offline (O), reparse point (L), Alternate Data Streams (Z) and encrypted (E). |
MD5 | Includes a column with the MD5 checksum of each file. |
FRN | Adds a column with the unique NTFS file reference number. |
SHA256 | Includes a column with the SHA256 checksum of each file. |
PATHLENGTH | Includes a column with the length of the full path of each file. |
In order to display the name, owners, attributes and md5 checksum of files in the current directory, FileList can be used like this:
FileList.exe /USECOLUMNS NAME,OWNERS,ATTRIBUTES,MD5
To list the names of all .jpg files and their dimensions (as available with the shell or Windows Explorer column), FileList can be used like this:
FileList.exe /USECOLUMNS NAME,System.Image.Dimensions /INCLUDE *.jpg .
The 'System' namespace for shell columns is optional, so you may also use
FileList.exe /USECOLUMNS NAME,Image.Dimensions /INCLUDE *.jpg .
It's also possible to scan computers in the local network by using their names e.g. \\Home
, \\PETER
, \\SANDRA
as path.
Using ">
" the output can be redirected to a file. The text file will be encoded in UTF-8 with BOM.
FileList.exe /NOHEADER /ADDITIONALCOLUMNS OWNERS /FULLPATH . > C:\output.txt
-
FileList does not follow mountpoints and symbolic links. This ensure that files are listed only once. Many other command line utilities do follow symbolic links and will therefore show different results.
-
FileList uses the list separator that is set in the Control Panel of Windows by default.
-
FileList supports Unicode. In order to see Unicode characters in the command line window, you need to start the command line processor in Unicode mode (
CMD.EXE /U
) and use a font that supports Unicode (the default font does not). The Unicode format that is used is UTF8. -
Using the extension .CSV for the output file enables you to open the file in Excel with a double click in the Explorer.
-
In case an error occurs that prevents FileList from doing its job, the Windows error code will be set as exit code for the process.
-
The Windows "at" command can be used to schedule the creation of lists with FileList. The following command creates a list of all mp3 files including their owners every Monday night:
at 00:01 /EVERY:m "C:\path\to\filelist.exe" /OWNER /FILTER *.mp3 c:\ ^>output.txt
- To output folders with FileList you can use the
/ATTRIBUTEFILTER-parameter
of FileList. See Usage to learn more about Parameters.