Bill of material creation and use

I created a bill of material in excel to use in Solidworks. I know how to install it in my drawing. How can I make it work for me? How can I have it to whereas when I do an auto balloon my items will list in the correct location? I have attached the bom I created.

SolidworksBill Of Materials