At the OECD my team maintains many Excel webqueries to collect data from country web sites rather than the country using resources to package the data and send it. Each Excel webquery represent a separate dataflow (country+subject domain) and we have over 200 of these dataflows.
Excel webqueries offer a powerful interface and processing language on the results (VBA). However, this whole system is difficult to maintain because:
Does anyone have or know a suitable software alternative to Excel webqueries that solves at least some of these issues?
David Barraclough, OECD