What if you want to map custom regions in Excel 3D Map?
After yesterday’s video importing KML files from the Census.Gov site, today, we take a look at creating your own KML file using Google Maps and then exporting it to Excel.
In today’s example, I create a custom map of 10 neighborhood allotments.
Google Maps makes it easy to draw new polygons, name them, and then export the layer to KML. You can then import to Excel for Windows using 3D Maps.
Table of Contents
(0:00) Create custom shapes for Excel 3D Maps
(0:22) Neighborhood Allotments
(1:04) Open Google Maps
(1:34) Drawing a polygon for one jurisdiction in Google Maps
(2:40) Export polygons to KML in Google Maps
(3:00) Mapping in Excel with your custom jurisdictions
(4:37) Wrap-up