Split Full Names Online

Split full names into first, middle, and last name columns and export to Excel.

100% private. Everything runs in your browser. Your data never leaves your device.

Split Names

What does this tool do?

This tool splits full names into first, middle, and last name columns automatically, then lets you download the result as Excel. It runs entirely in your browser.

How to use Split Full Names - Free Online Tool

  1. Paste full names (one per line), or click "Try with sample data".
  2. Click Split Names.
  3. Review the first / middle / last columns.
  4. Copy or download the result as Excel.

Example

Splitting full names:

Before

Full Name
John Michael Smith
Mary Jones

After

First Middle Last
John Michael Smith
Mary Jones

Names split into parts; a missing middle name is left blank.

Excel formula alternative

Prefer a formula? You can achieve a similar result with LEFT / MID / RIGHT:

=LEFT(A2, FIND(" ", A2)-1)

Splitting names in Excel needs several FIND/LEFT/MID formulas. This tool does first, middle, and last at once.

When should I use this tool?

Separating first and last names for mail merge
Cleaning CRM or contact data
Sorting people by last name
Personalizing emails by first name
Preparing HR or student records
Standardizing a name column

Frequently Asked Questions

If a name has three or more parts, the middle part(s) go in the middle column. Two-part names leave the middle blank.

No. Splitting runs in your browser and your data stays on your device.

Yes. Export the first/middle/last columns as an Excel file.

They are treated as name parts. Review edge cases, as name formats vary widely.

Related tools

Split Text (Text to Columns)
Combine Columns
Extract Email Addresses
Change Text Case
Trim, Clean & Convert Case

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Remove Extra Spaces Extract URLs Extract Text Between Characters Add Serial Numbers Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator