Split and Join Columns
Splitting combined values like Full Name needs this editor. Files open in your browser, never uploaded. Pick a space separator for splits. Clear headers and UTF-8 required. Visible values process, not formulas.
Step by step
- Save the list as UTF-8, note the delimiter.
- Open the tool, confirm the Full Name column.
- Split by space into two new columns.
- Fix double names in the preview.
- Download and import the table.
Example scenario
A 300-person HR list holds combined names. Splitting by space breaks triple names; first part becomes First Name, rest Last Name. Twelve records are fixed manually.
Check your result
Confirm no empty name cells and unchanged row counts. Review special characters. Change the separator on errors.
Frequently asked questions
Double first names?
Map first word to First Name, rest to Last.
Data loss?
Original column is kept; new ones added.
Split dates or phones?
Yes, use dot or hyphen separators.
Formatting?
Only visible text is processed.
Open the tool: Split and join columns →
Keep an original copy before processing your file. Examples are illustrative; results depend on your document.