How to export stackup info

[CSMark]

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

[fox]

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.

[albin]

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.

[CSMark]

Place > Add Stackup Table

• works

Try pasting that clipboard data to the PCB

• does nothink

I need .xls or .csv rather than .pdf

[mf_ibfeew]

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:

[CSMark]

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

[eelik]

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.

[mf_ibfeew]

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.

[paulvdh]

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.