After devising custom sorting and a translation script, atamerge was used to import the spreadsheet into InDesign. If the parameter field is empty, in InDesign it shows up as end of paragraph symbol, which leaves undesired spaces.

Not every item in the database shares the same parameters. Some items might have information missing or unknown.

There is also no specific unit per parameter and descriptions can have inconsistent style.

I used InDesign’s GREP expressions and a script to execute 24 queries, which transform the parameters into a finished datasheet.

Explaining the process in more detail can also be found in a presentation I made for my team. It was created to share my gathered knowledge and show that it really can be easy to understand.