I understand that this Frictionless Data is about helping people consume data easily, but I don’t see that you are looking to integrate with spreadsheets, so feel free to suggest another forum for this post.
I’m trying to understand how can one consume public Open Data from inside a spreadsheet application, without navigating to a portal and downloading a CSV using the browser. Because I imagine that there might be some users that would use more Open Data if it’s right there inside the tool they already use.
So my first approach was to check if the spreasheet apps had any way of consuming online information, which they did, but I was not able to use them.
To be more precise, here’s how Excel declares to have support for OData stanard:
It seems like the OData protocol is a standard set of APIs so that any app can consume data from any portal. There’s even a CKAN extension for it: http://extensions.ckan.org/extension/odata/
And there’s a recent fork that improves it.
I searched this forum for mentions of OData but there’s none, so I’m guessing there’s something wrong with it, isn’t there?
About LibreOffice, they also claim to have support for something called WebQuery, but I can’t follow this wiki’s instruction in my LibreOffice 5 installation, maybe it’s changed.
So, tu summarize: I think consuming data and browsing data catalogs from inside spreadsheet applications could be a great way to improve data usability, but I can’t find any solution that currently works.
If you know about any, please let me know.