Split full names into first and last name

Got one Name column and need First name and Last name? Tidytable spots name fields and offers to split them for you, no formulas needed. The original column stays, so nothing is lost.

How to do it

  1. Drop your file on the box above.
  2. Open Clean up and look under Ideas for “Split Name into first and last name”.
  3. Press it. Two new fields appear next to the original, filled in for every row.
  4. Delete the original if you don’t need it, then Download.

Questions

What about names written “Lee, Ada”?

Those are understood too: “Lee, Ada” becomes “Ada” and “Lee”. With three words, the first is the first name and the rest the last name, and the examples show you which before you split.

Can it split addresses too?

It splits “Portland, OR” style values into City and State the same way.

Is my file uploaded anywhere?

No. Tidytable reads the file in your browser tab, on your own computer. There’s no server that sees your rows, no account, and nothing to delete afterwards.

Is it free?

Yes, with no sign-up and no limit on how many files you open.