Altium libraries – capacitors and resistors

I generated several libraries for Altium (or Circuit Studio) using Database Libraries which I then exported to IntLibs.

I realize you can get many of these parts from Altium or other third parties. I wanted to figure out on my own how I could scrape data from Digi-Key and (almost) automatically create part libraries.

Altium Designer has a powerful feature called Database Libraries which take an external database and link entries to a schematic symbol and physical footprint. The database can take many forms such as an Excel spreadsheet, Microsoft Access database, or in theory any SQL or ODBC source.

I’ll start here by giving you the libraries I generated and I’ll make another post about how I generated them.

INTLIBs (for Altium or Circuit Studio):

Panasonic ERJ resistors libraries download

Murata capacitors libraries download

DBLIBs (for Altium only):

Panasonic ERJ resistors Altium DBLIB

Murata capacitors Altium DBLIB


There are 6,029 resistors, all are Panasonic ERJ series. The resistors are split up into 6 different IntLibs according to package size: 0201, 0402, 0603, 0805, 1206, 2512. I scraped the data from Digi-Key to create these libraries and thus they contain a significant number of parameters that you can use for your BOM generation.

The capacitor libraries are similar. There are 4,739 capacitors in 6 different libraries split up according to package size: 0201, 0402, 0603, 0805, 1206, 1210. They all contain similar parameters as the resistors. All capacitors are Murata – because it was easier to scrape one manufacturer without getting thousands of duplicate value parts.


10 thoughts on “Altium libraries – capacitors and resistors”

  1. Hello Martin,
    interesting topic. About database library I would like to ask you:
    1) do you use MS Access or Excel for database file ?
    2) have you find a fast way to import data from digikey or other supplier ? or do you import all data manually ?

    1. Federico,
      I downloaded CSV data from Digi-Key.
      Then I converted the CSV to XLS using Excel.
      From there, I used Altium Designer to create a dblib which I could convert to an IntLib.

      There are better guides on the internet for how to do this.

      1. Tnx but I’m not sure what you mean. I am usign an Excel filse as component database, is altium able to add information directy to excel file ? I use to do it manually for each component

        Could you give me a link of a guide ?

        1. Federico, I updated the post with links to the dblibs that I created. You can use this as an example of how to create your own dblibs.

  2. Hi Martin,

    In your process to create the IntLibs you first created DBLibs. Many users prefer to use DBLib instead of IntLibs. Please share the DBLibs.

    1. Hey Randy, I updated the post with links to the dblibs.
      I based them on XLS files so you might be disappointed- it’s not really a “database” library. But at least you can use it as an example.

  3. Hello Martin,

    Your write up on DBLib saved my day. Your library helped me to build my own library for discrete components. I tried to set the “Default Comment” in schematic symbol to “= Resistance”, but with strange result. It always populates the value found in first row. Any suggestions?

    1. Do you have a parameter named “Resistance” ? In a database library you need to have a column called “Value” which will map to the symbol parameter of the same name.

Leave a Reply

Your email address will not be published. Required fields are marked *