CSV Formula Applier

Add computed CSV columns with basic arithmetic formulas.

In: csvOut: csvTask: transform

CSV Formula Applier

Add a computed CSV column using arithmetic formulas over numeric columns.

Shareable input links

You can prefill this tool by adding ?input=... to the URL. Tip: URL-encode JSON/text values before sharing.

Expected input shape

Top-level object must include: csv, target, formula.
formula supports column names with + - * / and parentheses.
Non-numeric cell values are treated as 0 in formula evaluation.

Formula Input

Provide JSON with csv, target, and formula fields.

Updated CSV

CSV output including the computed target column.

price,qty,total
12.5,4,50
9,3,27

Workspace actions

Use this for quick computed fields like totals, ratios, or simple weighted values.

Split editor

Example input and output

Example CSV

{
  "csv": "price,qty\n12.5,4\n9,3",
  "target": "total",
  "formula": "price * qty"
}

Example CSV

price,qty,total
12.5,4,50
9,3,27

Related tools

CSV to JSON Converter

csv-tools

Convert CSV rows with headers into a clean JSON array.

In: csvOut: json

Open tool

JSON to CSV Converter

csv-tools

Convert a JSON array of objects into CSV with generated headers.

In: jsonOut: csv

Open tool

CSV Validator

csv-tools

Validate CSV syntax and structure — checks column consistency, unclosed quotes, and empty headers.

In: csvOut: text

Open tool

CSV Formatter

csv-tools

Normalize CSV by parsing and re-emitting with consistent quoting and proper cell escaping.

In: csvOut: csv

Open tool

CSV Viewer (Table View)

csv-tools

Render CSV data as an interactive table for quick visual inspection.

In: csvOut: table

Open tool

CSV Column Extractor

csv-tools

Keep only the columns you need. Specify column names and get a slimmed-down CSV.

In: csvOut: csv

Open tool

CSV Column Remover

csv-tools

Drop unwanted columns from a CSV. Specify which columns to remove and get a cleaned result.

In: csvOut: csv

Open tool

CSV Deduplicator

csv-tools

Remove duplicate rows from a CSV, keeping the header and the first occurrence of each unique row.

In: csvOut: csv

Open tool

CSV Cleaner

csv-tools

Trim whitespace and normalize CSV records before conversion.

In: csvOut: csv

Open tool

CSV to XML Converter

csv-tools

Convert CSV rows into XML records. Each row becomes a record element inside a records root.

In: csvOut: xml

Open tool

CSV to HTML Converter

csv-tools

Convert CSV content into a standalone HTML table document for browser-friendly sharing.

In: csvOut: html

Open tool

XML to CSV Converter

xml-tools

Convert a structured XML document with repeating record elements into CSV rows.

In: xmlOut: csv

Open tool

CSV to YAML Converter

csv-tools

Convert CSV rows into YAML arrays of objects.

In: csvOut: yaml

Open tool

YAML to CSV Converter

yaml-tools

Convert YAML arrays of records into CSV rows.

In: yamlOut: csv

Open tool

CSV Sorter

csv-tools

Sort CSV rows by one or more columns.

In: csvOut: csv

Open tool

CSV Filter

csv-tools

Filter CSV rows by column conditions.

In: csv, queryOut: csv

Open tool

CSV Join/Merge Tool

csv-tools

Join two CSV datasets on a shared key.

In: csvOut: csv

Open tool

CSV Splitter

csv-tools

Split CSV content into smaller row chunks.

In: csvOut: csv

Open tool

CSV Transpose

csv-tools

Transpose CSV rows and columns.

In: csvOut: csv

Open tool

CSV Header Editor

csv-tools

Rename, add, or remove CSV headers.

In: csvOut: csv

Open tool

CSV Delimiter Converter

csv-tools

Convert CSV between comma, semicolon, tab, and pipe delimiters.

In: csvOut: csv

Open tool

CSV Statistics

csv-tools

Compute row/column stats and numeric summaries for CSV data.

In: csvOut: json

Open tool

CSV Encoding Converter

csv-tools

Convert CSV text between UTF-8, Latin-1, and Windows-1252 encodings.

In: csvOut: csv

Open tool

Excel to CSV Converter

csv-tools

Convert a base64-encoded XLSX workbook sheet into CSV.

In: xlsxOut: csv

Open tool

CSV to Excel Converter

csv-tools

Convert CSV text into an XLSX base64 output envelope.

In: csvOut: xlsx

Open tool

CSV Column Profiler

csv-tools

Profile CSV columns with inferred type, emptiness, uniqueness, top values, and numeric percentiles.

In: csvOut: json

Open tool

Universal Converter

json-tools

Auto-detect sources and convert across supported JSON, XML, YAML, CSV, and Excel pairs, including structured JSON input and Excel base64 envelopes.

In: textOut: json, xml, yaml, csv, xlsx

Open tool

Data Generator

json-tools

Generate deterministic mock records for JSON/CSV/XML/YAML testing.

In: jsonOut: json, csv, xml, yaml

Open tool

CSV Row Transformer

csv-tools

Apply per-column transformation rules to CSV data. Chain operations like trim, uppercase, lowercase, rounding, date conversion, and find-replace.

In: csvOut: csv

Open tool

CSV Pivot

csv-tools

Create a cross-tabulation (pivot table) from flat CSV data. Specify row key, column key, aggregation field, and function (count, sum, mean).

In: csvOut: csv

Open tool

CSV Data Generator

csv-tools

Generate mock CSV with configurable columns including uuid, email, integer, float, date, boolean, enum, and name.

In: jsonOut: csv

Open tool

CSV Chart Viewer

csv-tools

Plot numeric CSV columns as a bar or line chart. Choose axes and chart type; runs 100% in the browser.

In: csvOut: rendered-chart

Open tool

CSV Heatmap Viewer

csv-tools

Render CSV as a color-graded table where numeric cells are colored from cool (low) to warm (high) within each column.

In: csvOut: rendered-table

Open tool

Scroll horizontally to view all related tools.

Reverse tools

No reverse tool detected for this format pair

Next steps

No mapped next steps yet

Included in workflows

Validate CSV then CSV Formula Applier

Validate raw CSV first, then run CSV Formula Applier for a safe, repeatable pipeline.

Beginner~2 min

Open workflow

Clean CSV then CSV Formula Applier

Normalize CSV structure before running CSV Formula Applier to reduce downstream surprises.

Beginner~2 min

Open workflow