How To Upload CSV Files to Clearbit

Last Updated: April 26, 2022

CSV uploads within Clearbit enable advertisers to build audiences based on lists of companies or email contacts. Once these files are uploaded you are able to leverage them to target Ad Audiences across Facebook and Google. If you select a company or contact list as part of your audience, you can also apply Clearbit demographic targeting, such as job function or seniority, to further refine your Audience.
Skip Ahead to:

What is Required When Uploading a File? 

Company Uploads

To upload a list of Companies, we require headers and at least one column that contains Domain Names. We require that there is one row per Domain Name and the file is saved as a CSV in UTF-8 format. Click this link for an example spreadsheet.

People Uploads

To upload a list of People, we require headers and at least one column that contains Email Addresses. We require that there is one row per Email and the file is saved as a CSV in UTF-8 format. Click this link for an example spreadsheet.

❗️Disclaimer: We do not currently support rows with embedded quotes.

How To Upload a CSV File

  1. Navigate to the Company or People tab within Clearbit. In the upper right-hand corner, select the dropdown and choose Import people from the CSV button.

    a1.png
  2. Select a properly formatted CSV file from your computer. The file must contain headers and either a column of email addresses or website domains.
    Upload_CSV_files___Clearbit_X_2021-03-25_at_6.13.25_PM.jpg
  3. Match the columns from your CSV upload to your Clearbit dataset.

    📝 Please note:
    If you are uploading Email Addresses, then map the column name containing them to Email. You can also upload custom files and map these to custom traits within Clearbit.
    If you are uploaded company domains, they cannot contain "https://www." in front of the domain. For example, you could use "Clearbit.com", but not "https://www.Clearbit.com".

  4. Once you have mapped the file successfully, click Import in the bottom right and you are done!
    Import_people_from_CSV___Clearbit_X_2021-03-25_at_6.20.10_PM.jpg