Open a BOM .xlsx to begin.
Column B = designators (e.g. C1,C2,C5) · Column D = part number (e.g. C59382).
C1,C2,C5
C59382