How to Write a Bill of Materials List in Excel. ... To save the file as a template, select "Excel Template" in the Save as Type list. Enter a name for the template and click "Save." ...