Adding seats by uploading a CSV file

This article describes a CSV file and includes the upload procedure.

Comma-separated values (CSV) file

A CSV file is a text file used to upload multiple records to a service. Each row in the file is a data record that includes one field. Each row must end with a line break.

EXAMPLE  

Seat Management 1.0

Prerequisites

The following are requirements for creating a CSV file:

  • A header value must be present in Row 1, Column 1. It can say anything, but it MUST be one word and lowercase (e.g., "email")
  • The data rows below the header should contain lowercase email addresses or lowercase URLs in Column 1. Datto SaaS Protection will automatically skip records for those that already exist.

  • It is recommended that CSV files are limited to 500 records. You can add additional records in another upload.

  • Column 1 must only contain the header and email addresses or URLs, making sure the casing matches that of the application to which the CSV is being uploaded.

  • All email domains must match the domain name for which you are uploading.

Seat Management 2.0

Prerequisites

The following are requirements for creating a CSV file:

  • A header row should not be present.
  • The data rows should contain lowercase email addresses or lowercase URLs in Column 1. Datto SaaS Protection will automatically skip records for those that already exist.

  • We recommend that you limit CSV files to 500 records. If your total number of records is greater than this limit, split the excess into a separate CSV upload.

  • Column 1 must only contain the header and email addresses, making sure the casing matches that of the application to which the CSV is being uploaded.

  • All email domains must match the domain name for which you are uploading.

  1. Create a CSV file that includes all clients you'd like to manage. For each client, be sure to include the details described in the Seat Management 2.0 Prerequisites section of this article.
  2. On the SaaS Protection Status page, click the desired organization to expand its details.
  3. Navigate to the applicable Seat Management page.
  4. In the upper-right corner of the Manage section, click .
  5. Select Import CSV.
  6. In the Import CSV dialog box, click Choose File.
  7. Navigate to and select the applicable CSV file.
  8. To protect all seats that are being uploaded via the CSV file, leave Protect selected in the Action section of the Import CSV modal. To unprotect all seats in the file, select Unprotect.
  9. Click Import CSV.

Teams CSV file

You can add or remove Microsoft Teams in bulk via the CSV Upload feature. The CSV uploaded must be a list of the team owner email addresses for each team being added or removed. When you attempt to remove a team, you will be prompted with a confirmation request before the upload can be completed.