Split or merge columns
A full name into first and last name, an address into street, postcode and city, a column cut on a delimiter: the new columns take the old one's place. Or the reverse, several columns joined into one.
What this tool does
- First and last name, in the usual orders: "Marie Curie", "CURIE Marie", "Curie, Marie".
- Street, postcode and city, from a one-line address.
- On a delimiter (space, comma, semicolon, hyphen, bar), into as many columns as needed, or at the first one only.
- Merge several columns with the delimiter of your choice.
- The original column kept or replaced, your choice.
What it does not do: Compound names without a hyphen ("Mary Ann Smith") are split at the first space, unless the surname is in capitals. The preview shows every split before you save.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Fix a CSV file : Broken accents, everything in one column, lost zeros: a file Excel opens right the first time.
- Remove duplicates : On the columns you choose, optionally ignoring case, spaces and accents.
- Near-duplicates : "Smith Ltd" and "SMITH LTD.": the almost-identical duplicates, reviewed one by one.
- Clean text : Extra spaces, non-breaking spaces, line breaks, invisible characters, case.
- Convert text to numbers : "1,234.56 $", "(45.00)", "12.5-": real numbers that add up.