I've made a generic converter .xlsx to .csv.
There is a README in the js-xlsx branch, but essentially, with minimal javascript skills you can choose a sheet from a multisheet file and it will read a file, which may have multiple rows/ columns of headers, merge the columns of headings, strip the metadata and blank lines and output to CSV.
We need to, in bulk, run it over all the ONS & .gov.uk datasets.
I've made a generic converter .xlsx to .csv. There is a README in the js-xlsx branch, but essentially, with minimal javascript skills you can choose a sheet from a multisheet file and it will read a file, which may have multiple rows/ columns of headers, merge the columns of headings, strip the metadata and blank lines and output to CSV.
We need to, in bulk, run it over all the ONS & .gov.uk datasets.