topic Re: Export BOM/Parts List to excel or other format in Fusion Design, Validate & Document Forum

Export BOM/Parts List to excel or other format

Aaron.Magnin — Thu, 24 Mar 2016 16:41:52 GMT

In order to get BOM and Parts Lists into ERP and other systems, it would be helpful to be able to export those directly from a Fusion drawing.

Currently, you can do this by exporting the entire drawing to DWG, then using "TABLEEXPORT" in AutoCAD to get it to a CSV file, but its a bit of extra work.

For those of you trying to do this now, here are some steps:

1. Export to DWG

2. TABLEEXPORT from AutoCAD

3. CSV to Excel (or other spreadsheet software)

Re: Export BOM/Parts List to excel or other format

Anonymous — Tue, 29 Mar 2016 22:01:38 GMT

That is a great solution however I do not own Autocad. I would vote for direct export.

Re: Export BOM/Parts List to excel or other format

Aaron.Magnin — Tue, 29 Mar 2016 22:05:13 GMT

@Anonymous So someone on YouTube mentioned they were able to do something similar with a pdf. I had trouble using that method, but it may help you.

Re: Export BOM/Parts List to excel or other format

schneik-adsk — Fri, 01 Apr 2016 16:13:39 GMT

I have a basic addin to do this here: https://github.com/schneik80/BOM-Export

Re: Export BOM/Parts List to excel or other format - Status changed to: Solution Provided

TimeraAutodesk — Wed, 06 Apr 2016 17:31:07 GMT

Re: Export BOM/Parts List to excel or other format - Status changed to: Solution

Anonymous — Tue, 25 Oct 2016 16:19:47 GMT

Are you referring to the export to DWG as the final solution provided? If so, that really is not a viable solution at all for many MANY users

Re: Export BOM/Parts List to excel or other format - Status changed to: Solution

TimeraAutodesk — Thu, 27 Oct 2016 21:17:27 GMT

@Anonymous, what @Aaron.Magnin has noted here is a complicated workaround... we know that you need the ability to export your Parts List directly from the Drawings environment into an excel-friendly format, and we've been working on it. In the early-November update coming soon, you'll be able to export a .csv of your Parts Lists (along with some other pretty exciting new features), so stay tuned! For more info on what we're working on and what our roadmap for Fusion Drawings is, check out our latest blog post here: http://www.autodesk.com/products/fusion-360/blog/2d-drawings-check-roadmap/

-Timera

Re: Export BOM/Parts List to excel or other format - Status changed to: Solution

Anonymous — Wed, 21 Jun 2017 16:23:52 GMT

So is this feature available now? I can't find it... Can i export the Parts List into CSV ro similar format?

Thanks

Re: Export BOM/Parts List to excel or other format - Status changed to: Solution

TimeraAutodesk — Wed, 21 Jun 2017 16:28:45 GMT

@Anonymous Yes, from the Output menu, select the CSV option, and then choose which table or parts list on a sheet you want exported.

Re: Export BOM/Parts List to excel or other format - Status changed to: Solution

Anonymous — Fri, 09 Oct 2020 03:13:55 GMT

Where is the output button now? I cannot find it anywhere... Or is there an alternate method?

Re: Export BOM/Parts List to excel or other format

espablo — Mon, 18 Mar 2024 19:48:36 GMT

If you are looking for a program that creates a BOM and saves it to an Excel file, you can download such a program from this website and use it for free

https://espablo.pl/download.php?project=bom-excel