# By Excel File

After plotting an excel file, user can click on the ‘Create Territory’ button to create territories along with the shapes plotted on the map as Geographies. The names of the territories and the respective Geographies will be fetched from the excel file.

The excel file should in the supported file format as mentioned below.

**Name:** Name of Geography.

**Search Option:** Bulk geography feature is available only for the ‘By Region’ option, so this value should always be ‘1’.

**Color:** Color should be in Hexadecimal format i.e. (#DAF7A6). If the user enters the color in other formats then the default color (Blue) will be set.

![](/files/-Mbdwz8P5ip9dr4hBMQ_)

 **Region Type:** There are 6 region types that the user can define to create the geography. (Country, State, County, City, PostalCode1, PostalCode2).

**Region Value:** If the user needs to create the geography based on Postal Code, then they can define the postal code values in this column. To define multiple geographies in single territory, use the comma separator (,).

**Territory:** This is a lookup value to define which geography belongs to which territory.

**Manager**: The names of the users can be provided here. While creating territories, the managers for the respective territories. However, the column of ‘Manager’ is not mandatory to be in the excel file.

{% hint style="info" %}
***For Territory management***

* ***The column of ‘Territory’ should contain the Names of the territory(ies)***
* ***Color: Color should be in Hexadecimal format i.e. (#DAF7A6). If the user enters the color in other format then the default color (Green) will be set.***
* ***There are 8 region types that the user can define to create the geography. (Country, State, County, City, PostalCode1, PostalCode2, PostalCode3, PostalCode4)***
  {% endhint %}

{% hint style="success" %}
For any queries, reach out to us at <crm@inogic.com>
{% endhint %}

​


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.maplytics.com/features/territory-management/create-territory-on-one-click/by-excel-file.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.