For clarity, the spreadsheet in question is a repertoire list of all the songs that my cover band performs, with hyperlinks to lyrics and chords. I can sort it just fine in Excel, but not when it's exported to HTML.
I have started exporting it as HTML as that is slightly more accessible when live on stage. However, it would be beneficial to be able to sort the list by different attributes like genre, artist, year, etc.
As far as I can tell, there is no way for me to sort the data in the HTML table directly. In order to re-sort the data, I have to open Excel, sort the table, and re-save / re-publish it as a webpage.
I tried this extension called Tabulazer but it didn't seem to work.
As I'm only an amateur programmer, I'm not sure how I would go about solving this problem. I would guess it probably has something to do with the thead
table header tag.