Turn a “Full name” column into First name, Middle/prefix and Last name — for CRM, Mailchimp or HubSpot imports. Handles “Smith, John”, prefixes like van/de/von and suffixes like Jr.
Drop a CSV or Excel file with a name column. It's read in your browser.
SheetFix guesses the column; change it if needed. Preview the split instantly.
Get CSV or Excel with three new columns next to your original — nothing is deleted.
Excel's Text to Columns splits on every space, which breaks names like “Anna van der Berg”. Upload the file here and you get First, Middle/prefix and Last name columns in one go.
Yes. van, de, der, den, ter, von and similar prefixes go into the Middle/prefix column, so “Jan de Vries” becomes Jan · de · Vries.
Names with a comma are read as “Last name, First name”.
No. The original stays; three new columns are added next to it. Single-word names are flagged so you can check them.
No. Everything runs locally in your browser.
Fix spaces, emails, phone numbers, dates and capitalization.
Lowercase emails, flag invalid ones and remove duplicate contacts.
Prepare CSV/Excel for Shopify, HubSpot or Salesforce: field mapping, validation, safe fixes.