{"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\/es\/create-parts-lists-in-excel\/","title":{"rendered":"Crear listas de piezas en Excel"},"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\">Plantillas de copia<\/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>Crear listas de piezas en Inventor suele ser un trabajo que lleva mucho tiempo. Afortunadamente, la herramienta de publicaci\u00f3n tiene una funci\u00f3n para exportar listas de materiales a Excel. Para ello utilizamos una plantilla que puede personalizarse completamente a su gusto. Puede crear tantas plantillas como desee.\u00a0<\/p><p>La herramienta de publicaci\u00f3n incluye varias plantillas. Puede encontrarlas en:\u00a0<\/p><p><b>\u2018<\/b><span style=\"font-weight: bold;\">C:&gt;Usuarios &gt;Nombre &gt;AppData &gt;Roaming<\/span><span style=\"font-size: 1rem; font-weight: bolder;\">\\Autodesk - Aplicaciones - Plugins<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:&gt;Usuarios &gt;Nombre &gt;AppData &gt;Roaming<\/span><span style=\"font-size: 1rem; font-weight: bolder;\">\\Autodesk - Aplicaciones - Plugins<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>Mueva los archivos Excel a la carpeta: '<strong>....\/Design Data\/Matprop\/'<\/strong><\/li><li>Cambie el nombre de la plantilla que desea editar.<\/li><li>Puede ajustar el dise\u00f1o en la primera p\u00e1gina.\u00a0<\/li><li>En la pesta\u00f1a \"Config\" puede vincular las iProperties y los campos de la herramienta de publicaci\u00f3n.<\/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\">Cree sus propias plantillas<\/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 importante elegir el tipo correcto en la primera columna. Elija \"Celda\" para vincular una iProperty espec\u00edfica a una celda. Puede introducir simplemente iProperties Cusom con el nombre y se reconocer\u00e1n autom\u00e1ticamente.<\/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\">Lista de piezas en 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>Abra un montaje e inicie la herramienta Publicar. Las plantillas de Excel aparecen autom\u00e1ticamente:<\/p><p><strong> Herramientas -&gt; Listas de piezas 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\">Resultado<\/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>Haga clic en la plantilla deseada y espere hasta que la lista de materiales est\u00e9 lista.\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\/es\/wp-json\/wp\/v2\/posts\/1765","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/matprop.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/matprop.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/matprop.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/matprop.com\/es\/wp-json\/wp\/v2\/comments?post=1765"}],"version-history":[{"count":14,"href":"https:\/\/matprop.com\/es\/wp-json\/wp\/v2\/posts\/1765\/revisions"}],"predecessor-version":[{"id":4012,"href":"https:\/\/matprop.com\/es\/wp-json\/wp\/v2\/posts\/1765\/revisions\/4012"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/matprop.com\/es\/wp-json\/wp\/v2\/media\/1284"}],"wp:attachment":[{"href":"https:\/\/matprop.com\/es\/wp-json\/wp\/v2\/media?parent=1765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/matprop.com\/es\/wp-json\/wp\/v2\/categories?post=1765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/matprop.com\/es\/wp-json\/wp\/v2\/tags?post=1765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}