# Bulk Geographies by Uploading an Excel File

{% hint style="info" %}
For businesses evaluating new Geographies for Business Expansion, a quick tip to save time by uploading multiple geographies in CRM at once. Email <crm@inogic.com> for a personalized demo or download from our [Website](https://bit.ly/3X4NOzr) or [Microsoft AppSource](https://appsource.microsoft.com/en-us/product/dynamics-365/inogic.f6f3c73f-29de-4fa8-a396-87ea8a07b6c4?tab=Overview) and experience a [15-day free trial](https://bit.ly/3XhqLkM) yourself!
{% endhint %}

The users also have the option to upload multiple geographies through an Excel files supported by CRM using the Bulk Geographies feature in Maplytics.

![](/files/-MbdfkzzGgCQeLRMvA7K)

To upload the geographies in bulk, the user first needs to export an Excel template. Go to ***Settings > Data Management > Imports > select the ‘Excel Templates’*** and then click on the ‘Create Excel Template’ option. Select the ‘Excel Template’ and in the ‘Select data’ section, select the ‘Geography’ Entity in the ‘Filter by entity’ field.

![](/files/-Mbdfepqm1ni8L619PdK)

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/-MbdfaMl2cMCOmA_JXYP)

&#x20;**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.

{% 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/bulk-geographies-by-uploading-an-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.