For reasons known only to itself, Google broke Trivially’s Custom Trivia Pack feature when it started rolling out the latest version of its Google Spreadsheet service.
In previous versions of Google Spreadsheet, you saw these options when you “published” your spreadsheet (as outlined here):
In particular, note the options under “Get a link to the published data”… Google offers options to publish the data as an HTML page, a CSV file, or in other formats.
As Google rolls out the latest version of Spreadsheets, this is what you might see instead:
We’re working on a fix for this, but in the meantime, here are some workarounds for this problem:
- Make a copy of an existing spreadsheet and modify it for your Custom Trivia Pack
- Click on this link to create a new spreadsheet in the old format: http://g.co/oldsheets. This is an undocumented capability that Google provides, perhaps to assuage their guilt at breaking Trivially. Note that you’ll need to be signed into your Google account to make this work.
We apology for any inconvenience this has caused. We wish Google had (i) announced their intention to drop this much-used capability and (ii) provided a new way to accomplish the same result. So far, Google has not acknowledged that they removed this capability and have not documented any workaround. It’s been crickets.