One of the most common map visualizations is to show a collection of features and an associated numeric value, for example annual rainfall or income levels in different places. Color-coding each feature based on its value is often the easiest way to visualize the data. But how to assign colors …

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 …

San Francisco recently saw direct service begin to Singapore on United and soon on┬áSingapore Airlines, bringing back service from North America to Singapore and creating one of the world’s longest flights. We wanted to see how this route measures up to others from SFO in terms of distance, so we …

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 …