Skip to content

Data Columns

Each row of your data describes one render. A handful of column names are reserved and control the render itself. Every other column fills the text layers and footage items named after it; see Project Setup.

Column Purpose
comp Name of the composition to render. Required: a row with no comp, or a name that is not in the project, fails instead of rendering.
output Output filename for this row, without extension. The extension comes from the output module. Can include subfolders; see Output filenames.
project Path to a .aep file to open before rendering this row. See Comps and projects.
render-settings Name of a render settings template for this row. Overrides the panel dropdown. See Per-row overrides.
output-module Name of an output module template for this row. Overrides the panel dropdown. See Per-row overrides.
status Used by Agent Mode. Set it to ready to queue a row; BatchRender writes progress back into it.

comp is required; the rest are optional, so a minimal dataset is comp, output and your content columns. A batch or agent on a data source without a comp column stops before the first render and names the file, worksheet or view that is missing it.The names are case sensitive.

The ⓘ next to the Data Connection heading in the panel shows the same list without leaving After Effects.

The reserved data columns tooltip open over the main panel.

A second set of optional columns, all starting with br-, receives information about finished renders. See delivery information.

The output column sets the filename, without extension: the output module’s format determines it. A row without an output value is named after its comp. Files are written into the Output Path folder. Existing files with the same name are replaced without a prompt, so re-rendering a row simply updates its output. In network rendering the render node writes the file and replaces it the same way.

The output value can include subfolders, for example de/promo_v1 or client-a/2024/final. BatchRender creates the folder structure under Output Path as needed.

The output always stays inside Output Path: a value containing .. or a full path fails the row before anything is written. Characters not allowed in file names (: * ? " < > |) are replaced with _.

Image sequences work as usual: keep the After Effects frame number padding (for example [#####]) in your output module’s file name pattern.

  • A column fills every text layer and every footage item (in the project panel) whose name matches it exactly, in any comp.
  • Columns that match nothing in the project are ignored, so extra bookkeeping columns in your sheet are harmless.

Rows are addressed by the number you see in the source’s own interface, so where data starts depends on the source:

Source First data row Why
CSV / TSV 2 Line 1 of the file is the header.
Google Sheets 2 Row 1 is the header row, matching what Sheets displays.
JSON 1 An array of objects has no header row.
Airtable 1 Field names are not a row in Airtable; the first record is row 1.

The Start and End boxes and Data Preview follow this numbering, and the panel warns if you enter a row below the source’s minimum.