Data from CSV

Pull specific values from CSV data imported via a text layer.

Expression Code

// Data from CSV
// Apply to Source Text
// First import CSV to a text layer via File > Import

csvLayer = thisComp.layer("CSV Data");  // Text layer with CSV
row = 2;        // Row number (1 = header)
column = 3;     // Column number

data = csvLayer.text.sourceText.split("\n");
cells = data[row - 1].split(",");
cells[column - 1];

Import a CSV file to a text layer (paste or import). Reference that layer and specify which row and column you need. The expression parses the CSV and returns the specific cell value.

Back to Data & Linking