【Document Standard】BOM (Bill of Materials) file format description
Bill of Material: A general list of all the parts/materials needed to manufacture a product.
File format:
It is recommended to use files in the format ".csv" extension. Supported File Formats: 1> extension is ".csv" 2> extension is ".xls" 3> extension is ".xlsx"
File style source:
It is recommended to use the closest Altium Designer default output BOM format, although the style is ugly, but the most compatible. Or look at the maps in this standard
Format Conversion:
The entire range of Excel software (such as Microsoft's Excel 2003, 2007) can be exported with the extension ". CSV" format. Any text editor can be edited and created.
Field (column, header, column name, header) order and fields that must be included in the file (column name):
1: Comment, 2: Description 3: Designer, 4: Footprint, 5: LibRef, 6: Pins, 7: Quantity, 8: Number
Field (column) description:
1: Comment is used to express the model, specification, error, etc. of the device. For example, "100nF 80%-20% 50V"
2: Description is used to express the name of the device, etc. Such as chip resistors, chip thermistors
3: Designator is used to express the "designator" corresponding to the device and the drawing. For example, R201, R20, C100, U1 Note: Designators are not case-sensitive, here all letters will be converted to uppercase, and then make associations with the coordinate file If you do use case to distinguish different types, please be sure to modify it. 4: Footprint is used to represent the device package. For example, 0402, 0805, SSOP-8
5: LibRef is not required
6: Pins are used to describe the number of pads used to represent the device. If the number of pads of the SOT-23-3 triode is "3", fill in 3
7: Quantity.
8: Number (optional) Accurate search, engineers must fill in the BOM after the purchase order, and use the number as a distinction. Note: If the component number does not correspond to the package description, the number shall prevail.
* These fields (columns) are very important: Comment Designer Footprint Number (optional)
If you want to use a self-organized list, be sure to check it out here
Important Notes: // Very Important, Very Important, Very Important, Very ImportantNote(1) Designator 1> Splitting (Column) Expression between Designator and Designator Only supports: Way 1<English Comma","> Way 2<Space" "> Other symbols are not supported. Unsupported symbols such as: ; \ | 。 ' : ~ > Examples of designators R1, R2, R23, R231, R0090
2> The use of interval expressions is allowed: the interval expression keyword is the English minus sign "-", and everything else is not supported. Symbols are not supported, such as: ~ > Interval expressions only support styles Alphanumeric - Number The start digit must be less than the ending digit. For example, R11-99, interval expression method example: R1-4 is equal to R1, R2, R3, R4
3> A single designator cannot exceed 64 characters in length 4> Chinese designator is not supported for the time being> Characters cannot be contained in the designator: @ # $ % ^ & { } [ ]
If you use AD, 99SE, PADS and other software to export, the above rules must be supported.
Note (2) Unpasted or non-welded position expression The non-glued position cannot appear in the bill of materials, for example, if R10 is not welded, then R10 cannot appear in the bill of materials. Note (3) Remarks are not supported in the bill of materials. Any form of remarks will not be shown to the factory, and process engineering will ignore all remarks. All notes in the bill of materials will be ignored
Note (4) When expressing by numbering
If the component number does not correspond to the package description, the number shall prevail. Whatever character you fill in the package or specification, the component number will prevail
Note (5) Custom formatting, (internal company style)
Although IT writes search algorithms, it does not mean that it can be accurately identified. It does not mean that you can ignore the above Note 1,2,3,4 .
