Editing values

Add Row .csv

Adds a row at the end of the loaded file, with its values in column order.

When to use it: to build a file from the workflow — inside a loop, one row per turn — or to append a single line to a file you opened. It is the only instruction that makes a CSV grow: every other one reshapes the rows the file already has.

Important behavior: the columns come from the file, not from this instruction: if it already has rows, the new one takes their columns and Column names is ignored. Only on a file with no rows are they taken from Column names — and failing that from the ones Create CSV/TSV file declared; with no columns anywhere the row is not added and the workflow says so. Values you leave out keep their column empty, and values with no column to go in are left out and reported. The separator is a field of its own, and not the file’s comma, precisely so a value can contain a comma; nothing is trimmed, so a space around the separator is written as part of the value. An empty Values adds nothing. On a table loaded without headers the values go in by position — this is the one instruction of the group that works there.

Apply Math Operation .csv

Runs a math operation on the numeric values of a column — multiply, add, subtract, divide, round, or apply a percentage change — and rewrites each cell with the result.

When to use it: to recalculate a numeric column in bulk — convert units, apply a discount or markup, scale figures, or round them to a set number of decimals.

Important behavior: if Column name is empty (or the document isn’t loaded) nothing happens — this instruction always needs a column, because a math operation only makes sense on numbers you chose. Cells that aren’t numbers are skipped. percent grows the value by Operand percent (e.g. 10 adds 10%); divide by 0 leaves the value unchanged; round ignores Operand and just rounds. Every result is rounded to Decimal places.

Change Date Format .csv

Reads the dates in a column written in one format and rewrites them in another.

When to use it: to standardize a date column — e.g. turn 31/12/2026 into 2026-12-31 — so the whole table uses one consistent date style.

Important behavior: if Column name is empty (or the document isn’t loaded) nothing happens — this instruction always needs a column, since only you know which one holds dates. Set Input format to match how the dates are written in your file: both formats default to yyyy-MM-dd, so out of the box the instruction expects ISO dates (and rewriting ISO as ISO changes nothing). To standardize dates written as 31/12/2026, type dd/MM/yyyy in Input format. Blank cells are skipped, and so is any value that doesn’t exactly match Input format — it is left as-is and not counted. The format uses the usual letters: dd day, MM month, yyyy year, HH hour, mm minute.

Convert Column Type .csv

Converts every value in a column to a chosen data type — text, whole number, decimal, or date.

When to use it: to clean up a column so its values share one type before filtering, sorting, or exporting — e.g. force a column to whole numbers, or normalize mixed date text.

Important behavior: if Column name is empty (or the document isn’t loaded) nothing happens — this instruction always needs a column, because the target type is chosen per column. Blank cells are skipped. integer rounds a decimal to the nearest whole number; decimal keeps the number as-is; date parses the value and rewrites it using Date format; text leaves the value unchanged. Any value that can’t be parsed as the chosen type is kept as-is and not counted.

Fill Empty Cells .csv

Fills the empty cells of a column — with a fixed value, the value from the row above, or the column’s average.

When to use it: to remove gaps in a column before analysis or export — e.g. put 0 or Unknown where a value is missing, carry the previous value down, or fill blanks with the mean.

Important behavior: if the document isn’t loaded nothing happens; if Column name is empty every column is filled. A cell counts as empty when it is missing or contains only spaces. previous uses the last non-empty value seen above (or Fixed value if none has appeared yet); mean uses the average of the column’s numeric values (or 0 if there are none). Both are worked out per column, so filling every column at once still uses each column’s own previous value and its own average.

Mask Sensitive Values .csv

Hides or anonymizes sensitive data in a column — emails, phone numbers, IDs, or any value — while keeping the table’s shape.

When to use it: to share or export a table without exposing personal data — e.g. turn jane.doe@acme.com into j***@***.com or a phone number into ********45.

Important behavior: if the document isn’t loaded nothing happens; if Column name is empty every column is masked — handy to sweep a whole table for emails or phone numbers. Note that custom replaces whole cells, so with an empty Column name it would blank out the entire table. Blank cells are skipped. email keeps the first letter and the domain ending (j***@***.com); phone keeps only the last two digits; id keeps the first and last character; custom replaces the entire cell with Custom mask.

What this instruction is not: the email, phone and id modes recognize values by their shape (text patterns), not by knowing what the data means. A value written in an unexpected way is left untouched, and a value that merely looks like an ID may be masked when it isn’t one. Treat it as a convenience for tidying up data you already understand — not as a guarantee of anonymization. If you must publish data where a leak matters, check the result, or use custom (which blanks the whole cell) or Remove Columns to drop the column entirely.

Normalize Text Case .csv

Changes the letter case of the text in a column — all uppercase, all lowercase, or Title Case.

When to use it: to make a text column consistent — e.g. tidy up names into Title Case, or force codes to uppercase.

Important behavior: if the document isn’t loaded nothing happens; if Column name is empty every column is recased. Empty cells are skipped. title capitalizes the first letter of each word; only cells whose text actually changes are counted.

Replace Text In Column .csv

Replaces every occurrence of a piece of text with another, inside one column.

When to use it: for a targeted find-and-replace in a single column — fix a recurring typo, swap a code for a label, or clean up a stray character.

Important behavior: if Search text is empty (or the document isn’t loaded) nothing happens; if Column name is empty the replacement runs on every column — a whole-table find and replace. Every occurrence within a cell is replaced. Matching ignores case by default; turn Case sensitive on to match exactly. Only cells that actually change are counted. Leave Replacement text empty to delete the matched text.

Trim Whitespace .csv

Removes leading and trailing spaces from a column’s values — or from every column at once.

When to use it: to clean up stray spaces that sneak in around values (e.g. from copy-paste or exports) and cause mismatches when comparing, filtering, or joining.

Important behavior: if the document isn’t loaded, nothing happens. Only spaces at the start and end of a value are removed — spaces inside the text are kept. Leaving Column name empty trims all columns. Only cells that actually change are counted.

Write Cell Value .csv

Writes one cell: the row by its position, the column by its name.

When to use it: to correct one datum, or to write a result the workflow calculated into a specific row.

Important behavior: an empty value empties the cell, as it does in a spreadsheet. A column the file has not got is not created — the other rows would not have it; to add one use Add Fixed Value Column. A row that does not exist does nothing — to make one, use Add Row.