Home / Resources / BOM template
BOM template for component quotes
The column layout we quote from, as a CSV you can fill in. Your own BOM format is also accepted; the template is for lists built from scratch.
The template columns
Fabrikant
Ja
The maker of the part as on your AVL
Volledig MPN
Ja
The complete ordering code with suffix. Format the column as text so spreadsheets do not change it
Required Quantity
Ja
Total quantity for the order, including any attrition you want
Packaging Preference
Optional
Reel, cut tape, tray or tube
Target Date
Optional
When the parts must arrive
Alternatieven
Optional
“Approved” with the alternative MPNs, “Discuss first” or “None”
Notities
Optional
Date code limit, DNP, customer-supplied, documents needed
The example row in the file is fictional. Replace it before you send the BOM.
Avoid the common BOM problems
Spreadsheets change part numbers
Codes with leading zeros or an E can turn into numbers or dates. Import the MPN column as text.
DNP lines get quoted
Mark lines that are not fitted as DNP, or remove them, so they stay out of the quote.
Family names cannot be quoted
"STM32F103" is a family. Send the full code, for example STM32F103VGT6.
BOM template questions
Do I have to use the template?
No. Send your BOM in your own format; we map the columns.
Which file types are accepted?
Excel (.xlsx, .xls) and CSV. You can also paste lines into the RFQ form.
Can I add reference designators?
Yes. Add a column for them; they are used to label the kit and check DNP lines.
Related: BOM sourcing & kitting · BOM uploaden · Veelgestelde vragen