How To Upload CSV Files to the Clearbit Platform
Last Updated: November 9, 2022
CSV uploads within Clearbit enable platform users to build audiences based on lists of companies or email contacts. Once these files are uploaded you can leverage them to activate destinations, including Ad Audiences. 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?
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.
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
- 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.
- Select a properly formatted CSV file from your computer. The file must contain headers and either a column of email addresses or website domains.
- 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".
- Once you have mapped the file successfully, click Import in the bottom right and you are done!
Clearbit will not ingest emails or domains that do not match the formatting requirements. Clearbit also will not ingest emails or domains that it determines are invalid. If you notice a large discrepancy between your CSV and the number of companies or people uploaded, check your CSV for formatting and invalid records.