The picture below shows an Excel sheet containing all the data for a BOM import. You can collect your data with any other tool that you want, but there must be an Excel or csv file for the import.
The order of the data concerning the columns you assign is freely selectable because you must map them later in Smart Materials anyway.
All columns of each row must be filled completely; for example, if you have several items of a BOM node, you must fill all columns of the node repeated for the appropriate item so that each row contains all the necessary information to import that item of that node. Additionally, you can leave columns free, which might be necessary when filling the Excel sheet or csv file automatically. You just have to account for it later when you map the columns in Smart Materials.
After gathering all the data, save the Excel sheet and choose CSV as the file format (*.csv). If you have already loaded into a csv file, then just save. Excel stores the data with semicolon separated columns.
You are allowed to use any character as a column separator, but keep in mind that if a character defined as a column separator occurs within a string, an error might arise while importing the csv file.