Nodes/Spreadsheet2Video/Spreadsheet2Video Files list
ComfyUI Node

Spreadsheet2Video Files list

Turn a folder of files into a spreadsheet column

By niknah·Created 4 months ago·Updated 16 days ago· 9
Spreadsheet2Video Files list
    • STRING
    directoryinput
    regexfalse
    find*

    Spreadsheet2Video Files list (node class Spreadsheet2VideoFilesList) does one thing: lists the files in a directory and hands them to you as a CSV column. The header is filename, and every matching file becomes a row. Its whole reason to exist is to feed the Spreadsheet2Video loop - a folder full of reference images becomes a column of filenames, which you multiply into a spreadsheet and drive a load-image dropdown from.

    That closes a real loop in the pack. On its own, a spreadsheet column of filenames is useless; connected to a Load Image node's dropdown via the loop's COLUMN2 input, it turns "batch process a directory" into the same spreadsheet-driven flow as everything else.

    The inputs that matter

    • directory (default "input") - which folder to look in, given as a path relative to the ComfyUI base (the tooltip's example: input, output). It resolves against your ComfyUI input directory when building the result paths.
    • find (default "*") - the pattern to match. Glob by default, or a regex if you flip the switch.
    • regex (default off) - toggles find between glob and regex. In regex mode the pattern is searched case-insensitively against the full path, so it matches anywhere in the name, not just at the start.

    The output is a STRING: one line per file, filename header first, with paths relative to the ComfyUI input folder. input/frames/001.png comes back as frames/001.png.

    Where it fits

    The intended pipeline is spelled out in the pack's description of the related Load Spreadsheet node: list files here, paste or multiply the result into your working spreadsheet, load that with Spreadsheet2Video Load Spreadsheet, and the loop drives each file through your pipeline in order. It's also a genuinely handy standalone utility - any time you need a quick inventory of the files in a folder without touching the filesystem, this gives it to you in a string you can dump into a text preview.

    Gotchas

    • Paths are resolved against the ComfyUI input folder, so keep your files under ComfyUI/input (or one of its subfolders). The node rebases every match to be relative to that input directory - and paths outside it throw, so don't point directory at something unrelated like your home folder.
    • Glob vs regex behavior differs. Glob supports wildcards like *.png and ** for recursion; regex does a case-insensitive search against the whole path, so frame matches my_frame_1.png as well as frame.png. If a filter "doesn't work," check which mode you're in - it's the most common stumble.
    • The output always includes the filename header, so it can be used as a spreadsheet body directly, or multiplied in as columns via Spreadsheet2Video Multiply Spreadsheet.

    Small node, sharp edges, no models and no install fuss beyond the pack itself. It's the piece that makes "run this over my whole folder" a data problem instead of a copy-paste problem.

    CategorySpreadsheet2Video

    Inputs (3)

    NameTypeDefaultDescription
    directorySTRINGinputDirectory. example: input, output
    regexBOOLEANfalseRegex(on) or glob(off)
    findSTRING*Glob / Regex

    Outputs (1)

    NameTypeDescription
    STRINGSTRING