1
Upload Excel File
3 sheets: Sheet1=BOM (A–T), Sheet2=XY Placement, Sheet3=API Keys (B1/B2/B3)
Drag & drop or click to browse
.xlsx / .xls — original A–H formatting fully preserved on download
Sheet1 — BOM (A–H inputs)
- A: SL.NO B: MPN
- C: Manufacturer
- D: Comment E: Description
- F: Designator (comma-sep)
- G: Footprint H: Quantity
Sheet2 — XY Placement
- A: Ref (e.g. C4, R1)
- B: Val C: Package
- D: PosX E: PosY F: Rot
- G: Side ("Top"/"top panel"/etc.)
Sheet3 — API Keys (col B)
- B1 → DigiKey Client ID
- B2 → DigiKey Client Secret
- B3 → Mouser API Key
Output Columns I–T (all preserve A–H; F & H adjusted on panel splits)
I Source Part Number ★ green/red
J Source description ★ green/red
K Source MFR ★ green/red
L Source foot print
M Source name
N Source Link (=HYPERLINK)
O Datasheet Link (=HYPERLINK)
P Panel Side
Q Component type (5-pass)
R Match in % (gradient)
S Result (PASS/FAIL)
T Remark ← NEW
2
Google Apps Script URL
Deploy Code.gs → Web App → paste /exec URL below
Execute as: Me | Access: Anyone | ⚠ Always create a NEW version after code changes.
3
Test API Connections
DigiKey OAuth2 + Mouser SearchByPartRequest — test MPN: LM358N
Upload file & paste URL to enable
Sheet3 values read (B1/B2/B3)
Validating credentials…
○ DigiKey
Not tested yet
○ Mouser
Not tested yet
4
Run BOM Scrubbing
Fills I–T · Per-column I/J/K highlights · 5-pass SMT/THT · Panel split + qty adjust · Gradient R · Remark T · Formatting persistent
Upload file & paste URL to enable
Uploading BOM data…
Parsing BOM + XY placement
DigiKey & Mouser API lookups
5-pass SMT/THT + weighted scores
Per-column highlights + panel split
✓
Results
I/J/K ≥70% match
I/J/K <70% match
R ≥90%
R 67–89%
R 34–66%
R <34%
SMT
THT