3
3 Comments

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?

on January 29, 2020
  1. 2

    100% a problem, solutions already exist, but I haven't seen just a csv to html.

    https://www.sheet2site.com/

  2. 1

    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.

  3. 1

    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.