[HOW] Make a CSV of only DNP Parts

[ajinkyakamat]

Thanks for such a wonderful tool.

What do you want to achieve?
I want to generate a csv that only lists parts marked as "Do Not Populate" in the schematics. I want to have a seperate csv for only top components and only the bottom components. I tried making a generic filter and a bom output with the filter as an exclude. But it did not work. I am quite unsure how the filters work with respect to DNF, DNC. Please help.

Do you have some PCB/Schematic to use as example?
In this example, References C1, R14, C7, C8 and C6 are maked as DNP
dnp_howto_example_kicad_project.zip

Environment (please complete the following information):
Where are you running KiBot:

• In a CI/CD workflow? No
• In a GitHub action? Which tag are you using? No
• Using a docker image? kicad9_auto_full:dev
• Using a desktop system? Which OS, distro and version? Ubuntu 24.04

[set-soft]

Hi @ajinkyakamat !
Sorry for the big delay, I was on vacations.
Currently there is no mechanism for CSV, but you can do it for XLSX and HTML
In these formats DNP components are separated, here is an example:

kibot:
  version: 1

filters:
  - name: 'top'
    type: 'generic'
    comment: 'Remove bottom components'
    exclude_bottom: true

outputs:
  - name: 'filtered'
    comment: "BoM for top"
    type: bom
    dir: BoM
    options:
      output: 'filtered.%x'
      exclude_filter: 'top'
      format: XLSX

You can then run xlsx2csv --sheet 2 BoM/filtered.xlsx BoM/filtered.csv and get the DNP sheet as a CSV file.

The xlsx2csv tool is part of the package of the same name.

[set-soft]

The above patch makes things easier by adding an option to the generic filter, so now you can use:

kibot:
  version: 1

filters:
  - name: 'top'
    type: 'generic'
    comment: 'Remove bottom components'
    exclude_bottom: true

  - name: 'bottom'
    type: 'generic'
    comment: 'Remove top components'
    exclude_top: true

  - name: 'dnp'
    type: 'generic'
    comment: 'Remove non DNP components'
    invert: true
    exclude_kicad_dnp: true

outputs:
  - name: 'top_dnp'
    comment: "BoM for top DNP"
    type: bom
    dir: BoM
    options:
      output: 'top_dnp.%x'
      exclude_filter: ['top', 'dnp']
      kicad_dnp_applied: 'no'

  - name: 'bottom_dnp'
    comment: "BoM for bottom DNP"
    type: bom
    dir: BoM
    options:
      output: 'bottom_dnp.%x'
      exclude_filter: ['bottom', 'dnp']
      kicad_dnp_applied: 'no'

In your design I moved R4 (also DNP) to the bottom layer and got these outputs:

top_dnp.csv

Row,Description,Part,References,Value,Footprint,Quantity Per PCB,Status,Datasheet,Manufacturer,Manufacturer Part No,Resistance,Tolerance,Wattage,MFG,MPN,Capacitance,Voltage,Material,Inductan
1,Unpolarized capacitor,C,C1,C,C_1206_3216Metric_Pad1.33x1.80mm_HandSolder,1, ,~,,,,,,B,B,,,,,,,
2,Unpolarized capacitor,C,C6 C7,C,R_0603_1608Metric_Pad0.98x0.95mm_HandSolder,2, ,~,,,,,,B,B,,,,,,,
3,Unpolarized capacitor,C,C8,C,C_0402_1005Metric_Pad0.74x0.62mm_HandSolder,1, ,~,,,,,,B,B,,,,,,,
4,Resistor,R,R14,R,R_0603_1608Metric_Pad0.98x0.95mm_HandSolder,1, ,~,,,,,,B,B,,,,,,,





Project info:
Schematic:,fai_kicad_template
Variant:,default
Revision:,
Date:,2026-01-14_17-36-26
KiCad Version:,9.0.7+1
Statistics:
Component Groups:,4
Component Count:,5
Fitted Components:,5
Number of PCBs:,1
Total Components:,5

bottom_dnp.csv

Row,Description,Part,References,Value,Footprint,Quantity Per PCB,Status,Datasheet,Manufacturer,Manufacturer Part No,Resistance,Tolerance,Wattage,MFG,MPN,Capacitance,Voltage,Material,Inductance,Saturation Current,Peak Current,Impedence
1,"47 kOhms ±1% 0.063W, 1/16W Chip Resistor 0402 (1005 Metric) Moisture Resistant Thick Film",FAI~RC0402FR-0747KL,R4,47K 1%,R_0402_1005Metric,1, ,https://www.yageogroup.com/content/datasheet/asset/file/PYU-RC_GROUP_51_ROHS_L,YAGEO,RC0402FR-0747KL,47K,1%,0.063W,,,,,,,,,





Project info:
Schematic:,fai_kicad_template
Variant:,default
Revision:,
Date:,2026-01-14_17-36-26
KiCad Version:,9.0.7+1
Statistics:
Component Groups:,1
Component Count:,1
Fitted Components:,1
Number of PCBs:,1
Total Components:,1

BTW: your example generates plenty of warnings, I recommend addressing them

[ajinkyafieldai]

Thank you so much