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.

Want to get posts like this in your email?

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