Introduction

Navigation: »No topics above this level«

Introduction

FileList is a command line utility that produces a list of files of the given path in the CSV format, which can be imported into a spreadsheet or database. The list includes the file name, the size, the path, the last access and change date, etc.


Installation

Installation

Just place FileList where you want, we recommend your Windows folder.

Supported Windows versions are Windows 8.1 or Windows Server 20012 and later.


What's new?

What's new?

See What's New online.


Usage

Start parameters

Start parameters

/ADDITIONALCOLUMNS

Includes a set of comma-separated columns. For accepted columns, see /USECOLUMNS

/ATTRIBUTEFILTER

/A

Can be used to filter files by their file attributes. Only files which have all the given attributes in common will be found that way (e.g. "/ATTRIBUTEFILTER RS" shows files with attributes "read-only" AND "system file").

All files and folders (*), read-only (R), hidden (H), system (S), folder (D), archive (A), compressed (C), sparse (P), temporary (T), offline (O), reparse point (L), Alternate and encrypted (E),

/DATEFORMAT

Allows to specify a format for date values. Available formats are:

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.

/EXCLUDE

Allows to specify one or more exclusion filters, separated with semicolons. Any path matching any of the filters will be excluded. The wildcards '*' and '?' may be used. Path fragments like *\System32\*.DLL may be used as well.

/FULLPATH

/FP

Outputs full path of each file instead of separate columns for file name and file path.

/INCLUDE

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.

/LISTSEPARATOR

/LS

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.

/MAXDATE

Allows to specify a maximal date for output files. Only files whose last change date is earlier than the input date will be displayed. Use format "yyyy-mm-dd".

/MAXLEVEL

/MAXL

Only files whose directory level is below or equal to the given value will be displayed.

/MINDATE

/MD

Allows to specify a minimal date for output files. Only files whose last change date is later than the input date will be displayed. Use format "yyyy-mm-dd".

/MINLEVEL

/MINL

Only files whose directory level is higher than or equal to the given value will be displayed.

/MINPATHLENGTH

/MP

Allows to specify a minimum path length. Files whose full path has less characters then the given value will be excluded from the list.

/MINSIZE

/MS

Allows to specify a minimum file size in Bytes. Files which have a size smaller than the input value will be excluded from the list.

/NOHEADER

Leaves out the column headers from the output.

/NOTITLE

Omits the first two lines which determine the location but shows the column headers.

/NOUTF8BOM

Omits the UTF8-BOM (byte order mark) from the output.

/PRINTSHELLCOLUMNLIST

Prints a list of all shell columns available for the specified folder. More information on these columns is available here.

/USECOLUMNS

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):

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 was last accessed.

LASTCHANGE
Adds a column with the date each file was last changed.

CREATIONDATE
Adds a column with the date each file was created.

FILES
Adds a column with the number of files contained in a folder. (Only if folders are included with the listing, see ATTRIBUTEFILTER).

FOLDERS
Adds a column with the number of folders contained in a folder. (Only if folders are included with the listing, see ATTRIBUTEFILTER).

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.

read-only (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.

Examples
(1) 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 .

(2) 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 .

The general pattern to use FileList is:

FileList.exe [/OPTION] Path(s)ToScan [> OutputPath\output.txt]

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.

Examples:
FileList.exe /NOHEADER /ADDITIONALCOLUMNS OWNERS /FULLPATH . > C:\OutputFolder\output.txt

FileList.exe /A * C:\ExampleFolder > C:\OutputFolder\output.txt

FileList.exe /A * C:\ExampleFolder2


Tips & Annotations

Tips & Annotations

·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.


Copyright & Contact

Copyright & Contact

Copyright © 1996-2023 by Joachim Marder e.K.

JAM Software GmbH
Am Wissenschaftspark 26
54296 Trier

Germany

WWW: | https://www.jam-software.com
Support: | https://knowledgebase.jam-software.com/
Commercial register number: | HRB: 4920 (AG Wittlich)
VAT ID No.: | DE234825349
Managing Director: | Joachim Marder