how to maintain lists (of UUIDs for indicators, bg DBs etc.) in ASCII form and generate human-friendly representations

[okworx]

We want to maintain the lists of identifiers etc. in a git-friendly easy diffable fashion, while at the same time use them to generate HTML on GitHub Pages and XLS for download and developer package.

Probably CSV would be the preferred candidate as source format for tabular data, as it is easily editable and convertable.

[okworx]

ssconvert could be an interesting candidate to merge multiple CSVs (one per sheet) into a single XLSX: https://manpages.ubuntu.com/manpages/noble/en/man1/ssconvert.1.html

A pandoc filter is available for transforming CSV to MD: https://github.com/ickc/pantable

The tabular documents we want to convert to CSV (one CSV per worksheet, these will live in the git repo) are:

• BackgroundDB_SourceDatasets.xlsx (latest version v1.11, ignore first sheet with explanations)
• EN15804_indicators_with_A2.xlsx

[okworx]

bonus points: auto-adjust column widths in the generated XLSX to the size of the cell contents