ArcGIS Maps for Office

Add Living Atlas data from ArcGIS Maps for Office

When using ArcGIS Maps for Office, you can add valuable context to your own data by enhancing it with authoritative content from ArcGIS Living Atlas of the World.

With a few simple steps, you can create a map that combines your Microsoft Excel spreadsheet data with information from Living Atlas about the surrounding people, housing, infrastructure, environment, and more. You can use the map to help visualize the data and answer questions.

Median home value and flood risk data from Living Atlas add context to your data.

For example, imagine you’d like to invest in residential property in Houston, Texas. You have a table of candidates based on price, square footage, and other data you collected from real estate web sites. To help you decide which property to buy, you also want to know the median home value of the neighborhood and flood risk. You can get this data from Living Atlas. Here’s how:

Step 1: Open your spreadsheet in Microsoft Excel, click the ArcGIS Maps tab, and sign in with your ArcGIS account.

ArcGIS Maps tab

You’ll need a license for ArcGIS Maps for Office to add ArcGIS data from Excel. If you don’t have a license, contact your ArcGIS administrator or join the Learn ArcGIS organization for a free 60-day membership.

Once you sign in, additional map tools appear.

Step 2: Click Add Map and choose the data you want to map.

Add Map selected from Map window

ArcGIS Maps for Office automatically populates the Dataset field with the first Excel table or named range in the worksheet. If your data contains only cell ranges, click Advanced data format and choose Cell range > Select range.

You want to see where your properties are located so you’ll style the data by location.

Step 3: For Map style by column, choose <None> from the drop-down menu. In the list of suggested map themes, verify that Location (Single symbol) is selected, and click Add data.

 

Data added from Excel

Your data appears on a map.

Step 4: Change the basemap to Dark Gray Canvas so your property symbols stand out.

Data on Dark Gray Canvas basemap

Step 5: Now you’ll add the demographics layers from ArcGIS Living Atlas. On the map toolbar, click ArcGIS data.

ArcGIS data selected from Map window

You see a search box and a list of the items in your ArcGIS My Content folder.

Step 6: From the drop-down menu, choose Living Atlas.

Living Atlas selected

The gallery updates to show data in Living Atlas. You can sort results by date, title, view count, or owner, or you can filter results to only show items in specific categories or regions, or by type, tags, or status. In this case, you’ll simply search for the item using the Search field.

Step 7: In the Search field, type 2018 USA Median Home Value and press Enter.

Step 8: Click the green circle in the 2018 USA Median Home Values (by Esri) feature layer to add the item your map.

 

2018 USA Median Home Value selected

Median home value data is added to your map.

Map with median home values

You also want to see flood risk data from Living Atlas. Again, you’ll find it through a targeted search.

Step 9: Click ArcGIS data, and choose Living Atlas from the drop-down menu. In the search box, type USA flood hazard areas, press Enter, and add USA Flood Hazard Areas by esri_landscape2 to the map.

Flood Hazard Areas layer selected

The flood hazard areas are added to your map.

Map with flood hazard areas

Step 10: On the map, zoom in to view the area surrounding a potential investment property.

Now you can explore the data in the map to decide which property is the best investment. You see one in an area with high home values and low flood risk. That looks like a good choice.

pop-up of median home value

More information

Get started with Maps for Office

Add layers from ArcGIS

How many million-dollar homes are in your town?

 

This article was originally published on November 5, 2018 and has been updated.

About the author

Molly is a documentation product engineer on the ArcGIS Online team. She's been with Esri since 2000, writing about a variety of internet mapping products. In addition to helping users make maps, Molly is passionate about trail running, Nordic skiing, ski mountaineering, climbing, and English Pointers.

Connect:

Next Article

Simplify weather measurements in the field using Arcade

Read this article