Skip to content

Instantly share code, notes, and snippets.

@snhobbs

snhobbs/README.md

Last active March 5, 2023 20:33
Show Gist options
  • Save snhobbs/969b84a1aa48b25ed7fc2294b181468f to your computer and use it in GitHub Desktop.
Save snhobbs/969b84a1aa48b25ed7fc2294b181468f to your computer and use it in GitHub Desktop.
Download ZIP
Expanding a JLCPCB BOM to a Full Design BOM
Raw
README.md

JLCPCB makes their internal part numbers the only reference available in BOM exports. The following is a workflow for taking a list of reference designators and LCSC part numbers and expanding it to a full design BOM.

  1. Export the JLCPCB BOM
  2. Use the LCSC BOM Tool to get the manufacturers part numbers
  3. Export the LCSC BOM to a new file
  4. Merge the JLCPCB and LCSC BOMs on the LCSC part number so the correct manufacturers part number is aligned with each reference designator.
  5. Use the BOM tools from Octopart, Digikey, or Mouser to generate a BOM with expanded fields with values, description lines, etc.

The EDA BOM can be merged into the merged JLCPCB & LCSC BOM to add notes, special fields etc. This should be merged on the reference designator. This makes checking of values much simpler as you can line everything up in a single document instead of crawling though webpages and databases for resistor characteristics.

Merging

Merging spreadsheets can be done using the spreadsheet_wrangler tool:

spreadsheet_wrangler.py merge --on 'LCSC Part Number' -p "{\"LCSC Part Number\": [\"JLCPCB Part #\"]}" -r LCSC_Bom_Exported_2023-02-22.csv -l jlcpcb.xls

Exported JLCPCB BOM

Comment Designator Footprint JLCPCB Part #
C327039 R22 R_0805_2012Metric C327039
C136891 R9 R_0805_2012Metric C136891
C150240 D5 SOT-23 C150240
C1634 C16 C_0603_1608Metric C1634
C28323 C15,C17,C9,C20,C8,C2,C23,C21 C_0805_2012Metric C28323

Exported LCSC BOM

Comment Schematic Reference Footprint LCSC Part Number Quoted Manufacturer Quoted LCSC Part Number Manufacturer Part Number Quantity Unit Price Order Price Quantity Available Min\Mult Order Qty RoHS Part Match Confidence
C327039 R22 R_0805_2012Metric C327039 YAGEO C327039 RT0805DRD07220RL 20 0.0233 0.47 0 20\20 yes 100%
C136891 R9 R_0805_2012Metric C136891 YAGEO C136891 RT0805FRE07750RL 50 0.0124 0.62 1850 50\50 yes 100%
C150240 D5 SOT-23 C150240 onsemi C150240 BAV99LT3G 20 0.0345 0.69 4740 20\20 yes 100%
C1634 C16 C_0603_1608Metric C1634 Samsung Electro-Mechanics C1634 CL10C100JB8NNNC 100 0.0058 0.58 389661 100\100 yes 100%
C28323 C15,C17,C9,C20,C8,C2,C23,C21 C_0805_2012Metric C28323 Samsung Electro-Mechanics C28323 CL21B105KBFNNNE 50 0.0088 0.44 3377955 50\50 yes 100%

Merged JLCPCB & LCSC

Comment Schematic Reference Footprint LCSC Part Number Quoted Manufacturer Quoted LCSC Part Number Manufacturer Part Number Quantity Unit Price Order Price Quantity Available Min\Mult Order Qty RoHS Part Match Confidence
C327039 R22 R_0805_2012Metric C327039 YAGEO C327039 RT0805DRD07220RL 20 0.0233 0.47 0 20\20 yes 100%
C136891 R9 R_0805_2012Metric C136891 YAGEO C136891 RT0805FRE07750RL 50 0.0124 0.62 1850 50\50 yes 100%
C150240 D5 SOT-23 C150240 onsemi C150240 BAV99LT3G 20 0.0345 0.69 4740 20\20 yes 100%
C1634 C16 C_0603_1608Metric C1634 Samsung Electro-Mechanics C1634 CL10C100JB8NNNC 100 0.0058 0.58 389661 100\100 yes 100%
C28323 C15,C17,C9,C20,C8,C2,C23,C21 C_0805_2012Metric C28323 Samsung Electro-Mechanics C28323 CL21B105KBFNNNE 50 0.0088 0.44 3377955 50\50 yes 100%

Octopart BOM Expanded

Query Qty Manufacturer MPN Octopart URL Part Description Description Schematic Reference Internal Part Number Lifecycle Lead Time RoHS Total Qty (@ Batch Size: 1) SKU SKU SKU SKU SKU Packaging Packaging Packaging Packaging Packaging Unit Price (@ Batch Size: 1) Unit Price (@ Batch Size: 1) Unit Price (@ Batch Size: 1) Unit Price (@ Batch Size: 1) Unit Price (@ Batch Size: 1) In Stock In Stock In Stock In Stock In Stock MOQ MOQ MOQ MOQ MOQ URL URL URL URL URL Distributor [Lowest Price (Selected)] SKU [Lowest Price (Selected)] Packaging [Lowest Price (Selected)] Unit Price (@ Batch Size: 1) [Lowest Price (Selected)] Line Total [Lowest Price (Selected)] Batch Total [Lowest Price (Selected)] In Stock [Lowest Price (Selected)] MOQ [Lowest Price (Selected)] URL [Lowest Price (Selected)] Notes
Digi-Key Mouser Newark Onlinecomponents.com RS Components Digi-Key Mouser Newark Onlinecomponents.com RS Components Digi-Key Mouser Newark Onlinecomponents.com RS Components Digi-Key Mouser Newark Onlinecomponents.com RS Components Digi-Key Mouser Newark Onlinecomponents.com RS Components Digi-Key Mouser Newark Onlinecomponents.com RS Components
RT0805DRD07220RL 20 Yageo RT0805DRD07220RL https://octopart.com/rt0805drd07220rl-yageo-1279675 High Precision-High Stability Chip Resistor Thin Film 0805 220Ohm 0.5% Paper T/R R_0805_2012Metric R22 C327039 22w Compliant 20 RT0805DRD07220RL-ND 603-RT0805DRD07220RL Tape & Reel Tape & Reel 0.19 0 4900 5000 1 https://octopart.com/opatz8j6/a1?t=0VIGXK0CgxSIwSdwcuDwOx2-XsOrInVMbKi4RtdvxmxmWvnuECN986xT9759U_HkMTeZbM9y_SMfrObhBw_AA-iPI_z4aUn7PvHFwA8LgDLy2K1LdzCByA66PLAPAikj_NsIvrNDMmb-IpTScKdd8_3Ka7posVFn9S9E2ux9WOijVvXOzv4uXxfqGOIsxoK2itPNx9XXr9wE-GWhSX7ElUHDzsj4LDxwEUoFQhhU4BBeLhnhd_uNWPNtVeMyCFG-jQ https://octopart.com/opatz8j6/a1?t=ABqQkVp0LniFN_PBYYlpmIey4zA63Gj-t_wq0sIRRmKDzCnytkZG_Z0_nXr4USZRW7dn_h1owIWibW0-22HpKx_Jnf70wwCQRb0uLEyOtX8TqN6iNrbJDCylJ7seTU-nLXn-22wL_0rapPWoy37MJ20Z91byksumgqjLIt9staD83hP8gzj_0ch6t75qVNHM98DPSM6WdoAy7DT9_WotNl-a2z9i0pbyci2iGxsbzRxlY3rOALl088uPs898Jf3QijbXmg Mouser 603-RT0805DRD07220RL Tape & Reel 0.19 3.8 3.8 4900 1 https://octopart.com/opatz8j6/a1?t=ABqQkVp0LniFN_PBYYlpmIey4zA63Gj-t_wq0sIRRmKDzCnytkZG_Z0_nXr4USZRW7dn_h1owIWibW0-22HpKx_Jnf70wwCQRb0uLEyOtX8TqN6iNrbJDCylJ7seTU-nLXn-22wL_0rapPWoy37MJ20Z91byksumgqjLIt9staD83hP8gzj_0ch6t75qVNHM98DPSM6WdoAy7DT9_WotNl-a2z9i0pbyci2iGxsbzRxlY3rOALl088uPs898Jf3QijbXmg
RT0805FRE07750RL 50 Yageo RT0805FRE07750RL https://octopart.com/rt0805fre07750rl-yageo-1233024 Res Thin Film 0805 750 Ohm 1% 0.125W(1/8W) ±50ppm/C Pad SMD T/R R_0805_2012Metric R9 C136891 22w Compliant 50 13-RT0805FRE07750RLCT-ND 603-RT0805FRE07750RL 46AK6039 Cut Tape Tape & Reel 0.084 0.081 0.048 21132 8670 0 1 1 10 https://octopart.com/opatz8j6/a1?t=kt-k-5Su0_xss23OEkiaj9Df4RstKU_GOU1v9LCj5jRbnRrN3L9AzjFtoocFKRYddYPm2ZaPRPsT_lb2Bw1y3eIy_w951RTv29EmpJJ3SAgQIBrM6ApT1Ju-Kug_YXcO1SXWfngZYThLtzxp9oiTeSODz89aiUp6NhK0nPRqyFU1zeLHB1YKsMWX2uVMOgzzaz8P0ZM6aUYmOdQ3M38QWEQp_lpemFTW0ezI4EmNgh7DJSkyMss6cQxQgtfpWQVPl1ig https://octopart.com/opatz8j6/a1?t=1gFzP5n0AkP2Jkq7HxdBe8K3NTWiPWt1VE1wGbbR5v086tcHX0jhDBpyoz3s0y4e7RsWHU8s_TB8SIr9XoCU6IqkwyhOj70sEMjq0bFXE85qc9CX1-zp_sMRIPAkZb0xuMiBOIHRjLLYe2ifYNWyJdgVYaLz5i3Z2dqaFy7wjKGdmnE3VCZdrlTOlVVw7aArHMjDgVQQTadGX9Qd78KkVXBKoTKeiEAnvWdMIlOymY1Krof2S9EYpbpA7oyQYDwtsimHkw https://octopart.com/opatz8j6/a1?t=TaVzyZmzDzFyfrUGky5gIuvKsFCDgTu5UFc4CglauUu7TBgrkfUa6Fgo5lJ6CbOV2sCT7WP9BtsW9Ad3ZK3qNsZTnAnVfoC6pSYpwYWB7sNSkk-b9ZTxxbQZBL3AWUdttEoIDFuBUDyJi9R2s9_ymkgnxlcDfIHB1vQJ7r_MOlFOF81pjfVSwKxExijNq_VgnHvwLIUcbZFzyAnAWAxVoZVKhXNTwfr3J7rqPMo-6Uzj1tpkbqXDuZFyoMba-JSMIkgf8A Newark 46AK6039 0.048 2.4 2.4 0 10 https://octopart.com/opatz8j6/a1?t=TaVzyZmzDzFyfrUGky5gIuvKsFCDgTu5UFc4CglauUu7TBgrkfUa6Fgo5lJ6CbOV2sCT7WP9BtsW9Ad3ZK3qNsZTnAnVfoC6pSYpwYWB7sNSkk-b9ZTxxbQZBL3AWUdttEoIDFuBUDyJi9R2s9_ymkgnxlcDfIHB1vQJ7r_MOlFOF81pjfVSwKxExijNq_VgnHvwLIUcbZFzyAnAWAxVoZVKhXNTwfr3J7rqPMo-6Uzj1tpkbqXDuZFyoMba-JSMIkgf8A
BAV99LT3G 20 onsemi BAV99LT3G https://octopart.com/bav99lt3g-onsemi-710544 Rectifier Diode Small Signal Switching 100V 0.215A 6ns 3-Pin SOT-23 T/R SOT-23 D5 C150240 Production (Last Updated: 2 years ago) 75w Compliant 20 BAV99LT3GOSDKR-ND 863-BAV99LT3G 10N9382 6900016 Custom Reel Tape & Reel 0.146 0.147 0.16 0 0 0 2150 1 1 1 25 https://octopart.com/opatz8j6/a1?t=Ec1eSC81FJcbMC9TsAu91SdsSQiVOrT_r5mXwkKSz_8R4AjDbnYWQqX4n_ruwoZCzhwWqxSaBFBMy1JSggNMAQlHId8u_-WhaIXBC9ptOyNvlutqYvDZ2Tke_GOPYAeND5yqi9u8j-a5SGfYiVJUaJ1V3qvjtRwfmsnBv-uBSizu_qaOCjNeOhEzGs47pIeUvW9Q2Rul6yXvJ3rDDibPRaTTZ1TLR_zyOOXZZsN6UUQ0enOZSJIBXlXoXmLlVDYNHA https://octopart.com/opatz8j6/a1?t=sJyPD54n-JIBqlGy6ln83G6Glo0S3hRkMp-7ScnrUYzQKzUIck7scQTqnCi_RkU3YNrGFamyTqW-K-2NAoerWD1QVUxy06iybAmdfpcDS_dUEQZfMJAZsK0AqUoFouaJ2lTlfZaDR98bTw6EFhr38IVLkJYdZf4kuXhf4kzwyrwQB-MhWUdxYa4GEqSEEd8jt8jaEtOIxoclUd2FHq6zzRpx7cANPI4eN6xtBPnJQuYekviOs1m6L9CTImWppDWW6BqG https://octopart.com/opatz8j6/a1?t=77UyG4M-Msd32McEZtfIaStgT4q8qrxHwH_TH7gP5MelnAbq1Gjty-qmn7Z1WYX3EX6nB3V4z6yqoKMXfZgFC3oERHnJTznlfjhx40qi68GWx4BUpq27bWtCI89yRfp18hksBVq74BAKz5M6191bEN4hqFC9U_uaJou3VRS76s9kpwkbCMfYTM6qduxXf41BPnZwWiArU2LqYF5rrB-MDrFRHULcAkcr47P7vCcoYfoM3MkJddK9xZ-G9mOHp8ChIpk https://octopart.com/opatz8j6/a1?t=RvXOBpWk1oEW-3VFkrUzQPXeE667_FZVt0bqKmtZAnkeKsPtt1QU51TcHRFeeqGanfnlnxd6RXebhL8DhkLXW76O_qsVT56kiNxpIExx4m2UsrDA9KtNgUmD0adnWMnxbx0OyVRusHXvcWPSRyjW3TawkOp4QgkTHjM6BlnIzWelorKWQ608b70IqbhjoTuHUNd6_t3K2RcrM7f0TZ--oHz0hYWplG-w_JI_IPSweToV5ijuoQncPMSZEjR88-KqW0xlKQ Digi-Key BAV99LT3GOSDKR-ND Custom Reel 0.146 2.92 2.92 0 1 https://octopart.com/opatz8j6/a1?t=Ec1eSC81FJcbMC9TsAu91SdsSQiVOrT_r5mXwkKSz_8R4AjDbnYWQqX4n_ruwoZCzhwWqxSaBFBMy1JSggNMAQlHId8u_-WhaIXBC9ptOyNvlutqYvDZ2Tke_GOPYAeND5yqi9u8j-a5SGfYiVJUaJ1V3qvjtRwfmsnBv-uBSizu_qaOCjNeOhEzGs47pIeUvW9Q2Rul6yXvJ3rDDibPRaTTZ1TLR_zyOOXZZsN6UUQ0enOZSJIBXlXoXmLlVDYNHA
CL10C100JB8NNNC 100 Samsung CL10C100JB8NNNC https://octopart.com/cl10c100jb8nnnc-samsung-9301484 Multilayer Ceramic Capacitor, 10 pF, 50 V, ± 5%, C0G (NP0), 0603 [1608 Metric] C_0603_1608Metric C16 C1634 Production (Last Updated: 2 years ago) 22w Compliant 100 1276-1027-1-ND 187-CL10C100JB8NNNC 82AC9365 Cut Tape Tape & Reel 0.0146 0.015 0.006 468869 482540 22490 1 1 1 https://octopart.com/opatz8j6/a1?t=aYHPJ-NOmNjvWVnyEFUkHNuCHbsk97ulLfJitX8MkeghjxC_4mUQ0RRsFZhll7wruj0CWkTZ7-fNEy_EjQTJQSDT4r0SZUCvflRRqm3SLmIWlE4O_1VALBBgLdcrwPqOckWulOfEskdcK-jBjchKkgLXvCVWxeh4xqvRVemv6eQDbPgx8073snLoBDJhwVOxBPzdh-xlPBXFvOrklUwBBH66wKTOMtTxlu3VuTPSlh6IyRL9ob54c_kD6hUylJG6aMg https://octopart.com/opatz8j6/a1?t=riNfW5WgFwZXAEJtDAWddcxL8LWf9gNmxwGweXX8OMVm7X4uGrB1YmEGAvgX_IuTD4usNDLsbFcdd_X2JlFm1wXRhu9526hbHS1koyHWV5VSb0RmRTv9l3tUmI1n237xv8SW-BOfaK6_ExzghsvRc_GOdgIWnXr7GoDWP4JLKOxlXBNI-b7YFd_fxpNkUjtCfJvO5oEuOYBCHzDGhrkzJZyUCEMtZu0yo6HzKpK9CYoRUdOFVrCB5mPYHVZLtq6OQj7WJQ https://octopart.com/opatz8j6/a1?t=e91XZJgK3GEoVndHemMB6-3MUwTquvucVrpu5QM4HYZTZX0y9F3Q7BC_54Z0Lxhr7qb83LKA2ikLTIRmyVZHxkVQ1l4NUSDWXMeKL3OlyFn5h44aiif35krNgaMS02Rii9ukTHJ4N1yF_rZPKiAM9MvGVa0mypyIgNAYWbfJysaJ7gcPCrrQLsTj57fOFvho30X8nJuyqXYCg9LpGCzYEIaTdnc2vt_kusokyK2cfLIeWRn1wIsYKWyoosvWDUMMuNoITg Newark 82AC9365 0.006 0.6 0.6 22490 1 https://octopart.com/opatz8j6/a1?t=e91XZJgK3GEoVndHemMB6-3MUwTquvucVrpu5QM4HYZTZX0y9F3Q7BC_54Z0Lxhr7qb83LKA2ikLTIRmyVZHxkVQ1l4NUSDWXMeKL3OlyFn5h44aiif35krNgaMS02Rii9ukTHJ4N1yF_rZPKiAM9MvGVa0mypyIgNAYWbfJysaJ7gcPCrrQLsTj57fOFvho30X8nJuyqXYCg9LpGCzYEIaTdnc2vt_kusokyK2cfLIeWRn1wIsYKWyoosvWDUMMuNoITg
CL21B105KBFNNNE 50 Samsung CL21B105KBFNNNE https://octopart.com/cl21b105kbfnnne-samsung-10518888 Multilayer Ceramic Capacitor, 1 uF, 50 V, ± 10%, X7R, 0805 [2012 Metric] C_0805_2012Metric C15,C17,C9,C20,C8,C2,C23,C21 C28323 Production (Last Updated: 2 years ago) 22w Compliant 50 1276-1029-1-ND 187-CL21B105KBFNNNE 82AC9435 Cut Tape Tape & Reel 0.045 0.045 0.016 1428080 480308 1449 1 1 1 https://octopart.com/opatz8j6/a1?t=4tak_-oUV6PKBRhg1XzBHlP1TEP6Tz70yalCY6Ockehgcz2MD9CyU816PoPvfUEaMu1fW2B6XZnUp-tgkaf1EdRxtDuYvfnqXYZxM0pl_mPvHZQ3VZb-gT5Etg7fbbQ-9Ehpo7WAK9LgxAd7Rf2WtsfwiRdhroK7LJZeevaeJ8v8Bl4dnJ19JqTVePIsS_Tcyr8jnLEHJorTEPPZidL63xe6C3p7iJaTTBuBv0FKMu64Jan_7amlL2Af2C9kktTpDQs_ https://octopart.com/opatz8j6/a1?t=ZpshruXEyhZDDFfG83hlLI4OMmYaeZ8TCgG_E-UxtKzctopI6j3V6ggckTrVAzOqGbxdWG3Gdrp6MYZM3D7NfqVndBbph1I1YN_dArbN8YWo7XodA53qgQApORE4kQOOlnGUDoBvAlGxgVOzDH6_4LjkqnTSqfGZ7ahSs9AnAy10XMUx_O-_7iNNNk-JbNAJpvPDMG_QOvOdJd6Iv4P7ILf6U9ky2dtz8V6D6UEAk0Zm3lAH41kdroBSjLcw1mc-ZxApM4Q https://octopart.com/opatz8j6/a1?t=mqSAK_DWgRElbJoAv0D6Q_1ySz1n9DK1JESLYAqaSbx2HYiGeG9murycsAaHdAKpFtfW-8E-LwMU4OMbcY0F7DKNdRFL3MWSavyYX2TNbkFjos73mHQcG-6Xq0iujjI-eOEdg_0mS70jIAoGN_8IVX0SBOiNaS0d6ebpCQ3WRQuuDpi5XkRr6uueGl5wzCCD9Qr0TSlNbJafyJ3Y7MUBBquFjeWrP-ZKA3xp_rKc6hvLpOx5BpGjokPo2Vi5hI9xVYe6FKU Newark 82AC9435 0.016 0.8 0.8 1449 1 https://octopart.com/opatz8j6/a1?t=mqSAK_DWgRElbJoAv0D6Q_1ySz1n9DK1JESLYAqaSbx2HYiGeG9murycsAaHdAKpFtfW-8E-LwMU4OMbcY0F7DKNdRFL3MWSavyYX2TNbkFjos73mHQcG-6Xq0iujjI-eOEdg_0mS70jIAoGN_8IVX0SBOiNaS0d6ebpCQ3WRQuuDpi5XkRr6uueGl5wzCCD9Qr0TSlNbJafyJ3Y7MUBBquFjeWrP-ZKA3xp_rKc6hvLpOx5BpGjokPo2Vi5hI9xVYe6FKU
RT0805BRB073K01L 1 Yageo RT0805BRB073K01L https://octopart.com/rt0805brb073k01l-yageo-22252430 Res SMD 3.01K Ohm 0.1% 1/8W 0805 R_0805_2012Metric R10 C706203 22w Compliant 1 RT0805BRB073K01L-ND Tape & Reel 0 5000 https://octopart.com/opatz8j6/a1?t=iCkUAOzyFdEoiFCGVDEbzZkzLjs3QvPoiWYeu0MgQeNcWr0xwX-W_8YtTucXfi2xRDq-R9o-EGBhq5oXJBFReNC7dSS6kNGp1RolRNrYOxwBmMkFsoVFl9lhmuw2SKpn7S0zP-Kd2Gm3wnojc37uTEaaCm0H9nhLKWNdjT-qbh1IgNsy6oKRzY0H3XsKas28SiCVIhWyaTuiYIvUW0WS9FsZz-ZZHDi6pE72DFP7PU07LIa-3592r-SL0Qdf94A7oSzDNg Digi-Key RT0805BRB073K01L-ND Tape & Reel 0 5000 https://octopart.com/opatz8j6/a1?t=iCkUAOzyFdEoiFCGVDEbzZkzLjs3QvPoiWYeu0MgQeNcWr0xwX-W_8YtTucXfi2xRDq-R9o-EGBhq5oXJBFReNC7dSS6kNGp1RolRNrYOxwBmMkFsoVFl9lhmuw2SKpn7S0zP-Kd2Gm3wnojc37uTEaaCm0H9nhLKWNdjT-qbh1IgNsy6oKRzY0H3XsKas28SiCVIhWyaTuiYIvUW0WS9FsZz-ZZHDi6pE72DFP7PU07LIa-3592r-SL0Qdf94A7oSzDNg

Using Kicad-JLCPCB-Tools

  • This can be done automagically using the KiCAD-JLCPCB database. That code is available here.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment