How create Raw materials type from spreadsheet?

I want to import BOM table through EXCEL, but I found that if it is defined as raw material type, it cannot be imported. How can I solve this problem