How to: create a bubble chart from a Google Spreadsheet using D3.js

Posted on October 10, 2014 by Scott Wilson

Earlier in this series I discussed how to get data out of a Google Spreadsheet in JSON format using an API call, and how to convert the JSON data into an array. Now I’m going to talk about how to … Continue reading →

Posted in Data modelling and migration | 1 Comment

How to: convert Google Spreadsheet JSON data into a simple two-dimensional array

Posted on October 9, 2014 by Scott Wilson

In a previous post I explained how to extract JSON data from a Google Spreadsheet via an API call. However, when you actually get the data, the JSON isn’t really in the kind of structure you would imagine. Instead of … Continue reading →

Posted in Data modelling and migration | Comments Off on How to: convert Google Spreadsheet JSON data into a simple two-dimensional array

How to: get data out of a Google spreadsheet using JSONP

Posted on October 8, 2014 by Scott Wilson

Google Drive spreadsheets are a great way to collect data using their handy forms, but the visualisation tools sometimes aren’t sufficient. What if you wanted to do a visualisation using d3.js for example? Google has an API for obtaining the … Continue reading →

Posted in Data modelling and migration | 10 Comments