FROM GOVERNMENTS TO BUSINESSES, OFFICE DATA IS ON THE MAP. IF YOU ARE AN
ArcGIS Online user, you can now turn your Excel spreadsheet data into an interactive map without ever leaving Microsoft Office. Esri’s Maps for Microsoft Office can produce maps from spreadsheets just as quickly and easily as you can create a chart. Creating interactive maps of Excel data is simple. Maps can display locations, for example, customer addresses, sites by map coordinates, facilities, businesses, opportunities, distribution points; and geographic data, such as color-coded maps of sales by ZIPcode or enrollment by state.
By Karen Richardson
Karen Richardson is a 20 year veteran of Esri. She is a senior writer covering the use of GIS technology and data in the commercial industry and mapping and charting space.
The Spreadsheet Data Challenge: Leica Geosystems
Mike Cooper is a Market Manager for Western Europe and the Middle East at Leica Geosystems. Because he works in the GIS industry, he has an in-depth knowledge of it, but he never considered himself a technical user. While he spends a lot of time looking at and analyzing data on his desktop, he wasn’t using a GIS to produce maps that would improve his presentations.
Cooper is in charge of market development for Leica’s Zeno GIS series, which offers automated Global Navigation Satellite System (GNSS) post-processing and seamless integration with GIS systems. As Cooper was traveling Europe supporting distributors and talking to potential customers, he needed a way to easily show access to Europe’s SmartNet – an integrated GNSS Network – that can be accessed by Leica Zeno. “While we certainly have information on each country’s network avail- ability, I wanted to be able to show people quickly where SmartNet was available,” said Cooper. “This kind of information just lent itself to a map.” See Figure 1.
Cooper loaded the data into Microsoft Excel and using Maps for Office, created a map displaying the availability of different networks in Europe. “I’ve done this type of mapping before, but it always took time and some creativity to get what I needed,” said Cooper. “Using this, I honestly created a map within minutes. Nothing could have been easier.” Now Cooper can update the information from Excel whenever a status changes, which updates the map service he created for his distributors, customers and potential customers, who can view and share it on ArcGIS Online.
Make Maps Directly in Excel: How it Works
Esri Maps for Office is a downloadable add-in for Micro- soft Office 2010 that helps organizations make better decisions through location analytics. Interactive maps in a Microsoft Excel spreadsheet can be based on any geographic component, such as customer locations or sales by ZIP Code, can then be added to Microsoft PowerPoint presentations or shared through Esri’s cloud mapping platform, ArcGIS Online. Maps shared through ArcGIS Online are accessible throughout an organization and available for embedding into mobile or web applications. Through tight integration of Esri Maps for Office with ArcGIS Online, users can access a variety of background maps, including street, satellite, and topographic maps. These maps can also reuse and incorporate (mash up) any other map to which their organization provides access, as well as tens of thousands of additional maps published by Esri’s worldwide user community.
Impact Your Audience
Maps are powerful communication tools that help users get their points across quickly and efficiently. Maps can also help them look at their data in different ways to gain additional insight.
Once a map has been made, the results...