What is that hidden Geocoding sheet for?

posted Mar 1, 2014, 6:40 PM by Faustino Rodriguez   [ updated Mar 4, 2014, 10:09 AM ]
On each spreadsheet using the Mapping Sheets add-on, a new - hidden by default - sheet will be created with name Geocoding.

This is a system sheet acting as a cache repository for coordinates (latitude, longitude). This sheet will hold the coordinates for already used addresses / locations on each spreadsheet, so the add-on does not have to call the Google Geocoding service each time, what could result in exceeding your quota limits for this service.

You can show that sheet using the menu View > Hidden sheets (1) > Geocoding