You will get a file where the names are accurately separated into first and last names.
Top Rated
Top Rated
Project details
Clients often have a list of people's names (in a CSV or Excel file) that need to be separated into first name and last name. This can be done manually, but that can take a long time and is fraught with human errors and mistakes. I've built tools in Excel that use data from the U.S. Census Bureau, the Social Security Administration, and other reliable sources to do this work not only quickly, but accurately and thoroughly. The tools do >90% of the work automatically, then point me to the <10% that requires manual attention.
Typical clients come to me with names from property tax records, mailing lists, and marketing lists.
NOTE: In the project service tiers, please interpret the numbers for "Number of Pages Mined/Scraped" as "Number of Names Processed" instead.
Typical clients come to me with names from property tax records, mailing lists, and marketing lists.
NOTE: In the project service tiers, please interpret the numbers for "Number of Pages Mined/Scraped" as "Number of Names Processed" instead.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$65
|
Standard
$200
|
Advanced
$600
|
|---|---|---|---|
| Delivery Time | 2 days | 2 days | 3 days |
Number of Revisions | 2 | 2 | 2 |
Number of Pages Mined/Scraped | 10000 | 100000 | 500000 |
Frequently asked questions
72 reviews
(72)
(0)
(0)
(0)
(0)
This project doesn't have any reviews.
GM
Gizem M.
Feb 5, 2026
Excel Data Analyst - 1
PN
Pouria N.
Feb 3, 2026
Data & Spreadsheets professional to help model comp plans for sales teams
DT
Dacey T.
Nov 26, 2025
Assistance Needed with Locking Corresponding Rows in Google Sheets (Query + Manual Data Alignment
g
RD
Reed D.
Jul 3, 2025
Excel Formula & Reporting Sheet for Monthly Client Metrics
Tom was GREAT. Always prepared, asked the right questions, and truly listened. He transformed how I was tracking and reporting tasks for my clients - saving me time and cutting down on a lot of manual, error-prone work. Highly recommend working with Tom if you get the chance. Thanks again!
GS
Gregory S.
Jun 22, 2024
Google Sheets Income Statement Improvements
It was a pleasure working with Tom. He was responsive, easy to coordinate with, kept his promises, fulfilled on his commitments and made thoughtful suggestions about how to improve my requests so the outcomes would be more productive and less costly. He took time to explain what he did, why he did it and helped me build the skills so that I could autonomously make adjustments in the future.
About Tom
Google Sheets & Excel:Spreadsheet, Data, Scripting & Automation Expert
100%
Job Success
Ann Arbor, United States - 1:13 pm local time
"Most people will think I’m crazy, but this workbook is a thing of beauty !! Thank you again for creating this work of art 😊." (Jan 30, 2023)
- Upwork client since 2019
"If life was a kickball team at recess, Tom is my first pick!" (May 20, 2020)
- Upwork client since 2020
I am more than a spreadsheet hobbyist. My 40+ years as a software developer and software executive, and my mathematics and statistics degree lead me to approaching Excel and Google Sheets projects as a software engineer - very systematically with accuracy, robustness, and performance in mind.
About 25% of my clients come to me after a failed effort by another, often inexpensive, freelancer. So, don't be discouraged. I can pick up the pieces and get your project back on track.
I gravitate toward data-centric projects and process automation projects that help you work more effectively and intelligently. I take pride in building reliable dashboards and production systems that are used on a daily basis. Several such systems I've built have been in continuous use for 5+ years.
I also specialize in a couple of niche data areas - 1) helping clients with messy contact information (names, addresses, etc.) and 2) fuzzy matching of names, addresses, organization names, school names, part descriptions, etc.
I am enjoying my retirement by getting back to the fun of working directly with clients on software development and data analysis. My favorite tools are Google Sheets / Google Apps Script (10+ years) and Microsoft Excel / VBA (25+ years).
Steps for completing your project
After purchasing the project, send requirements so Tom can start the project.
Delivery time starts when Tom receives requirements from you.
Tom works on your project following the steps below.
Revisions may occur after the delivery date.
Review of client information
You send me your list of names and the answers to the questions I have asked. I review this information and create an additional list of questions, if any are necessary. You reply to those questions, or we decide to make a phone or video call.
Deliver first draft
I deliver the results in the format you requested. Often, this draft is exactly what you need, and the project is complete.