Spreadsheet to library- found any tool for it?

Is it any too import parts from spreadsheet? (Excel, csv etc…)

Symbol library looks this

  (symbol "BAT54S" (pin_names (offset 1.016)) (in_bom yes) (on_board yes)
    (property "Reference" "D1" (id 0) (at 1.905 1.2701 90)
      (effects (font (size 1.27 1.27)) (justify left))
    )
    (property "Value" "BAT54S" (id 1) (at 1.905 -1.2699 90)
      (effects (font (size 1.27 1.27)) (justify left))
    )
    (property "Footprint" "mylib:SOT-23" (id 2) (at 3.175 1.905 0)
      (effects (font (size 1.27 1.27)) (justify left) hide)
    )
    (property "Datasheet" "https://www.diodes.com/assets/Datasheets/ds11005.pdf" (id 3) (at 0 -3.048 0)
      (effects (font (size 1.27 1.27)) hide)
    )
    (property "LCSC" "C408389" (id 4) (at 0 0 0)
      (effects (font (size 1.27 1.27)) hide)
    )
    (property "ki_keywords" "schottky diode" (id 5) (at 0 0 0)
      (effects (font (size 1.27 1.27)) hide)
    )
    (property "ki_description" "schottky barrier diode double" (id 6) (at 0 0 0)
      (effects (font (size 1.27 1.27)) hide)
    )
    (property "ki_fp_filters" "SOT?23*" (id 7) (at 0 0 0)
      (effects (font (size 1.27 1.27)) hide)
    )
    (symbol "BAT54S_0_1"
      (polyline
        (pts
          (xy -3.81 0)
          (xy -1.27 0)
        )
        (stroke (width 0) (type default) (color 0 0 0 0))
        (fill (type none))
     etcetcetc lorem ipsum 
)

Looks this really need any script- maybe external not inside kicad, python code. But found this tool or not? Eg. Kipart, but it is not fully functions and does not make work properly.

If we check this symbol, it is really clear:

  • Symbol “name”
  • Then list of properties; refdes, value, footprint and then much much customer spesific properties
  • Then symbol graphical presentation

If this type tool is not available, I am sure it will be easy. In csv-table it is symbol;refdes;value;footprint;…and customerproperty1; customerproperty2…

So, all this first lines are easy.

Symbol graphical presentation is not so easy. But in my opinion it IS easy. Simply take this symbol section and save it to file. In spreadsheet it is column “symbol file”: “myfinebat54symbolgraphical.txt”.

Is this type script available…

You can take a look into: GitHub - eeintech/kicad-database-utils-csv: Manage KiCad symbol library files using CSV format
It won’t export to V6 library format but V5 only. Open the library in KiCad to migrate it to V6.

There is also uConfig. The article below is from 2018, so it’s also quite old, and I don’t know if it’s been maintained.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.