Split full names into first and last name
To split full names in a CSV, open the name splitter in Sigmera, pick the name column and the format (First Last or “Last, First”), and get separate first and last name columns — plus an optional middle name. Preview the result, then download the split file. Sigmera does this entirely in your browser, so your data is never uploaded to a server and stays GDPR-safe by design.
Last updated: June 2026
Use the name splitter free in your workspace
Free account, no credit card — every tool, unlimited rows, 3 free downloads a month, nothing uploaded.
🔒 Everything runs in your browser — your file is never uploaded, and the workspace even works offline once it has loaded.
Ways to split a name column, compared
| Method | Data uploaded? | Handles "Last, First" | Skill needed |
|---|---|---|---|
| Sigmera (this tool) | No — runs in browser | Yes, automatically | None |
| Excel TEXTSPLIT / LEFT-RIGHT formulas | No | Only with custom formulas | High (formulas) |
| Excel Flash Fill | No | Sometimes (pattern-dependent) | Medium |
| Python / pandas | No | Yes, with code | High (code) |
How to split a name column
- 1. Drop your CSV into the tool. The file is read into your browser’s memory — it is never sent over the network.
- 2. Pick the name column and format. Sigmera auto-detects a column containing “name”, but you can override it. Choose First Last, “Last, First”, or let it detect the order per row.
- 3. Preview the split. New first_name and last_name columns (and middle_name if you enabled it) appear next to your original data, with a count of how many names were split.
- 4. Download the split file. Create a free account to export the full CSV with the new name columns.
Why split names without a formula?
Splitting a name column sounds trivial until you meet real data. Some rows are “First Last,” some are “Last, First,” some carry a middle initial, and others are a single mononym with no last name at all. Excel formulas and Flash Fill can handle the clean cases, but they break the moment the pattern shifts — and they assume you’re comfortable writing nested FIND and MID expressions. For non-technical users that’s a real wall. Sigmera handles the messy reality in the browser: it switches on a comma automatically, optionally pulls the middle tokens into their own column, and shows you a preview so you can catch the awkward rows before you commit. Because the file never leaves your device, there is no upload, no server, and nothing stored — which satisfies GDPR data-minimization because zero bytes leave the browser.
Prefer to do it in a spreadsheet? Our guide on how to separate names in Excel walks through Text to Columns, Flash Fill, and the LEFT/RIGHT/FIND formulas step by step.
Frequently asked questions
- Does this tool upload my file?
- No. The name splitter runs entirely inside your web browser using client-side JavaScript. Your CSV is never uploaded to a server and never leaves your device, so it is GDPR-safe by design — you can even disconnect from the internet after the page loads and it still works.
- How does it handle "Last, First" order?
- If a value contains a comma — like "Hopper, Grace" — the tool treats everything before the comma as the last name and everything after as the first name. You can force this with the "Last, First" format option, or leave it on "Detect automatically" to switch per row based on whether a comma is present.
- What about middle names or two-word last names?
- Turn on "Also extract middle name" to capture the inner tokens (for example the "G." in "Katherine G. Johnson") into a separate middle_name column. Name parsing is inherently messy, so two-word surnames like "Van Der Berg" may land partly in the middle column — review the preview and use the column override to confirm before downloading.
- Can I do this in Excel instead?
- Yes — Excel can split names with TEXTSPLIT, LEFT/RIGHT/FIND formulas, or Flash Fill, and Google Sheets has Split text to columns. They work but require writing formulas or coaxing Flash Fill into the right pattern. Sigmera splits the column in a couple of clicks, including "Last, First" order, without any formulas.