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 Related concepts Item BOMs Named BOMs Related tasks Comparing BOMs Searching Item BOMs Sorting BOMs