Spreadsheet2Video Add column to Spreadsheet

Spreadsheet2Video is the pack that turns your ComfyUI workflow into a giant loop: one row of a CSV becomes one video, and each row feeds off the last one. It's the node people reach for when they want to generate a hundred variants overnight and wake up to a folder full of finished clips instead of a queue of "please babysit me" runs. This node - "Add column to Spreadsheet" - is the quiet utility in that pack that keeps you from typing the same thing 80 times.

Here's the scenario it exists for. You've got a spreadsheet with 50 rows of prompts. Now you want each of those 50 rows to also use a different seed, or a different strength value, or a different model variant. You don't want to type 50 lines of seed numbers. You want to paste 5 seed values and let the node stretch them across all 50 rows. That's exactly what this node does.

How it works

The node takes two inputs, both plain comma-separated text with a header row: spreadsheet (your source data) and spreadsheet_to_add (the columns you want to bolt on). It concatenates the two header rows, then walks your source rows and fills the new columns by cycling through the values you gave it - row 1 gets the first add-row value, row 2 the second, and when it runs out it wraps back to the start until every source row is covered.

That "cycle instead of duplicate" is what separates this from the pack's other node, "Multiply Spreadsheet." Multiply does a full cartesian product: every add-row × every source row, so your spreadsheet grows. Add Column keeps the exact same row count as the source and just keeps repeating your extra values to fill it. If you paste 5 seed values under a source with 50 rows, you get seeds 1,2,3,4,5,1,2,3,4,5... all the way down. Nothing more, nothing less.

The single output is a STRING - the merged spreadsheet, ready to plug into the main Spreadsheet2Video node or into a "Spreadsheet2Video Input Image" node's column connections. You can chain these, too: feed one Add Column's output into another's spreadsheet input and stack columns until your eyes water.

Install

Via ComfyUI Manager, search Spreadsheet2Video and hit install, or do it by hand:

cd ComfyUI/custom_nodes
git clone https://github.com/niknah/Spreadsheet2Video-ComfyUI

Then restart ComfyUI. The pack pulls in pandas via its requirements file - Manager handles that on install. If you want to load .ods spreadsheets in the Load Spreadsheet node, you'll need pip install odfpy on top of it.

The traps worth knowing

• Give the new column a unique header. The node just glues header rows together. Name a column the same as an existing one and you've got two columns with the same label, which is confusing when you're wiring things up.
• This is the fix for the pack's seed gotcha. With the seed set to "randomize," the number only changes after a whole run - every row gets the same seed, which is useless for variation. The README's own advice: add a seed column and connect it. This node is how you add that column without typing it all out.
• Preview files won't open from the assets list in some browsers - download the workflow and open it locally instead.

This isn't the node that makes the magic happen, but once you're running spreadsheet-driven workflows, it's the one you'll keep reaching for whenever you realize your source has 50 rows and you only feel like typing five values.