Introduction
For some years I've used Google Sheets to create data tables. I've created
quite a few specifically for my blog posts. It's really easy: any tab can be
published as a web page and it comes with a unique URL for use in HTML
hyperlinks.
I like using them because Sheets can both organise and maintain the data and,
once linked to a blog post, everything else is automatic. They are
particularly useful displaying tables that are too wide for a standard blog
post (600 pixels in my case).
They have one drawback: searching is a bit clumsy. Readers need to know that
Ctrl+F will find what they are looking for on most browsers. Even so it's not
ideal not least because you can't filter the table.
Enter AI
Last week I did a lot of work
indexing the illustrations in the WRG books
resulting in a spreadsheet containing 1,322 rows. This was far to long to use
without a search or filtering mechanism.
After a bit of research, I found that it's possible to display CSV
(comma-separated values) files on web pages without a background database: an
ideal solution for Blogger which doesn't offer (or allow) this functionality.
All I needed was a code widget I could paste into Blogger as Google Sheets can
export any tab as a CSV file..