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.

 

14 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 ?
    Thanks

    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.

  4. Dear Martin!

    I just found your blog about this Altiun library generation and that is exactly what I was looking for!
    Can you please describe how you downloaded the database from digikey?
    I have found so far a download button after I filtered out the required components but it allows me to download only the results that are shown on the page (“results per page”). How can I get access to all the components? (So if it lists me 6000 components, I am only able to download maximum 500 because that is the max results per page quantity)

    Thank you in advance!

    1. Dear Balázs,
      You are correct; I could only download 500 parts at a time. This was acceptable to me because the sets of parts I wanted to put in the library was only about 1500 so it took three pages to get them all.

      Digi-Key has an API that one could interface with in theory, however, I have not done this myself.

      1. Thank you very much for your answer 🙂
        I think 500 parts will be more than enough for me as well if I separate the parts by footprints just like you did. Thanks again!

  5. Dear Martin,

    Thank you for your excellent work! Your libraries will allow me the fast placement prototyping in the absence of VAULT.
    Thank you again for helping professionals, hobbysts and amateurs in their projects by posting such a high quality libraries!

    Best regards!

    Maxim

    P.S. Actually now I’m questioning the necessity to use VAULT since the most up to date components can be shared this way.

Leave a Reply

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