Get API Results Into A Google Spreadsheet By Pasting The Following Into A Cell
13 Mar 2015
My API hero of the day is Alan deLevie (@adelevie) over at 18F. I was tweeting out my story "Going Beyond Excel As A Data Source For API Deployment And Focusing On It As An API Client” today, and he tweeted me back his slick usage of the ImportXML function to get Federal Communication Commission (FCC) Electronic Comment Filing System data into a Google Spreadsheet.
When you visit ecfa.link, and scroll to the bottom of the page you will see simple instructions on how to get the data into your Google Spreadsheet:
This is what we need more of, something that should be default for all data APIs. There are some other RSS, JSON, and XML goodies on the page too, but that is another story. Providing a simple copy / paste option for taking API driven data and making available in Google Spreadsheets is what I'd consider fundamental building block, getting us towards what I talk about in my post. Spreadsheet users need a wealth of simple, copy and paste resources like this that they can tap, from both public, and private data sources.
You rock Alan! I think his approach to providing a copy / paste ImportXML standard should be standard for all data APIs. We can start simple, by building a library of simple data sources like cities, states, postal codes, but then graduate up to more advanced data sources, or even subscriptions to valuable, curated, premium data--the trick is going to be keeping it as dead simple as Alan made it.
I will have to think about adding the ImportXML copy / paste as a standard building block, along with RSS, XML, and JSON. It feeds nicely into my wider spreadsheet and API research nicely. Thanks Alan for this story, keep up good work!