In my role as a Cornwall Online Parish Clerk (Genealogy), I do a fair bit of transcribing old records. These I like to place online - which has always been a bit of a pain in the rear.
Being a bit of a saddo, I like my webpages to comply with the W3C rules for web design - but this has always been a problem. Because my transcripts are done in a spreadsheet, any conversion to html ends up with unwanted tags in it - specifically SDVAL and SDNUM tags. Stripping those out is a real pain even using regex.
Because I upload these files to be incorporated into the OPC database, I create .csv files.
Until recently, I have never found a practical way to make those .csv files turn into html and, as we already know, as soon as you tun them into spreadsheets and convert to html, they fill up with crap SDVAL etc stuff.
But I discovered a rather super little command line tool to convert csv to html!
Oddly enough, it is called csv2html!
https://github.com/dbohdan/csv2html
Once you have had a couple of plays around with this tool, I guarantee you will be impressed if you need to convert csv to html files. It does exactly what it says - nothing more, nothing less.
Very useful
