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 insight into spatial patterns and allows for quick and easy visual analysis, but there may be times where you want 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?

Enriching your data allows you to add new columns of contextual data to the rows in your spreadsheet. You can choose 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 window opens.

    Enrich layer

  2. Click the layer drop-down arrow and choose the layer you want to enrich.
  3. Click the country drop-down arrow and choose the country for which you want to see demographics.

    The list of collections changes depending on the available collections for the selected country.

  4. Optionally, type keywords in the search field to search for specific variables. Press Enter or click the magnifying glass to search.
  5. Choose a data collection.

    On the next screen you can search for variables within the collection, choose one of the popular variables within the collection, or show all variables within the collection.

  6. Choose the variables you want to add to your spreadsheet, and click Next.
  7. The Enrich layer window shows a summary of the selected data collections, the type of areas that will be enriched, the number of variables selected, and the number of ArcGIS service credits you'll be charged based on the number of currently selected variables. To add or remove individual variables, expand the data collections, and place a check mark in the boxes beside 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.
  8. To append the new variables to your spreadsheet, leave <Create new> in the drop-down box beside the selected variables.
    This option is available only 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.
  9. Click Add data to system to begin the enrichment process.

    Once the enrichment process begins, your account is 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 for which you were charged.

    When the process is complete, a confirmation message appears over the map. Click OK.