Lanternhill Studio · Bank CSV Categorizer

Split Full Names or Addresses into Columns

Private by design: your files are read only inside your browser. Your files never leave your browser: nothing is uploaded to a server. We use cookieless Vercel page-view analytics; no file data is collected. Once the page has loaded the tool works offline.

Upload a CSV or Excel file, pick the column to split and whether it holds names or US addresses. New columns are added next to your data.

What it handles

Names: "First Last", "First Middle Last", "Last, First", titles like Dr. or Ms., suffixes like Jr. or III, and surname particles like "van der". Addresses: "Street, City, ST 12345" with optional Apt/Suite/Unit, and full state names. Unusual formats may land in the wrong column, so check the preview.

How-to guide: How to Split First and Last Name in Excel

How-to guide: How to Split First and Last Name in Excel

Related data cleanup tools: Bank CSV Transaction Categorizer · Remove Duplicates from CSV or Excel · Merge Multiple CSV Files into One · PDF Table to Excel · All tools

Want more than a quick fix?

Just starting out? Grab the free Starter Expense Tracker (pay what you want, $0 is fine).

More free tools

Guides