One Cool Trick with Google Spreadsheets

May 09, 2019

Yesterday I was looking for an easy way to take a bunch of data and geocode it. In the past I used to either write a basic Ruby script to manipulate a CSV (which is not hard but more tedious than my late afternoon brain enjoys). I remembered I used to use Google Fusion tables to do this sort of thing and after some searching I learned you can now write Javascript functions for your Google spreadsheet. Now instead of writing a full script I could write a four line function that accepted the address from another cell as an argument and return a latitude or longitude. I can imagine this feature being not only useful for me, but my colleagues as well.

comments powered by Disqus
This work by Matt Zagaja is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.