In late September and early October, Hurricane Matthew caused devastation in the Caribbean, especially in Haiti, before continuing up the Florida coast. Using data from Weather Underground, we show how to map its trajectory and visualize its intensity and storm status. 1. Create a new spreadsheet with Geosheets enabled. Either …

The recent earthquake in central Italy that devastated the town of Amatrice got us thinking about other earthquakes in general and visualizing where else they’ve occurred recently. The US Geological Survey has among its great data sets an exportable list of recent earthquakes at https://earthquake.usgs.gov/earthquakes/. Handily, one of the formats they provide …

There’s been an explosion of open data made available by all levels government, but much of it is still in a pretty raw form and can be hard to manipulate and visualize. However, with the data import functions in Google Sheets and the mapping functions in Geosheets it’s possible to …