How Can I Do Sales Territory Mapping Using Excel Data?

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.

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.
   

   

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 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.
6. Click Next. Change the Layer Name Field drop down to the column in your Excel spreadsheet with the name of your territories
   
   
7. Click Add Row to add additional layers in the hierarchy. Change the Layer Name Field drop down to the column in your Excel spreadsheet with the name of your Districts/Regions/Areas.
   
   
8. 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.
9. Click Finish. Maptitude creates a map with your territories.

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.

For more information on mapping data from Excel, please see the Maptitude tutorial video on creating maps from Excel data. 

For more information on importing Excel data into Google Maps, please see this video tutorial on how Maptitude can export your file into a Google Map-friendly format.