# New Material Library export to excel and import to project? **URL:** \ **Category:** Packages\ **Tags:** revit\ **Created:** [April 13, 2017, 1:02am UTC](https://forum.dynamobim.com/t/new-material-library-export-to-excel-and-import-to-project/11030 "2017-04-13T01:02:51Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Batman86](https://avatars.discourse-cdn.com/v4/letter/b/858c86/32.png) [@Batman86](https://forum.dynamobim.com/u/Batman86)\ **Post date:** [April 13, 2017, 1:02am UTC](https://forum.dynamobim.com/t/new-material-library-export-to-excel-and-import-to-project/11030/1 "2017-04-13T01:02:52Z")
Hi All What we are trying to do; We have created a new material library and we would like to replace all the existing materials from our existing revit project to the new and improved materials. I am trying to export the materials from the library but i am finding it difficult doing so when they have not been used? I can get the materials imported back in from with the help of Konrad K Sobon Blog… > **[playing with materials in dynamo while drinking heavily](http://archi-lab.net/playing-with-materials-in-dynamo-while-drinking-heavily/)** > > I don’t usually play around with Materials in Revit, and even less so with renderings out of Revit, but recently I was engaged by couple of people with questions about those so here’s s… But I have no idea how to extract the library materials to excel…? or will i need to create a generic model with the new material? export and then import it back in? that is possible but we have over 500 materials… Would like to have some help with this. Cheers ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [April 15, 2017, 7:36pm UTC](https://forum.dynamobim.com/t/new-material-library-export-to-excel-and-import-to-project/11030/2 "2017-04-15T19:36:04Z")
Hi @Batman86 Check out clockwork package custom nodes. Below is an example which i replaced in to new material. ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/2/d2853b338ed2180431faeca0cdcf7b1e5496052b.png) ---
**Author:** ![truevis](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/truevis/32/8634_2.png) [@truevis](https://forum.dynamobim.com/u/truevis)\ **Post date:** [April 15, 2017, 8:02pm UTC](https://forum.dynamobim.com/t/new-material-library-export-to-excel-and-import-to-project/11030/3 "2017-04-15T20:02:01Z")
Wouldn’t one use **Transfer Project Standards** for getting new or existing Materials from one RVT to another? > **[Understanding Transfer Project Standards Feature in Revit | Revit Products |...](https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/simplecontent/content/understanding-transfer-project-standards-feature-revit.html)** > > One of the advantages of supporting any type of software is that you are often confronted with the customer’s workflows and needs. Many times, the support case leads to further investigation to understand what the customer is trying to accomplish and... ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [April 16, 2017, 1:38am UTC](https://forum.dynamobim.com/t/new-material-library-export-to-excel-and-import-to-project/11030/4 "2017-04-16T01:38:14Z")
@truevis Transfer project standards material works if you have same name materials for overriding the existing. It doesn’t allow to reassign to the elements if the material names are different. ---
**Author:** ![truevis](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/truevis/32/8634_2.png) [@truevis](https://forum.dynamobim.com/u/truevis)\ **Post date:** [April 16, 2017, 2:04am UTC](https://forum.dynamobim.com/t/new-material-library-export-to-excel-and-import-to-project/11030/5 "2017-04-16T02:04:56Z")
> [@Kulkul](#): > > Transfer project standards material works if you have same name materials for overriding the existing. It doesn’t allow to reassign to the elements if the material names are different. Right, so make the new RVT’s Material names the same as the old RVT’s Material names. [Material Asset Names](https://forum.dynamobim.com/t/material-asset-names/4824) discusses renaming Materials via Dynamo. That may help. I’m doubting that all aspects of Materials can be accessed via Dynamo since Autodesk Materials are closed-source. ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [April 16, 2017, 3:05am UTC](https://forum.dynamobim.com/t/new-material-library-export-to-excel-and-import-to-project/11030/6 "2017-04-16T03:05:04Z")
> [@truevis](#): > > so make the new RVT’s Material names the same as the old RVT’s Material names. Why not just override material assests using old names that would save time in renaming 😉 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/e/7e868590ed8c7d0948cc5e6c893d5ef18a2193a7.png) > [@truevis](#): > > I’m doubting that all aspects of Materials can be accessed via Dynamo since Autodesk Materials are closed-source. @truevis Almost all the things are accessable in Dynamo 🙂 . Could you start a new thread which one you can’t access so that we can have closer look at it. ---
**Author:** ![Batman86](https://avatars.discourse-cdn.com/v4/letter/b/858c86/32.png) [@Batman86](https://forum.dynamobim.com/u/Batman86)\ **Post date:** [April 17, 2017, 7:32pm UTC](https://forum.dynamobim.com/t/new-material-library-export-to-excel-and-import-to-project/11030/7 "2017-04-17T19:32:34Z")
Thanks everyone, I will have a go at the suggestion you all posted. ---
**Author:** ![Batman86](https://avatars.discourse-cdn.com/v4/letter/b/858c86/32.png) [@Batman86](https://forum.dynamobim.com/u/Batman86)\ **Post date:** [April 18, 2017, 3:22am UTC](https://forum.dynamobim.com/t/new-material-library-export-to-excel-and-import-to-project/11030/8 "2017-04-18T03:22:14Z")
Hi All I have had another look at it today. and its great what has been provided however using dynamo to extract materials from the library is what i want. see images below of the process i want to utilize Dynamo Project with not materials(these materials are not in any project they are from a New Material Library on the server) Step 1 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/4/74f5b8f46dab21b66f94f60e7cd884536c428fb8.png) Step 2 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/5/45cf774b9d3c8c436bacfc5f0126e83069dfc9df.png) Step 3 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/3/13a627e909be88308d036a6ba520adef5882cd38.png) Can this be dynamoed? ---
**Author:** ![PolynineStudio](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/polyninestudio/32/29002_2.png) [@PolynineStudio](https://forum.dynamobim.com/u/PolynineStudio)\ **Post date:** [July 19, 2017, 12:18am UTC](https://forum.dynamobim.com/t/new-material-library-export-to-excel-and-import-to-project/11030/9 "2017-07-19T00:18:24Z")
The Revit API does not allow access to external material libraries. You would have to resort to a clever combination between transferring project standards, copy paste elements with materials assigned, and/or renaming materials.