July 14, 2008

Add Maps to Excel Spreadsheets

Maps let your team see the spatial component of the data, and increases the speed from information to action.

Whether it is quarterly sales figures by territory, NGO project disbursements in Afghanistan or projecting crop losses due to flooding in the Midwest; when producing critical reports in Excel, being able to deliver maps in the same data tables is indispensible. Patterns not readily apparent in tables and charts become visible, new questions and decisions become visible based on spatial relationships. Geo-analytics happens.

AWhere makes it incredibly easy to map your MS-Excel data tables, but what about putting your maps in Excel? Yes, it is possible to augment your Excel reports with maps using AWhere with a simple cut and paste process.

First, select your map.
Next, use the "Copy" command button above the tree-view to copy the map image displayed in the map view.
Then, click on a table in MS-Excel and paste the map into the table using the "Ctrl-v" key combination or the "Paste" menu command in Excel.

Any questions? Post a comment here, or link over to our Forums to see how our team and other users are putting this into practice.

Topic Tags: AWhere, Excel, geo-analytics, map, map excel data, microsoft, spatial data

by Mike Swaim

↑top

link to this

Post a Comment

Title:

Summary:

Comment:

Links:

Your info:

Name:		Required; will be displayed with comment.
E-mail:		Required (in case we need to contact you); will NOT be displayed with comment.
Web:		Optional; will use to hyperlink your name in the comment.
Twitter:		Optional; allows visitors to follow you on Twitter.
Save this in my browser

Verification:

Type the characters you see in the picture above.

Letters are case sensitive.

Notice: Your thoughtful opinions are valued and encouraged, but all comments are moderated so there will be a delay between the time you post your comment and when it appears in this site. Please don't be offended if your comment is edited for clarity or to avoid questionable matters. Offensive or off-topic comments will be deleted.