{"id":19343,"date":"2013-08-07T20:40:28","date_gmt":"2013-08-07T20:40:28","guid":{"rendered":"https:\/\/blogs.solidworks.com\/solidworksblog\/?p=19343"},"modified":"2013-08-08T15:45:08","modified_gmt":"2013-08-08T15:45:08","slug":"solidworks-toolbox-browser-adding-property-values-with-the-help-of-excel","status":"publish","type":"post","link":"https:\/\/blogs.solidworks.com\/solidworksblog\/2013\/08\/solidworks-toolbox-browser-adding-property-values-with-the-help-of-excel.html","title":{"rendered":"SolidWorks Toolbox Browser: Adding Property Values with the Help of Excel"},"content":{"rendered":"<style type=\"text\/css\"><!--\n.aligncenter_simple {\ntext-align: center;\n}\n--><\/style>\n<p>The SolidWorks Toolbox Browser is one of the most used add-ins by SolidWorks users, and supports international standards, including: ANSI and ISO.<\/p>\n<p>You can use the Toolbox Browser directly from the Toolbox Design Library task pane, in order to access Toolbox components. In addition, you can right-click and drag the component in the assemblies option by selecting the proper parameters (length, width, etc.).<\/p>\n<p>&nbsp;<\/p>\n<table width=\"100%\" border=\"0\" cellspacing=\"25\" cellpadding=\"25\">\n<tbody>\n<tr>\n<td align=\"center\"><span class=\"aligncenter_simple\"><a href=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-11.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-19377\" alt=\"SolidWorks Toolbox by SolidXperts\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-11-615x450.jpg\" width=\"431\" height=\"315\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-11-615x450.jpg 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-11-300x219.jpg 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-11-120x87.jpg 120w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-11.jpg 1000w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><\/a><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Interestingly, if a hole is made using the Hole Wizard\/Toolbox it will automatically recognize the hole diameter and depth. On the contrary, the inserted fasteners do not contain custom properties that you want. You must manually add the description and the required part number per size to identify it in the nomenclature of a part. This task is done manually and repetitively, and with each new part addition and size. This method is commonly used and known by most users. The parameter configuration is available through the System Options or in the Toolbox Menu.<\/p>\n<p>&nbsp;<\/p>\n<table width=\"100%\" border=\"0\" cellspacing=\"25\" cellpadding=\"25\">\n<tbody>\n<tr>\n<td align=\"center\"><a href=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-21.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-19378\" alt=\"SolidWorks Toolbox by SolidXperts\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-21-615x450.jpg\" width=\"431\" height=\"315\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-21-615x450.jpg 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-21-300x219.jpg 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-21-120x87.jpg 120w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-21.jpg 1000w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td align=\"center\"><a href=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-31.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-19379\" alt=\"SolidWorks Toolbox by SolidXperts\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-31-615x215.jpg\" width=\"431\" height=\"151\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-31-615x215.jpg 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-31-300x105.jpg 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-31-120x42.jpg 120w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-31.jpg 1000w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>There is a hidden button in the control panel of the Toolbox and it gives you the option to export data to Toolbox parts in Excel format.<\/p>\n<p>&nbsp;<\/p>\n<table width=\"100%\" border=\"0\" cellspacing=\"25\" cellpadding=\"25\">\n<tbody>\n<tr>\n<td align=\"center\"><a href=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-41.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-19380\" alt=\"SolidWorks Toolbox by SolidXperts\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-41-615x399.jpg\" width=\"431\" height=\"279\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-41-615x399.jpg 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-41-300x195.jpg 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-41-120x78.jpg 120w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-41.jpg 1000w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Furthermore, through the power of Excel, quickly and easily insert the configuration specific property. Imagine being able to add or edit the description of a thread length, screw size, and diameter with the help of using Excel. Finally, you can import the file into the Toolbox configuration and your descriptions will be added to the Customize Hardware page.<\/p>\n<p>&nbsp;<\/p>\n<table width=\"100%\" border=\"0\" cellspacing=\"25\" cellpadding=\"25\">\n<tbody>\n<tr>\n<td align=\"center\"><a href=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-51.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-19381\" alt=\"SolidWorks Toolbox by SolidXperts\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-51-615x353.jpg\" width=\"431\" height=\"247\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-51-615x353.jpg 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-51-300x172.jpg 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-51-120x69.jpg 120w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/2\/2013\/08\/solidxperts-solidworks-toolbox-51.jpg 1000w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Visit our YouTube channel My3DXperts for the in-depth video of this technical tip, or for other interesting tips: <strong><a title=\"My3DXperts Channel is owned by SolidXperts\" href=\"https:\/\/www.youtube.com\/watch?v=u9-d_r3rEnc\" target=\"_blank\">My3DXperts Tech Channel.<\/a><\/strong><\/p>\n<p style=\"text-align: left;\">If you would like to learn more about the design tools in SolidWorks, you can <a href=\"https:\/\/www.solidworks.com\/sw\/purchase\/solidworks-trial.htm?mktid=2430\">request a free SolidWorks trial<\/a> on the SolidWorks website.<\/p>\n<p style=\"text-align: center;\">***<\/p>\n<p>SolidXperts is a SolidWorks Value Added Reseller with locations in the northeastern US and Canada. You can read more from them <a href=\"https:\/\/www.solidxperts.com\/blog\/en\/\">on the SolidXperts blog<\/a>.<\/p>\n<div id=\"stcpDiv\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>The SolidWorks Toolbox Browser is one of the most used add-ins by SolidWorks users, and supports international standards, including: ANSI and ISO. You can use the Toolbox Browser directly from the Toolbox Design Library task pane, in order to access<\/p>\n... <a href=\"https:\/\/blogs.solidworks.com\/solidworksblog\/2013\/08\/solidworks-toolbox-browser-adding-property-values-with-the-help-of-excel.html\">Continued<\/a>","protected":false},"author":119,"featured_media":19345,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[16,57],"tags":[1083,1104,1103,1100,1101],"class_list":["post-19343","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips-tricks","category-webtech","tag-design-library","tag-fasteners","tag-hole-diameter","tag-solidworks-toolbox","tag-toolbox-menu"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.solidworks.com\/solidworksblog\/wp-json\/wp\/v2\/posts\/19343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.solidworks.com\/solidworksblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.solidworks.com\/solidworksblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/solidworksblog\/wp-json\/wp\/v2\/users\/119"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/solidworksblog\/wp-json\/wp\/v2\/comments?post=19343"}],"version-history":[{"count":0,"href":"https:\/\/blogs.solidworks.com\/solidworksblog\/wp-json\/wp\/v2\/posts\/19343\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/solidworksblog\/wp-json\/wp\/v2\/media\/19345"}],"wp:attachment":[{"href":"https:\/\/blogs.solidworks.com\/solidworksblog\/wp-json\/wp\/v2\/media?parent=19343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/solidworksblog\/wp-json\/wp\/v2\/categories?post=19343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/solidworksblog\/wp-json\/wp\/v2\/tags?post=19343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}