Opening Item BOMs in Excel You can open an item BOM in Microsoft Excel. On the Bill of Materials tab, click Open As CSV File . You can edit the data in Excel, but you cannot import data back into the item. Parent topicBills of Materials Item BOMs Named BOMs Comparing BOMs Searching Item BOMs Sorting BOMs