CSV to custom HTML template
Hi everyone,
I solved a real-life problem for my wife a few weeks ago, and I'm wondering if it could potentially be a good project idea.
Here's the gist: my wife was having to update her company's website with the results of a database-generated report. She doesn't know HTML, but was repeatedly having to write the same HTML snippet and change the value to correspond with each row of the CSV report.
Being a developer, I noticed an opportunity for automation and wrote a Node script that takes in the CSV and gives back the appropriately formatted HTML. All I have to do is email her the HTML file and she can copy-paste the contents into her site.
Here's the question: can you imagine other people for whom this would be useful? Would being able to write custom HTML templates from a CSV make a good product?
100% a problem, solutions already exist, but I haven't seen just a csv to html.
https://www.sheet2site.com/
Hi Peter,
You may want to look at my CSV to HTML converter at https://www.convertcsv.com/csv-to-html.htm . It has a scripting section too. By default the converter creates an HTML table.
I've experienced it from an aspect of newsletter creation, which then gets copied over to a website. We would especially have bullet points and links to publish. Along the way junk tags/html gets copied over, messes up with formatting. I delegated that task long ago, so would need to remind myself where the formatting issues come in. But cleaning up the code/html has been a pain.
Google Sheet to clean html template could be nice.