Importing customers through a CSV file allows you to take advantage of Simplesat's Email publish channel.

📖 Learn more about email survey delivery settings

Preparing your import file

Head over to the Customers page and click Import customers.

To make sure data is imported correctly, we recommend starting our CSV template. You can find the link to download in the import popup, or get it here.

Working with the template CSV file

The template file looks like this:

Rows A-F (First Name - Country) will connect to core system data. Do not add columns or change the order of these columns - Simplesat looks at the column order to determine the field. (ie "Last Name" must be the second column)

The Email field is required. All other fields are optional and can be left blank.

Custom attributes

You can include custom attributes with each customer record to use as rules for your audience. 

Any data you include right right of column F (Country) will be added as custom attributes.

Simplesat will look to the value in the header row to determine if the custom attribute exists. If it does, the existing record will be updated, if it doesn't a new custom attribute will be created.

The example below shows three custom attributes set: Person type , Company status , User role.

Importing customers

When ready, upload your CSV list through the import popup. 

After you click Upload the import will begin. You'll receive an email after the import is complete.

Viewing imported customers

To check the data you imported, refresh the customers page and choose the customer you'd like to view.

You can see their details in the left column, including custom attributes.

Updating existing customers

Simplesat uses the customer's email address as their unique identifier. To edit details for a customer who already exists in your account, upload another CSV file with a row including their email address.

Did this answer your question?