Supplier API Configuration


Usage Instructions

Digikey Setup:

1. Get your API credentials from Digikey Developer Portal

2. Enter your Client ID and Client Secret above

3. Authorization happens automatically when needed

Mouser Setup:

1. Get your API key from Mouser API Hub

2. Enter your API key above

LCSC Setup:

1. Apply for API access by contacting support@lcsc.com

2. Enter your API Key and API Secret above

3. LCSC provides pricing in USD and part availability

Usage in Word:

1. Configure at least one API above and click "Save Credentials"

2. Select a part number in your Word document and use:

  • Right-click → "Quick Lookup" from context menu

  • "Quick Lookup" button from the ribbon

3. The add-in will search all configured suppliers and display results

Usage in Excel:

1. Configure at least one supplier above and click "Save Credentials"

2. Create columns with headers:

  • "Comment" - for part numbers to look up

  • "Supplier Part Number 1" and "Supplier 1" - for Digikey results

  • "Supplier Part Number 2" and "Supplier 2" - for Mouser results

  • "Supplier Part Number 3" and "Supplier 3" - for LCSC results (Excel only)

  • "Supplier Link 1/2/3" - a separate Link column for each supplier part-number column

Part numbers are stored as plain text. Product URLs appear as "Link" in the separate columns.

3. Enter part numbers in the "Comment" column

4. Process rows individually or in bulk:

  Single Row: Click on any cell in the row and use:

  • Right-click → "Quick Lookup Excel" from context menu

  • "Quick Lookup Excel" button from the ribbon

  • "Manual Lookup" button in this settings pane

  Entire Sheet: Use "Process Entire Sheet" button to look up all rows at once

5. The add-in will populate supplier part numbers and names from all configured suppliers