Split sizes from one cell into separate rows

How to split S, M, L sizes from one cell into separate rows

2026-06-20

Task

size contains a list such as S|M|L. The export needs one product variant row for each size.

Short answer

In the size column, enable row structure changes, choose split values into new rows, and use | as the separator.

How to do it in Eofferix

Open the settings of the size column.
The outline marks the size column that contains the size list.
In additional settings, enable row structure changes, choose split values into new rows, and set the separator to |.
After this setting, each part of S|M|L becomes a separate row.
Save the template and run the transformation on the final step.

source data

sku	name	size
TSHIRT-100	Basic T-shirt	S\|M\|L
HOODIE-200	Cotton hoodie	M\|L

result