I have 14 static web pages with large HTML tables on each page that need to be updated by hand frequently (during peak times, this could be multiple times per day, but on average it's more like twice per week).
Currently, I have the data stored in an Excel spreadsheet and I've written some monstrous expressions that generate the HTML code for me. I then take the html files and upload them via FTP to a web server.
However, this is extremely inflexible and makes structural changes to the table (i.e. adding a new column) very time-consuming.
The purpose of these web pages is to display the data set in a simple, clean format to non-technical users. My current end product has had very good reception from users but is very time-consuming to update.
Currently, these pages would only be updated by me or a person in my position (with at least functional knowledge of HTML/CSS/JS & FTP). I think a WYSIWYG that allowed me to edit the table in the preview mode would do the trick.
However, from my understanding, I would need so set up some sort of web form with an embedded WYSIWYG editor to update my pages. I'd rather not build this from scratch if I don't have to, but would prefer not to install large content management systems (like WordPress)
What (preferably lightweight) software can I use to easily update these tables?