As a public service announcement (since I had to search for instructions), the BOM template saves as a .zip file. If you ignore that fact and open the file via Excel “file open”, it WILL actually become a workable spreadsheet versus a bunch of .xml gibberish.
Probably obvious to many others, but not obvious to me and I would assume others as well.