You will get a file where the names are accurately separated into first and last names.

Tom S.
Tom S.
5.0
Top Rated

Let a pro handle the details

Buy Data Entry & Cleaning services from Tom, priced and ready to go.

You will get a file where the names are accurately separated into first and last names.

Tom S.
Tom S.
5.0
Top Rated

Select service tier

  • Delivery time 2 days
  • Number of Revisions 2
  • Number of Pages Mined/Scraped 10000
2 days delivery — 25 Jul 2024
Revisions may occur after this date.
Upwork Payment Protection
Fund the project upfront. Tom gets paid once you are satisfied with the work.

Let a pro handle the details

Buy Data Entry & Cleaning services from Tom, priced and ready to go.

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.
Data Tool
Microsoft Excel
What's included
Service tiers Starter
US$65
Standard
US$200
Advanced
US$600
Delivery time 2 days 2 days 3 days
Number of Revisions
222
Number of Pages Mined/Scraped
10000100000500000

Frequently asked questions

5.0
68 reviews
100% Complete
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)
Rating breakdown
Availability
5.0
Deadlines
5.0
Skills
5.0
Cooperation
5.0
Quality
5.0
Communication
5.0

GS

Gregory S.
5.00
22 Jun 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.

JG

Justin G.
5.00
10 Jun 2024
Consult Tom is excellent and knows what he is doing!

CS

Christina S.
5.00
31 May 2024
Build business financials spreadsheet

MH

Maureen H.
5.00
29 May 2024
Excel/Google Sheets Expert Needed for One-Time Job

BM

Brittany M.
5.00
29 May 2024
Match clinical trial data to biotech/pharma firms Another great job by Tom! Highly recommend.
Tom S.

About Tom

Tom S.
Google Sheets & Excel:Spreadsheet, Data, Scripting & Automation Expert
100% Job Success
5.0  (68 reviews)
Ann Arbor, United States - 9:32 pm local time
Do you have a project that involves spreadsheets - Microsoft Excel or Google Sheets? Let's talk! I would love to hear about your project, ask some good questions, collaborate toward a solution, and deliver results that will wow you. I can be very technical when required, but I am also very adept at working with less technical audiences and bridging the technology communication gap. I live for these kinds of reactions:

"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

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'm a software developer and former software executive with a mathematics and statistics degree 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.

Review the work, release payment and leave feedback for Tom.