/excel-geocoding-tool

Easy to use Geocoding tool for Excel.

Primary LanguageVisual Basic

Excel Geocoding Tool

Easy to use Geocoding Tool for Excel. Download, enable macros, and add your own location data. Click Geocode All and you're done.

Requirements

  • Windows XP/Vista/7 (32bit/64bit) OR Mac OS X 10.5.8 or later (Intel)
  • Excel 2003/2007/2010 OR Excel 2011 for Mac

Installation

Simply download and run the Excel file. Make sure to enable macros and enter a proxy address if necessary.

Getting Started

See the excel file for basic instructions.

Donate

Love the tool? Send a donation!

Changelog

3.6.1 - 2014-04-27

  • Tweak - You can now geocode up to 65k rows instead of 32k, huzzah!
  • Fix - Fix typo affecting "Geocode not found rows" functionality

3.6 - 2013-09-15

  • Feature - Mac compatibility returns! Use Excel for Mac 2011 or greater
  • Tweak - Refactor for easier maintainability
  • Tweak - Greatly improved error handling

3.5.1 - 2013-05-02

  • Fix - Fixed issue with error handling

3.5 - 2013-04-21

  • Fix - Use Bing for geocoding now that Yahoo's PlaceFinder API was discontinued

3.4.2 - 2012-07-15

  • Feature - Added debug mode
  • Tweak - Removed string cache, as it was causing a fatal error in some Excel versions
  • Tweak - Refactored some code in preparation for v3.5 release
  • Fix - fixed url encoding bug that affected accuracy of locations

3.4.1 - 2012-05-17

  • Feature - Proxy support on Mac
  • Tweak - Code readability and variable declaration
  • Fix - fixed curl url encoding bug on mac
  • Misc - Added MIT License notice

3.4 - 2012-05-12

  • Feature - Now works on Mac! (proxy support on mac coming in next version)
  • Tweak - Simpler proxy setup
  • Tweak - New instructions
  • Fix - Removed Create KML functionality

3.3 - 2012-03-28

  • Feature - Added macro to clear all data entry fields
  • Feature - Added Geocode Not Found macro to only retry not found locations
  • Feature - Added Google Maps link generation
  • Feature - Added Proxy traversal
  • Feature - Ability to geocode place names (ex: "The White House") or ZIP codes via free-form location format
  • Feature - Ability to geocode international locations
  • Tweak - Modified Geocode Selected Row macro to clear lat data, enabling it to run again
  • Tweak - Modified Geocode All macro to clear entered data
  • Tweak - Removed Google Earth auto-start on export

3.2 - 2012-03-27

  • Tweak - Removed juice analytics logo and misc. extraneous code
  • Tweak - Removed beep on geocode
  • Tweak - Removed geocoder.us
  • Fix - Changed Yahoo API to Placefinder API
  • Fix - Removed mClipboard module to make compatible with 64bit systems
  • Fork - Initial fork (http://www.juiceanalytics.com/writing/excel-geocoding-tool-v2/)

Want to contribute?

  1. Fork this repository
  2. Make your changes to the worksheets / modules
  3. Export any modules changed / added
  4. Commit and send a pull request

Contributors: maxrice,juiceinc,switchman2210