{"id":2381,"date":"2016-09-24T22:59:39","date_gmt":"2016-09-24T22:59:39","guid":{"rendered":"https:\/\/grindgis.com\/?p=2381"},"modified":"2018-04-05T14:30:02","modified_gmt":"2018-04-05T14:30:02","slug":"geocoding-excel-and-bing","status":"publish","type":"post","link":"https:\/\/grindgis.com\/?p=2381","title":{"rendered":"Geocoding with Microsoft Excel and Bing Maps API"},"content":{"rendered":"

I wrote a tutorial about how to do geocoding with Microsoft Excel and Google Maps but saw few comments about the limitation which is 2500 addresses. Surfing the internet I found interesting number from Bing maps which allows you to\u00a0perform 10000 addresses in total. If you need more than that then create a new MSN or Hotmail account and get the new Bing map API key.
\n<\/span><\/p>\n

So somebody has \u00a0already created a excel template with all the required coding, you just have to create a Bing map API key.
\n<\/span><\/p>\n

 <\/p>\n

1.\u00a0<\/strong><\/span>Download the excel<\/a> sheet or go to the http:\/\/excelgeocodingtool.com\/<\/a> and download it.
\n<\/span><\/span><\/p>\n

2.\u00a0<\/strong><\/span>Open the downloaded excel file and if it is open in protected view (highlight yellow bar on the top) then click enable editing.
\n<\/span><\/span><\/p>\n

3.\u00a0<\/strong><\/span>After that process, enable macros.
\n<\/span><\/span><\/p>\n

4.\u00a0<\/strong><\/span>In Excel 2013: Go to File<\/strong> -> Options<\/strong> -> on the left side, choose Trust Center<\/strong> -> click on Trust Center Settings <\/strong>and Macro Settings<\/strong>
\n<\/span><\/span><\/p>\n

5.\u00a0<\/strong><\/span>In Excel 2007, 2010: Click on the Office button<\/strong> -> Excel Options<\/strong> -> Trust Center<\/strong> -> Trust Center Settings<\/strong>-> Macro Settings<\/strong>.
\n<\/span><\/span><\/p>\n

6.\u00a0<\/strong><\/span>Then check the Enable all macros<\/strong>
\n<\/span><\/span><\/p>\n

Note: Make sure to disable macros once geocoding process is completed for the security purpose.<\/span><\/p>\n

 <\/p>\n

Below image is from Microsoft Excel 2013<\/em>
\n<\/span><\/p>\n


\n<\/span><\/p>\n

7.\u00a0<\/strong><\/span>To process the geocoding you have to generate Bing API key, go to Bing Maps API key<\/a>. This will take you to login page, you can use your Hotmail or MSN account to login in. Once the initial process is completed you are ready to generate the key. To generate the key click on My account<\/strong> and then\u00a0on My keys.<\/strong>
\n<\/span><\/span><\/p>\n


\n<\/span><\/p>\n

8.\u00a0<\/strong><\/span>Then fill the value according to the nature of your project or anything that you like to fill up. Then click on Create <\/strong>button, which will take a while to display the key, see below image.
\n<\/span><\/span><\/p>\n


\n<\/span><\/p>\n


\n<\/span><\/p>\n

9.\u00a0<\/strong><\/span>Go back to your open Geocoding Excel template and paste the generated code into the text box of Bings Map API.
\n<\/span><\/span><\/p>\n


\n<\/span><\/p>\n

10.\u00a0<\/strong><\/span>Then go to Geocode sheet, add all your addresses under the Location <\/strong>column and press the Geocode Selected rows<\/strong> or Geocode all rows <\/strong>button. This will generate Latitude, Longitude and other info.
\n<\/span><\/span><\/p>\n


\n<\/span><\/p>\n

As mentioned above, you can create new MSN\u00a0account to generate new API key when your 10000 limit is over. Hope you liked the tutorial and also, if you have any question please comment.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

I wrote a tutorial about how to do geocoding with Microsoft Excel and Google Maps but saw few comments about the limitation which is 2500 addresses. Surfing the internet I found interesting number from Bing maps which allows you to\u00a0perform 10000 addresses in total. If you need more than that then create a new MSN […]<\/p>\n","protected":false},"author":1,"featured_media":2389,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[418,417,45,419,382],"class_list":["post-2381","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","tag-bing-api-and-excel","tag-bing-maps","tag-excel","tag-excel-and-geocoding","tag-geocoding","entry","has-media"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/posts\/2381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2381"}],"version-history":[{"count":0,"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/posts\/2381\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/media\/2389"}],"wp:attachment":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}