Hello,
I have the Physical Stackup table filled out. I haven’t found a way to export it in a reasonable way. There is an Export to Clipboard function, its output is a bit confusing - does not conform to .csv or .xls format
Is there a better way to do it?
I am using KiCAD 7.0.6/7.0.10
Click on Place > Add Stackup Table and place the table in the PCB Editor on a user defined layer of your choice. This layer can then be exported as a PDF.
1 Like
Try pasting that clipboard data to the PCB. Not at the PC now, but I think that it will paste as graphics and texts on the PCB. Paste it to a suitable layer.
Place > Add Stackup Table
- works
Try pasting that clipboard data to the PCB
- does nothink
I need .xls or .csv rather than .pdf
1 Like
There is an Export to Clipboard function, its output is a bit confusing - does not conform to .csv or .xls format
- xls is proprietary and overly complicated, so expecting that is unreasonable
- csv shows up in many flavors, and the output is very well usable for a csv-file
follow these steps:
- open kicad, pcb editor with your board in question
- File–>board setup → Board Stackup–>Physical stackup
- use button “export to clipboard” in bottom right
- open a simple ASCII text editor in parallel, paste content from clipboard, save as *.csv file
- open spreadsheet calculator and import this csv file, use " " (space) character as delimiter
- also make sure that mating strings are recognized by a surrounding
" "(quote marks)
libreoffice import dialog as example:
The problem is with the organization of the data rather than the type of delimiter. When I finish the import into Libreoffice, I get a table, but its organization is rather a mess…
| layer | F.Silkscreen | type | Top Silk Screen | Color | White | Material | Liquid Photo | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| layer | F.Paste | type | Top Solder Paste | |||||||||||
| layer | F.Mask | type | Top Solder Mask | Color | Green | Thickness | 0.0127 | mm | Material | Liquid Ink | EpsilonR | 3.8 | LossTg | 0 |
| layer | F.Cu | type | copper | Thickness | 0.035 | mm | ||||||||
| layer | Dielectric 1 | type | prepreg | |||||||||||
| sublayer | 1/1 | Color | FR4 natural | Thickness | 0.092 | mm | Material | FR4 | EpsilonR | 4.1 | LossTg | 0.02 | ||
| layer | In1.Cu | type | copper | Thickness | 0.03 | mm | ||||||||
| layer | Dielectric 2 | type | core | |||||||||||
| sublayer | 1/1 | Color | FR4 natural | Thickness | 0.1 | mm | Material | FR4 | EpsilonR | 4.17 | LossTg | 0.02 | ||
| layer | In2.Cu | type | copper | Thickness | 0.03 | mm | ||||||||
| layer | Dielectric 3 | type | prepreg | |||||||||||
| sublayer | 1/3 | Color | FR4 natural | Thickness | 0.092 | mm | Material | FR4 | EpsilonR | 4.1 | LossTg | 0.02 | ||
| sublayer | 2/3 | Thickness | 0.865 | mm | Material | FR4 | EpsilonR | 4.43 | LossTg | 0.02 | ||||
| sublayer | 3/3 | Thickness | 0.092 | mm | Material | FR4 | EpsilonR | 4.1 | LossTg | 0.02 | ||||
| layer | In3.Cu | type | copper | Thickness | 0.03 | mm | ||||||||
| layer | Dielectric 4 | type | core | |||||||||||
| sublayer | 1/1 | Color | FR4 natural | Thickness | 0.1 | mm | Material | FR4 | EpsilonR | 4.17 | LossTg | 0.02 | ||
| layer | In4.Cu | type | copper | Thickness | 0.03 | mm | ||||||||
| layer | Dielectric 5 | type | prepreg | |||||||||||
| sublayer | 1/1 | Color | FR4 natural | Thickness | 0.092 | mm | Material | FR4 | EpsilonR | 4.1 | LossTg | 0.02 | ||
| layer | B.Cu | type | copper | Thickness | 0.035 | mm | ||||||||
| layer | B.Mask | type | Bottom Solder Mask | Color | Green | Thickness | 0.0127 | mm | Material | Liquid Ink | EpsilonR | 3.8 | LossTg | 0 |
| layer | B.Paste | type | Bottom Solder Paste | |||||||||||
| layer | B.Silkscreen | type | Bottom Silk Screen | Color | White | Material | Liquid Photo | |||||||
| Finish | None | Option | Impedance Controlled |
While the screenshot looks like this
That’s right, it’s not normal csv where each column has only a value and possible column names are given only in as the first line, optionally. There’s no option to handle every second column as column names when importing a csv to spreadsheet programs. And it’s not even every second; different lines have different column names.
This exported text can be handled programmatically, but not in any easy way.
1 Like
When I finish the import into Libreoffice, I get a table, but its organization is rather a mess…
Ok, this explanation and your pictures show the problem more clearly. The contents of different columns are mixed together, so this requires much manual rework.
Regarding your original question: I don’t know of any better way to export this table.
But as the “export to clipboard” button is clearly dedicated for the export to an external editor/spreadsheet it would be a reasonable feature request to improve the content (or better: the formatting of the content) which is copied into the clipboard.
I just had a look on what got pasted to the clipboard:
layer "F.Silkscreen" type "Top Silk Screen" Color "Not specified" Material "Not specified"
layer "F.Paste" type "Top Solder Paste"
layer "F.Mask" type "Top Solder Mask" Color "Not specified" Thickness 0.01 mm Material "Not specified" EpsilonR 3.3 LossTg 0
layer "F.Cu" type "copper" Thickness 0.035 mm
layer "Dielectric 1" type "core"
sublayer "1/1" Color "Not specified" Thickness 1.51 mm Material "FR4" EpsilonR 4.5 LossTg 0.02
layer "B.Cu" type "copper" Thickness 0.035 mm
layer "B.Mask" type "Bottom Solder Mask" Color "Not specified" Thickness 0.01 mm Material "Not specified" EpsilonR 3.3 LossTg 0
layer "B.Paste" type "Bottom Solder Paste"
layer "B.Silkscreen" type "Bottom Silk Screen" Color "Not specified" Material "Not specified"
Finish "None"
… and it’s keyword and value pairs. A bit like S-expressions but without the parenthesis. Bit of a weird format and there is certainly room for improvement. 