- Copy and paste entries from an Excel document containing addresses (city and state is good enough).
- Click "Validate & Set Options" and select the desired settings.
- Click "Make Map."
- Once the map has been made, complete the fields and proceed.
- When the finalized map is displayed, scroll to the bottom and click "Download as KML."
- In ArcMap, import the KML as a point file.
- Add X,Y coordinates using XTools.
- Export to Excel using XTools.
No comments:
Post a Comment