This is an archive related to a previous version of ArcGIS Maps for Office. If you need the current version go to http://doc.arcgis.com/en/maps-for-office/.

Enrich your data

Mapping the data in your spreadsheet offers great insight into spatial patterns and allows for quick and easy visual analysis, but there may be times where you would like to quickly and easily add contextual information about the area surrounding that data. Esri's geoenrichment capabilities allow you to answer questions about locations that you can't answer with maps alone. For example: What kind of people live here? What do people like to do in this area? What are their habits and lifestyles? What kind of businesses are in this area?

By using the Enrich data tool you can add new columns of contextual data to the rows in your spreadsheet. You can select from a number of demographic, business, landscape and policy data collections. Each collection has multiple variables that can be added to your spreadsheet to help you better understand the area around your locations.

  1. Click the Enrich data button on the map ribbon. The Enrich Layer dialog box appears.
  2. In the Enrich Layer dialog box, choose a data collection. On the following screen you can search for variables within the collection, select one of the popular variables within the collection, or show all variables within the collection. After selecting the variables you'd like to add to your spreadsheet, click Next.
  3. The Enrich Layer dialog box shows a summary of the process so far, including the selected data collections, the type of areas that will be enriched, the number of variables selected, and the number of credits you would be charged based on the number of currently selected variables. To add or remove individual variables, expand the data collections and place a check in the boxes next to the variables you want to include.
    • By default for point layers, data will be returned for a 1 mile circle surrounding each location. To change this value to a different distance or to a drive time polygon, click Edit and make the appropriate changes.
    • Map layers containing polygons will return results for the area within each polygon.
  4. To append the new variables to your spreadsheet, leave <Create new> in the dropdown box next to the selected variables. This option will only be available if the layer was originally created from a table (to learn more about creating a table from your data, see Tables and named ranges). If <None> is selected, you must choose which columns of your original data you want to overwrite. Click Add data to system to begin the enrichment process. Once the enrichment process begins, your account has been charged for the transaction. Do not close the window, click cancel, close Excel, or otherwise interfere with the process or you will not receive the enriched data that you were charged for.