# import in excel or spreadsheets

**URL:** <https://discourse.shapr3d.com/t/import-in-excel-or-spreadsheets/31615>\
**Category:** Modeling Questions\
**Created:** [April 30, 2024, 3:41pm UTC](https://discourse.shapr3d.com/t/import-in-excel-or-spreadsheets/31615 "2024-04-30T15:41:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![J.StudioCoert](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@J.StudioCoert](https://discourse.shapr3d.com/u/J.StudioCoert)\
**Post date:** [April 30, 2024, 3:41pm UTC](https://discourse.shapr3d.com/t/import-in-excel-or-spreadsheets/31615/1 "2024-04-30T15:41:33Z")

</div>

Hi There, does anyone knows a workarround to get a BoM.  
Like exporting a file an importing them in Spreadsheets or something like that?  
It’s starting to get a little frustrating, I’d like to be able to export data and go from there. So ik can create my own BoM or cut list. Or maybe a way to copy the layer structure as text.

---

<div class="post-metadata">

**Author:** ![APDesignMachine](https://avatars.discourse-cdn.com/v4/letter/a/e495f1/32.png) [@APDesignMachine](https://discourse.shapr3d.com/u/APDesignMachine)\
**Post date:** [April 30, 2024, 5:26pm UTC](https://discourse.shapr3d.com/t/import-in-excel-or-spreadsheets/31615/2 "2024-04-30T17:26:31Z")

</div>

Not that I’m aware of unless done from the very beginning. Like having a folder for a specific screw size and length and starting with one and having the numbered copies give you a total after. That would be the easiest way to have it set up now.

I keep hardware folders for sub-assemblies, but will still have to total everything after the fact.

Unfortunately without having an importable hardware library like in SW there’s no way to keep track of it currently. Perhaps start a feature request to include say McMaster Carr’s hardware library as a plugin (assuming they don’t have an exclusive contract with SW). That’s where I import 98% of my hardware models from.

---

<div class="post-metadata">

**Author:** ![Cjacob](https://avatars.discourse-cdn.com/v4/letter/c/51bf81/32.png) [@Cjacob](https://discourse.shapr3d.com/u/Cjacob)\
**Post date:** [April 30, 2024, 11:17pm UTC](https://discourse.shapr3d.com/t/import-in-excel-or-spreadsheets/31615/3 "2024-04-30T23:17:17Z")

</div>

Hello J.StudioCoert,

As a workaround, I export the drawing in Step and reopen in Viacad 3D. Select all, tools and attributes and BOM.

Attached is the sample.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/shapr3d/original/3X/a/d/ad1c3f3297be7e818a05cec3793af7d433df2d7b.jpeg)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/shapr3d/original/3X/6/7/67c656832e3d58815f3aeed65334ed1c6ce31399.jpeg)