1. Home
  2. Departments
  3. How to create email signatures from a CSV file?

How to create email signatures from a CSV file?

This post is also available in: Português

In this step-by-step tutorial (with a video at the end), we will show you how to create email signatures with a CSV file containing a list of employees.

You can find the employee list from many external sources such as CRM, HR software, or your company email platform.

About the CSV file

CSV files are text files that represent tabbed data and are supported by most applications that manipulate tabbed data, such as Google Sheets, Excel, or LibreOffice Calc.

Normally, you can create tabular data with these applications, and at the end, export it to Comma-separated values.

Here is an example of exporting with Google Sheets:

Google Sheets CSV file example

In plain-text format, it simply looks like the example below if you open the file.

Julio Delgado,Customer Support Team,33 1 336-5522,https://join.skype.com/Aq6GGiOBD,Bybrand
Guilherme Mattos,Customer Support Team,33 1 336-5522,https://join.skype.com/1AqOBDGGi,Bybrand
Adryane Lins,Onboard Marketing | Bybrand,33 1 336-5522,https://join.skype.com/BDGGi9AqO,Bybrand

Creating a CSV file

Before starting the import, set the correct format and check for no missing headers; the import will fail if that happens.

Here is an example of line 1, with five headers (columns):

  • name
  • position
  • phone
  • linkedin
  • comapny
Here is an example headers

The first line (header) are the placeholders that you will add to the email signature later. The following lines are employee data for each interaction.

You can keep an empty cell. For example, row 4 with the name Adryane Lins could have the Phone field empty.

Here is an example file for download. But you don’t need to be limited to it; you can also add or remove columns.

Download CSV file example.

Importing a CSV file

With your list of employees created, now comes the best part. Let’s import the file into Bybrand.


  • Visit the menu Departments – Create new department.
  • Choose the CSV option.
Example ofoption CSV file
  • Next, click to Choose file and submit.
  • It is possible to see a preview of the file before the import; if everything is correct, Confirm and import.

Next, you must associate the email signature with the department.

Adding a signature to the department

After successfully importing the employee list, you must associate an email signature on the newly created department in the next step.

If you don’t have an email signature, you can create one and go back to that step again.

Remember that the email signature must have the items from the first line of your file. Here is an example of an email signature with mapped placeholders.

Email signature with placeholders

Read a complete tutorial on how department email signature works at this link below.

Video tutorial

Here we have a complete video tutorial with all the steps above.


If you want to make basic changes like adding new header fields, you can visit the Edit department part.

An alternative is also to export the list of employees, make the advanced modifications in MS Excel, and when complete, send the file to a new department.

Edit department

You can associate the same signature if you delete the old department or clone the email signature from that department.

Updated on 12 de July de 2022

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support