Skip to main content
All CollectionsGetting Started
Spreadsheet / CSV Upload
Spreadsheet / CSV Upload

This article explains how to use the spreadsheet upload function to add a list of people to a Campaign or to Contacts.

Jordan Longtin avatar
Written by Jordan Longtin
Updated this week

Add contacts to your campaigns quickly using our spreadsheet upload function by following these steps:

With any spreadsheet upload you should check three things first:

  1. You have labelled your columns as obviously as possible. i.e. Name = Name, First Name = First Name, Company = Company, Email = Email etc.

  2. Your list is saved as either an .xlsx and .csv file.

  3. If you want SourceWhale to search your contacts email addresses, it can only search for 500 at a time. If you have email addresses for other contacts in the list already, then these don't count towards the 500.

  4. The maximum number of rows per spreadsheet is limited to 1000.

Below is a standard column mapping used when uploading a spreadsheet, however, you only really need the information that relates to a) the variables you use in your messaging and b) the data you are going to use to send messaging (emails, LinkedIn URLs).

Spreadsheet Column Header

Mapped To in SourceWhale

Name

Full Name

Company

Company

Role

Role / Job Title

Location

Location

Email

Email

Phone

Phone Numbers

Industries

Industries

Skills

Skills

LinkedIn URL (incl SalesNav and Rec)

Social URLs

Summary

Summary

πŸ’‘: Please note that SourceWhale purposely removes endings such as 'Inc' but this also includes 'Care' and 'Health' when filling in the company variables. Statistically, phrasing the company names like this gets much better results, as the outreach sounds less automated.


Uploading the spreadsheet

Make sure you columns of your spreadsheet are labelled e.g. Name, Company, Role, Email, Linkedin URL etc. Select upload on the left-hand side and either browse or drag and drop your list into the upload box.


Spreadsheet Options

You will need to then select from the following options;

  • Which Campaign you want to add this list to or just "add to Contacts".

  • You can alter CRM/ ATS sync options for the campaign if needed, or select the sync option if you are only adding to Contacts.

  • Whether you want to search for all emails, some emails (if you are missing any) or don't search for emails at all.

  • If you do want to search for emails, whether you want to search for work or personal emails, or both. We can also verify any emails you already have.

  • Finally, you should check your CSV / Spreadsheet column labels (left) are mapped to the correct variables in SourceWhale (right)

    • i.e. Name = Name, First Name = First Name, Company = Company, Email = Email, LinkedIn URLs = Social URLs etc.

  • It is worth noting that if your Campaign has a LinkedIn step in it (Inmail / Connection Request), you will need a LinkedIn URL in your spreadsheet.

*Searching for emails will require email search credits.


Review Contacts

You can then review the contact details for each of the contacts on your list, as well as see if this person already exists in your CRM / ATS and if someone from your business has already emailed this person. You can remove anyone you need to at this stage using the "x".


Review Outreach

Finally, you can review the messaging and steps for each of the contacts on your list by using the sequence drop-down and arrows at the bottom of the sequence editor. Once you have reviewed the messaging you need to click 'add all to campaign' in order for the contacts to be added to the campaign and for the outreach to start going out to them.


Adding Spreadsheet contacts to Projects and Tags

You can also add contacts to a Project via the spreadsheet upload function. When you upload a spreadsheet, you can find the Project section by using the grey drop-down arrow next to the campaign selector.

You can also add tags to contacts via the spreadsheet upload function. When uploaded you can find the Tags sections by using the grey drop-down arrow next to the campaign selector.


Learn how to add contacts via the Chrome extension here.

Stuck or need some help? Click on the chat icon at the bottom right-hand corner to connect with our support team! πŸ’¬

Did this answer your question?