How Can I Do Sales Territory Mapping Using Excel Data?

By /

You can do sales territory mapping using Excel data with sales territory mapping software.

With sales territory mapping you can improve sales efficiency, optimize resource allocation, and enhance customer targeting.

How Can I Do Sales Territory Mapping Using Excel Data? Table of ZIP Code Territories.
How Can I Do Sales Territory Mapping Using Excel Data? Table of ZIP Code Territories.
  1. Download a free mapping software trial of Maptitude Desktop or use your existing Maptitude Desktop license.
  2. Select New map of my territory table/spreadsheet and click OK.
  3. Select From my territory table and select the Excel spreadsheet with your territory data. Click Next. If you don’t have territory data in an Excel format, you can instead choose Interactively from areas in a map. For more information on creating territories interactively, please see the video tutorial on creating territories in Maptitude.

    How Can I Do Sales Territory Mapping Using Excel Data? Territory Table Settings.
    How Can I Do Sales Territory Mapping Using Excel Data? Territory Table Settings.
  4. Under Map Settings, change the Geography Layer drop down to the area that your territories are built from.
    For example, if your territories are based on 5-Digit ZIP Code, make sure that the Geography Layer drop down is set to 5-Digit ZIP Code.
  5. Under Your Territory Table Settings, change the Territory Field drop down to the column in your Excel spreadsheet with the name of your territories.
  6. Under Your Territory Table Settings, change the Geography Field drop down to the column in your Excel spreadsheet with name or identifier of the areas.
    For example, if your territories are based on 5-Digit ZIP Code, make sure that the Geography Field drop down is set to the column name that has the ZIP Code information.

    How Can I Do Sales Territory Mapping Using Excel Data? Territory Map Settings.
    How Can I Do Sales Territory Mapping Using Excel Data? Territory Map Settings.
  7. Click Next. Optionally, you can add Tracking Fields to keep track of demographic data or sales data for each territory.
    To learn more about Tracking Fields, please see the Maptitude tutorial article on Tracking Fields.
  8. Click Finish. Maptitude creates a map with your territories.
How Can I Do Sales Territory Mapping Using Excel Data? Territory Map.
How Can I Do Sales Territory Mapping Using Excel Data? Territory Map.

For more information on creating territories in Maptitude, please see the Maptitude tutorial video on creating territories.

For information on making changes to territories in Maptitude, please see the Maptitude tutorial video on working with territories.

Scroll to Top