🛡️Data is processed locally – We cannot see your data
Calculated Cols
Upload a dataset to begin
Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv
AboutCalculated Cols
Apply math formulas (A + B) to create new data.Category: Transformation & LogicCalculating a "Total" column from separate Price and Quantity columnsDeriving profit margin as (Revenue - Cost) / Revenue for every rowBuilding a weighted score column from several numeric rating columns
The Calculated Cols tool is compatible with:.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.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.
Frequently Asked Questions:
What kind of formulas can I apply?
Math operations across columns, like adding, subtracting or combining values from column A and B into a new calculated column.
Does this support conditional logic?
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.