To add Excel data to a map, the spreadsheet data must contain at least one of these location types: street addresses, latitude and longitude values (coordinates), or place names such as a U.S. city, state, world city, country, ZIP Code, or postal code.
Esri Maps for Office also supports adding custom location types such as park boundaries or sales territories for your organization.
About location types
Latitude and longitude—Latitude and longitude values represent the position of a point on the Earth's surface in an X, Y format. You can add X, Y coordinate data to Esri Maps for Office if it's in either the World Geodetic Survey 1984 (WGS84) or Web Mercator coordinate system. If you are unsure as to the correct coordinate system to use, check with the person who originated the spreadsheet or collected the data. If your latitude (Y) values fall between -90 and 90 and the longitude (X) values fall between -180 to 180, use WGS84. If your latitude and longitude values are in meters and have 6, 7, or 8 digits before (to the left of) the decimal point, use Web Mercator.
Address—In the United States, address data is comprised of street name, city, state, ZIP Code, and country. There are similar address elements in other countries. The more address elements your data contains, the more accurate your results will be. When providing address information, the address elements can be in separate cells in the spreadsheet, or they can be contained in a cell (single-line address).
U.S. City, State, ZIP Code, World City, and Country—Cities (U.S. city and world city) are added to the map as points. States, ZIP Codes, and countries are added to the map as polygons, which represent both the shape and the location of the place. When adding World Countries, you can use the Geonames Country Codes as a reference for accepted spelling variations.
Custom location types—This feature allows you to use a hosted service from ArcGIS to specify a location type. For example, if your organization has its own boundaries (water districts, sales districts, zoning boundaries) shared on ArcGIS, you can map your spreadsheet data using those locations instead of the default location types. First, you will need to add a new location type. After that, you can use your custom location type to map your records.
To add a custom location type, do the following:
In the carousel window, click the Location Type drop-down menu and click More. Click the My Locations tab and click Add location type. This will begin the process of adding a new location type to the list of available choices.
Search all of ArcGIS (all results) or within your organization (my organization) for the hosted service you want to use as a custom location type. Type your search query into the Search across ArcGIS for location types field and press Enter (or click the magnifying glass icon). Click Select to choose the desired hosted service .
From the Choose the location layer drop-down menu, choose a layer within the hosted service to use as a custom location type.
Check the check box beside the column or columns that will be used to match your spreadsheet data to the features in the hosted service. Be sure the values in both places (spreadsheet and hosted service) are of the same type (number or text) and formatted identically or you won't be able to use your custom location type.
Provide a unique name for the custom location type and click Add location type.
The custom location type is now available for use in the Location Type list.