{"id":1765,"date":"2024-09-27T21:27:10","date_gmt":"2024-09-27T19:27:10","guid":{"rendered":"https:\/\/matprop.com\/?p=1765"},"modified":"2026-07-06T20:00:56","modified_gmt":"2026-07-06T18:00:56","slug":"create-parts-lists-in-excel","status":"publish","type":"post","link":"https:\/\/matprop.com\/de\/create-parts-lists-in-excel\/","title":{"rendered":"St\u00fccklisten in Excel erstellen"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"1765\" class=\"elementor elementor-1765\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d924192 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d924192\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-95df066\" data-id=\"95df066\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2be54f4 elementor-widget elementor-widget-heading\" data-id=\"2be54f4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Vorlagen kopieren<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c0ee579 elementor-widget elementor-widget-text-editor\" data-id=\"c0ee579\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Das Erstellen von St\u00fccklisten in Inventor ist oft eine zeitraubende Arbeit. Gl\u00fccklicherweise verf\u00fcgt das Publish Tool \u00fcber eine Funktion zum Exportieren von St\u00fccklisten nach Excel. Hierf\u00fcr verwenden wir eine Vorlage, die Sie ganz nach Ihrem Geschmack anpassen k\u00f6nnen. Sie k\u00f6nnen so viele Vorlagen erstellen, wie Sie m\u00f6chten.\u00a0<\/p><p>Das Ver\u00f6ffentlichungstool enth\u00e4lt eine Reihe von Vorlagen. Sie finden diese in:\u00a0<\/p><p><b>\u2018<\/b><span style=\"font-weight: bold;\">C:\\Benutzer\\\\AppData\\Roaming<\/span><span style=\"font-size: 1rem; font-weight: bolder;\">\\Autodesk\\ApplicationPlugins\\<br \/><\/span><b>Matprop Publish Tool\\Contents\\net48\\Sample Files&#8217;<\/b><br \/>or for Inventor 2025 and higher:<br \/><span style=\"font-weight: bold;\">\u2018<\/span><span style=\"font-weight: bold;\">C:\\Benutzer\\\\AppData\\Roaming<\/span><span style=\"font-size: 1rem; font-weight: bolder;\">\\Autodesk\\ApplicationPlugins\\<br \/><\/span><span style=\"font-weight: bold;\">Matprop Publish Tool\\Contents\\<\/span><b>net8.0-windows<\/b><span style=\"font-weight: bold; font-size: 1rem;\">\\Sample Files&#8217;<\/span><\/p><ul><li>Verschieben Sie die Excel-Dateien in den Ordner: '<strong>....\/Gestaltungsdaten\/Matprop\/'<\/strong><\/li><li>Benennen Sie die Vorlage, die Sie bearbeiten m\u00f6chten, um.<\/li><li>Sie k\u00f6nnen das Layout auf der ersten Seite anpassen.\u00a0<\/li><li>Auf der Registerkarte 'config' k\u00f6nnen Sie die iProperties und die Felder des Publish Tools miteinander verkn\u00fcpfen.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-c1ce9df\" data-id=\"c1ce9df\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5aa1574 elementor-widget__width-initial elementor-widget elementor-widget-image\" data-id=\"5aa1574\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Partslist excel1\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTc5NCwidXJsIjoiaHR0cHM6XC9cL21hdHByb3AuY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI0XC8wOVwvUGFydHNsaXN0LWV4Y2VsMS5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"648\" src=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1-1024x830.png\" class=\"attachment-large size-large wp-image-1794\" alt=\"\" srcset=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1-1024x830.png 1024w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1-300x243.png 300w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1-768x623.png 768w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1-600x487.png 600w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Partslist-excel1.png 1137w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7d83003 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d83003\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-667af45\" data-id=\"667af45\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c5b14e8 elementor-widget elementor-widget-heading\" data-id=\"c5b14e8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Erstellen Sie Ihre eigenen Vorlagen<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-143e2d5 elementor-widget elementor-widget-text-editor\" data-id=\"143e2d5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Es ist wichtig, dass Sie in der ersten Spalte den richtigen Typ ausw\u00e4hlen. W\u00e4hlen Sie \"Zelle\", um eine bestimmte iProperty mit einer Zelle zu verkn\u00fcpfen. Sie k\u00f6nnen einfach Cusom iProperties mit dem Namen eingeben und sie werden automatisch erkannt.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-8db2d55\" data-id=\"8db2d55\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3b28ef0 elementor-widget elementor-widget-image\" data-id=\"3b28ef0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Part list to excel mapping\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTg0NSwidXJsIjoiaHR0cHM6XC9cL21hdHByb3AuY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI0XC8wOVwvUGFydC1saXN0LXRvLWV4Y2VsLW1hcHBpbmcucG5nIn0%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"643\" src=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping.png\" class=\"attachment-large size-large wp-image-1845\" alt=\"\" srcset=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping.png 881w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping-300x241.png 300w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping-768x617.png 768w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Part-list-to-excel-mapping-600x482.png 600w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-36a6574 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36a6574\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-9a56695\" data-id=\"9a56695\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2c3aafe elementor-widget elementor-widget-heading\" data-id=\"2c3aafe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">St\u00fcckliste in Excel<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-721f6b6 elementor-widget elementor-widget-text-editor\" data-id=\"721f6b6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>\u00d6ffnen Sie eine Baugruppe und starten Sie das Publish Tool. Die Excel-Vorlagen erscheinen automatisch:<\/p><p><strong> Werkzeuge -&gt; St\u00fccklisten Excel.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-f4faab2\" data-id=\"f4faab2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9a2e8e2 elementor-widget elementor-widget-image\" data-id=\"9a2e8e2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Schermafbeelding-2024-09-27-213432.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Schermafbeelding 2024-09-27 213432\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTgxNywidXJsIjoiaHR0cHM6XC9cL21hdHByb3AuY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI0XC8wOVwvU2NoZXJtYWZiZWVsZGluZy0yMDI0LTA5LTI3LTIxMzQzMi5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"734\" height=\"382\" src=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Schermafbeelding-2024-09-27-213432.png\" class=\"attachment-large size-large wp-image-1817\" alt=\"\" srcset=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Schermafbeelding-2024-09-27-213432.png 734w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Schermafbeelding-2024-09-27-213432-300x156.png 300w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/09\/Schermafbeelding-2024-09-27-213432-600x312.png 600w\" sizes=\"(max-width: 734px) 100vw, 734px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-941b8da elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"941b8da\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-c9819d9\" data-id=\"c9819d9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a65773d elementor-widget elementor-widget-heading\" data-id=\"a65773d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Ergebnis<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e55ee2 elementor-widget elementor-widget-text-editor\" data-id=\"4e55ee2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Klicken Sie auf die gew\u00fcnschte Vorlage und warten Sie, bis die BOM-Liste fertig ist!\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-f62b5c6\" data-id=\"f62b5c6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d11c7f3 elementor-widget elementor-widget-image\" data-id=\"d11c7f3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Parts List Excel\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTI4NCwidXJsIjoiaHR0cHM6XC9cL21hdHByb3AuY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI0XC8wOFwvUGFydHMtTGlzdC1FeGNlbC5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"620\" src=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel-1024x793.png\" class=\"attachment-large size-large wp-image-1284\" alt=\"\" srcset=\"https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel-1024x793.png 1024w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel-300x232.png 300w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel-768x595.png 768w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel-600x465.png 600w, https:\/\/matprop.com\/wp-content\/uploads\/2024\/08\/Parts-List-Excel.png 1257w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Copy templates Creating Parts lists in Inventor is often a time-consuming job. Fortunately, the Publish Tool has a function to export BOM lists to Excel. For this we use a template that can be completely customized to your own taste. You can create as many templates as you want.\u00a0 A number of templates are included [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1284,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,30],"tags":[],"class_list":["post-1765","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-publish-tool","category-tutorials"],"_links":{"self":[{"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/posts\/1765","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/comments?post=1765"}],"version-history":[{"count":14,"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/posts\/1765\/revisions"}],"predecessor-version":[{"id":4012,"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/posts\/1765\/revisions\/4012"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/media\/1284"}],"wp:attachment":[{"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/media?parent=1765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/categories?post=1765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/matprop.com\/de\/wp-json\/wp\/v2\/tags?post=1765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}