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:

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

name,position,phone,skypelink,company
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

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.

Steps:

• Visit the menu Departments – Create new department.
• Choose the CSV option.

• 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.

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

• How to create a Department email signature.

---

Video tutorial

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

Extras

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.

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