How to use a regex pattern to extract substrings from an excel column
- Step 1Upload your file — Drop an .xlsx or .csv with a column containing text to extract from.
- Step 2Configure the extraction — Enter the source column name, the regex pattern, and the output column name.
- Step 3Download the extracted file — A new column is added with the extracted text. Cells without a match are left empty.
Frequently asked questions
Does it support named capture groups?+
Named groups ((?<name>...)) are not yet used — the tool always takes the first capture group. Named group support is planned.
What if my pattern has no capture group?+
The full match (match[0]) is used when no capture group is defined.
Can I apply multiple regex rules in one pass?+
One pattern per run in the current version. Multi-rule extraction is on the Pro roadmap.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.