Custom property and excel data

Hello

I would like to have an excel file of reference for my 3D, thanks to power query I can easily have a kind of up-to-date database.

All I need now is to be able to autofill the other columns, probably thanks to custom properties.

I don't have access to MyCAD or access to the API manager documents.

I suck at VBA, is there a simple solution to my request  ?