I'm not sure which section is the best place to post this question, as I'm not sure how to do it.

For a given project (assembly) we have a "master" spreadsheet, that will have all the filenames of all the parts, and all the important information about that part, including information that will end up being in the drawing bom, but also many more columns of information associated with that part (like outsourcing vendor information), important dates, etc.

My question is I would like my master spreadsheet to be the master for all the custom properties in a part.  If a part has a custom property, I want that property to be a column in my master spreadsheet.  Then if I update a column in my master spreadsheet, for then to have some way of updating the custom property in the part.

Ideally, I would like it to be two way, that is if I update the spreadsheet, it will update the custom property of the part.  Or if I update the custom property of the part, it will update the master spreadsheet.

We do not currently use PDM, so I don't know if that is a feature of that.  Does anyone know how I can implement this?

Thanks.  We are currently using version 2017.