Importing .CSV tables (or any other format) into a web document.

Question

I'm administering a site with many frequently changing tables. This is done with some Adobe web software, which is outdated, bulky, restricting and not usable for typists.

Using here described methods like typing <TR/TD> into text editors is obviously impossible.

My question is, what is the year 2024 way to this task. (I'm not asking for a how-to, just opinions from people who do such things.)
Thanks

Answer 1

Yes, you are correct, hardcoding html elements when you have dynamic content, is not feasible.
You can read, process, and display csv data even with pure javascript, but there are also ready-made libraries to do that.

For example, "Lit" is a framework to display custom web components according to predefined logic but customizable styles.
https://coryrylan.com/blog/creating-dynamic-tables-in-lit

Technically CSV is not a database, just a data carrier format. The "usual" way to integrate dynamic data into a website, is using an actual database (relational or NOSQL) with a back-end, that communicates with the frontend code through web APIs. Web frameworks are specifically designed to build such systems.

Answer 2

Thank you very much for your quick replies.
I'll have a look at it and see if it's a way for us to go.