Have you used the radio button on the BOM export that sets the field separator for spreadsheet import?
Regards,
Robert.
toggle quoted message
Show quoted text
On 04/07/2012 14:27, randyinnc55 wrote:
Is there a way to get the KiCad BOM output to look like the following:
generically:
Item#<t>Quantity<t>RefDesList<t>PartValue<t>Footprint
where<t> is a tab character.
hypothetical example:
1<t>3<t>C1,C2,C5<t>0.1uF<t>SM0603
2<t>2<t>C3,C4<t>100pF<t>SM0603
3<t>2<t>R1,R3<t>1.0K<t>SM0603
4<t>1<t>R2<t>10R0<t>SM1206
5<t>1<t>U1<t>LM358AM<t>SOIC8
Then I can import this file into Excel and use the tabs to delimit each field. Notice that all the reference designators in the RefDesList are all within one field. This way all those of a particular part value they end up all in one Excel cell. OrCad can make this kind of BOM easily.
Thanks!
------------------------------------
Please read the Kicad FAQ in the group files section before posting your question.
Please post your bug reports here. They will be picked up by the creator of Kicad.
Please visit for details of how to contribute your symbols/modules to the kicad library.
For building Kicad from source and other development questions visit the kicad-devel group at ! Groups Links
---
avast! Antivirus: Inbound message clean.
Virus Database (VPS): 120703-1, 03/07/2012
Tested on: 04/07/2012 14:30:40
avast! - copyright (c) 1988-2012 AVAST Software.
--
() Plain text email - safe, readable, inclusive.
/\
