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.
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.
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.
Your data appears on a map.
Step 4: Change the basemap to Dark Gray Canvas so your property symbols stand out.
Step 5: Now you’ll add the demographics layers from ArcGIS Living Atlas. On the map toolbar, click ArcGIS data.
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.
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.
Median home value data is added to your map.
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.
The flood hazard areas are added to your map.
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.
This article was originally published on November 5, 2018 and has been updated.