Calculated Cols
Upload a dataset to begin
Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv
Sign in for free for unlimited files, no payment required.
About Calculated Cols
Apply math formulas (A + B) to create new data.
You write an expression referencing existing column names (like Price * Quantity or Revenue - Cost), and the tool evaluates it row by row to populate a new column. Because it operates per-row rather than as a spreadsheet formula engine, results are static values baked into the export, so there is nothing to recalculate or break when the file is opened elsewhere.
Category: Transformation & LogicCommon Use Cases
- Calculating a "Total" column from separate Price and Quantity columns
- Deriving profit margin as (Revenue - Cost) / Revenue for every row
- Building a weighted score column from several numeric rating columns
Key Features
- Row-wise evaluation of math expressions referencing column names
- Supports standard arithmetic operators across multiple columns
- New column added directly to the dataset, values are static (no live recalculation)
Rename Columns first if your source headers make formula references confusing, then use Binning after computing a metric here to group the new calculated column into buckets for reporting.
Frequently Asked Questions
Math operations across columns, like adding, subtracting or combining values from column A and B into a new calculated column.
It's built around straightforward math expressions to generate new columns from existing ones.
Handy for analysts who need a quick derived metric without opening the file in Excel.
Read the related guide →