Data & CSV
CSV calculated column
Apply a safe mathematical expression to a numeric column and append the result.
A clear answer. Here’s how.
Evaluates the restricted expression grammar used by the function plotter, with x bound to each chosen decimal cell. Supports arithmetic and documented mathematical functions without executing JavaScript. Appends a unique heading, preserving original columns/order. Non-finite results or magnitudes above 1e100 are rejected; blank handling is explicit.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Your CSV
ID,Name,Team,Amount,Date 001,Ada,Design,120,2026-01-05 002,Sam,Writing,80,2026-01-06 003,Jo,Design,150,2026-01-07
- Column separator
- Comma
- Value column
- Amount
- Expression using x
- x * 1.2
- New column heading
- Adjusted amount
- Blank numeric cells
- Keep result blank
Example result
| ID | Name | Team | Amount | Date | Adjusted amount |
|---|---|---|---|---|---|
| 001 | Ada | Design | 120 | 2026-01-05 | 144 |
| 002 | Sam | Writing | 80 | 2026-01-06 | 96 |
| 003 | Jo | Design | 150 | 2026-01-07 | 180 |
x is the chosen numeric cell; the expression parser does not execute JavaScript.