Organize manufacturer, part number, quantity, approved alternates, target date, and sourcing notes before sending your BOM for quote.
Microsoft Excel format · 11 sourcing fields · No account required
The template keeps the requested part, quantity, timing, approved alternates, and documentation requirements on the same line. It does not represent availability or guarantee that every line can be sourced.
Explore SongGlow BOM sourcing →These are the exact columns included in the downloadable SongGlow Excel template.
| Template column | What to enter | Why it matters |
|---|---|---|
| DESCRIPTION | A short, recognizable description of the component or hardware item. | Helps identify incomplete or mismatched part-number information. |
| DESIGNATOR (OPTIONAL) | Reference designators such as C12, R8, U3, or J1. | Connects the purchasing line to the schematic or assembly. |
| MANUFACTURER | The requested or approved original component manufacturer. | Separates the manufacturer from a distributor or internal vendor name. |
| PART NUMBER | The complete manufacturer part number, including suffixes. | The most important identifier for an accurate supplier search. |
| QTY | The quantity required for this sourcing request. | Allows suppliers to quote the correct price break and order quantity. |
| ALTERNATE MANUFACTURER 1 | A first manufacturer already approved by your engineering team. | Makes the approved sourcing scope clear without silent substitution. |
| ALTERNATE PART NUMBER 1 | The approved part number from Alternate Manufacturer 1. | Keeps an approved alternate paired with the correct manufacturer. |
| ALTERNATE MANUFACTURER 2 | A second approved manufacturer, if one exists. | Adds another permitted sourcing route for the same BOM line. |
| ALTERNATE PART NUMBER 2 | The approved part number from Alternate Manufacturer 2. | Prevents an alternate manufacturer from being listed without its exact part. |
| TARGET DATE | The date the parts are needed, preferably in YYYY-MM-DD format. | Helps compare quoted lead time against the production requirement. |
| NOTES | Packaging, date-code, documentation, or other line-specific requirements. | Keeps sourcing constraints visible before a quotation is approved. |
Clear inputs reduce clarification rounds and help potential sources quote the same requirement.
Yes. The Excel template is free to download and can be edited for your own electronic component or hardware sourcing request.
No. You may send your existing Excel, CSV, PDF, or ERP export. The template is simply a clear starting point when your current file does not organize manufacturer, part number, quantity, alternates, target date, and notes consistently.
Add the requirement in the NOTES column for the relevant line. State the channel, certificate, lot, date-code, packaging, or photo requirement as specifically as possible. SongGlow will ask potential sources and confirm what is available for the quotation; documentation is not guaranteed for every supplier or part.
No. A complete BOM makes the search and comparison more accurate, but some parts may be obsolete, constrained, incorrectly identified, or unavailable in the requested quantity and timing. SongGlow reports suitable quote options and open questions line by line.
Attach the Excel file with quantities, target dates, and any documentation requirements. We will review it line by line and confirm the next steps.