Skip to main content
All CollectionsContacts/Users/Crew
How to Separate First Name & Last Names in a Spreadsheet for Contact Upload
How to Separate First Name & Last Names in a Spreadsheet for Contact Upload

In order to upload a contact sheet, the first and last name must be separate columns. The following will show you how to do this.

Chloe Hunter avatar
Written by Chloe Hunter
Updated over a month ago

How to Separate First Name & Last Names in a Spreadsheet

Use the steps below if you only have a single name column in the file with your contacts.

Our importing requires you to have a separate First Name and Last Name column (see below).

Our importing requires you have separate First Name and Last Name column

1. In the Spreadsheet, Choose the Column That Needs to Be Separated

Note: This was done by uploading the .csv into Google Sheets.

Choose the Column that needs to be separated

2. Click on 'Data'

Click on Data

3. Click on 'Split text to columns'

Click on Split text to columns

4. Click on ‘Space’ as Your Separator

Click on Space as your Separator

5. The Columns Will Now Be Split Into Two. Now, Download the File Again

The columns will now be split into two. Download the file again.

6. Click on 'Import' to Import the New File

Click on Import to import the new file

7. Click on 'Start over' in the Spreadsheet

Click on Start over

8. Finally, Follow the Steps Here to Upload Your Contacts!


If you have any questions or need any assistance with your contact spreadsheets, please don't hesitate to contact DripJobs Customer Support or the Helpdesk.


Did this answer your question?