CSV Column Splitter

Overview

A generalised version of the CSV Loc Name Decomposer. Upload any CSV, then define one or more rules to split a source column into new derived columns. Three split modes are available:

ModeHow it works
DelimiterSplits on a character string — e.g. _ turns A_B_C into three columns
RegexExtracts capture groups — e.g. ^(\w+)_(\d+)$ yields two columns
Character positionsExtracts by index range (0-indexed, exclusive end) — same approach as the Loc Name Decomposer

Multiple rules can be stacked. Each rule inserts its output columns immediately after the source column. Drop your file below to get started.