Skip To Content

Enrich your data

Mapping the data in your worksheet offers insight into spatial patterns and allows quick visual analysis, but there may be times when 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 your worksheet. 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 worksheet to help you better understand the area around your locations.

Note:

If you plan to enrich your data, it's highly recommended that you format your data as an Excel table before you add it to the map. Using an Excel table allows ArcGIS Maps for Office to add columns containing new information to the dataset. If the layer was not created from an Excel table, you can overwrite the contents of an existing column for each demographic variable selected. For more information, see Tables and named ranges.

  1. Choose the layer that you want to modify: hover over the right side of the desired layer card to display its tools and click the Layer options button Layer options.
    Layer options pane
  2. In the Layer options pane, click Enrich data Enrich layer with demographic information to open the Enrich layer pane.
    Note:

    If your layer contains aggregated data, the Enrich data feature is not available.

  3. Choose the data collections you want to include.
    1. To change the country, click the drop-down menu and choose the country with the demographic information you want to see.
    2. To search for specific variables, type keywords in the search field and press Enter.
    3. To browse through variables, choose a data collection to see the variables it contains.

      You can search for variables in a collection, choose one of the popular variables in a collection, or show all the variables in the collection.

      You can restrict your search to show only results from specific categories. By default, the search shows results from all variables. Click the drop-down menu to view only results from one of the categories listed.

    4. Check the boxes of the variables you want to add.
      Tip:

      If you use a variable on a regular basis, click the Add to Favorites button Add to Favorites next to the variable. The star icon color changes to gold Favorite to indicate that the variable is a favorite. Click the Favorites tab to access all the variables you've tagged as favorites.

    5. The Selected variables panel on the right in the Add variables pane shows the number of variables you've selected in a checklist. Click a variable to remove it from the list.
  4. When you're done selecting variables, click Next.

    The Enrich layer pane shows the name of the layer being enriched, the current study area around which demographics will be collected, the currently selected variables to use to enrich your Excel data, and the number of features that will be enriched.

    Tip:

    To remove a variable, click Back to view the Selected variables panel and click the variable name to remove it from the list. Click Next to continue.

    Tip:

    Click the Show credits button Show credits to view the number of ArcGIS service credits you'll be charged based on the number of variables you chose. The Credit usage report shows the total number of records that will be added to your worksheet and the number of credits consumed.

  5. Choose one of the following to define the Study area for which you want information:
    • Ring—Returns information from within a specified radius around the features on the map, defined in miles, kilometers, feet, or meters.
    • Drive time—Returns information from an area within a specified number of minutes of driving time from the features on the map.
    • Drive distance—Returns information from an area within a specified distance of the features on the map, defined in miles, kilometers, feet, or meters.
  6. Note:
    • Map layers containing polygons will return results for the area within each polygon.
    • When a layer is styled using Country data, values returned during enrichment are approximate, based on generalization of features.

  7. To append the new variables to your worksheet, leave <Create new column> in the drop-down menu beside the selected variable.

    This option is available only if the layer was originally created from an Excel table (to learn more about creating a table from your data, see Tables and named ranges). If the layer was not created from an Excel table, click the drop-down menu and choose the column from your original data to overwrite with the demographic data. Overwriting data in your spreadsheet cannot be undone.

  8. Click Add data to worksheet 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.

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

    The selected variables appear in your Excel worksheet.

Note:

Geographic data enrichment consumes ArcGIS credits based on the number of variables added to your worksheet and the number of features in the selected layer. For more information, see Understand credits.