How to update multiple dynamic component attributes from a database or file

Hello all, I’m trying to better understand if it is possible to update multiple dynamic components and multiple of their attributes/ options from a data file? What file type would be able to do so? Are there extensions that help with this?

Example I have 100 boxes each it’s own unique dynamic component. I want to load or pull a data file where box 1 is green, 2 red, 3 blue etc…but also updating the associated information to be displayed for each component. Box 1 = Green and qty in box 1 = 12