Create Territories from File

Creating a Territory from a excel/csv file


NOTE: You can also overlay your point/account-based alignment on top of this alignment.

  1. Click on the Territories button in the Top Toolbar. 
  2. From the drop-down select New Alignment. You can also edit your existing Territory Alignments from here. 
  3. Select Areas from File  
  4. Select the csv or excel file you want to use to create your territory alignment

    creating a new territory alignment using a csv/excel file
  5. You must then select the following: 
    • The regional dataset your territory alignment will be based on (if creating hierarchical territory alignments check include hierarchy and select the number of levels). 
    • The corresponding column in your dataset to match the regional dataset. 
    • The territory identifier such as the territory owner of regional location. 
  6. Select complete and your territories will be created 

Create from File - Create Territories

Validation File

If any of the rows in your spreadsheet could not be matched in the territory creation process you will be presented with the below screen

  • Download the validation file to see what these are
  • Alternatively, select Proceed to Territories to import your territories regardless of these discrepancies