Split or merge text columns
Upload your sheet and download it with the column split into several, or with several joined into one.
Splitting
The typical case: a "Surname, Name" column you need as two, or an address field holding street, number and city separated by commas.
Name the column and the delimiter, and the tool generates as many columns as needed. The count is decided by the most-split row of all: if one has four parts and the rest two, four columns come out and the ones that had none stay empty.
Merging
The inverse: joining street, number and city into a full address, or first and last name into a single name.
Empty parts are discarded automatically. Joining "1 High Street", "" and "London"
with a comma produces 1 High Street, London, not 1 High Street, , London.
Keeping the original columns
It is off by default, but worth turning on the first time: it lets you check in the same file that the result is what you expected before discarding the source data.
Frequently asked questions
Can the delimiter be more than one character?
Yes. You can use " - " with spaces, "||" or any string.
What if a row does not contain the delimiter?
It stays whole in the first new column and the rest come out empty. Nothing is lost.
Can I merge columns that are not adjacent?
Yes. They are merged in the order you name them, not the order they sit in the sheet.
Is this the same as Excel's "Text to Columns"?
For splitting, yes, with the advantage of not having to open the file. Merging is
what you would do in Excel with CONCAT or &, cell by cell.