Column Tools

Rename changes one header; the values stay put. Drop removes the columns you tick. Reorder moves columns into the order you set; any column you do not place keeps its relative position at the end. Fill writes a value into every empty or whitespace-only cell of one column, such as 0 for missing quantities or Unknown for a missing region.

Split breaks one column into several on a separator. Splitting full_name on a space into first,last adds those two columns right after the original, which is kept so you can check the result. If a value has more parts than names, the extra parts are dropped, so Mary Ann Smith gives Mary and Ann. Give the split one more name, or combine afterwards. Combine joins several columns into a new one with a separator, for example city and country into location, added as the last column.

Cast normalizes the values of one column, which helps before importing into a database or a tool with strict types. Casting to number removes thousands separators, so 1,200.50 becomes 1200.5. Values that are still not numbers, such as $5 or n/a, are left unchanged so you can find and fix them.

Casting to boolean maps 1, yes, y, and true to true, and 0, no, n, and false to false, ignoring case. Other values are left as they are. Casting to date (ISO) rewrites dates as YYYY-MM-DD using your browser's date parser. Slash dates are read US-style, so 03/04/2026 becomes 2026-03-04. A day-first date that cannot be a valid month, such as 15/01/2026, is left unchanged. For day-first data, reorder the parts with a regex in Find & Replace first.

Each run applies one operation to the input and shows the result straight away. To chain operations, for example split then drop then rename, copy the output back into the input between steps. That makes every intermediate result visible, so a wrong separator or column choice is caught early.

CSV, TSV, and JSON arrays of objects are supported, and the output uses the same format as the input. All values are text, so a cast to number produces "1200.5" as a string in JSON output; the cast cleans the formatting rather than changing the JSON type.