CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
CZ | EN | DE
Login or
  Visitors: 5558

CAD tip CAD tip # 9320:

Question CAD 
 %  platform  category 
Q - question

Export of Inventor 3D sketch coordinates to Excel.

A - answer With the Inventor VBA macro Export3Dsketch you can easily export endpoint coordinates of line segments of the selected 3D sketch. The resulting file with XYZ coordinates (CSV) can be opened in Excel or in other spreadsheet application.

You can download the IVB file Export3Dsketch from Download. Load it into Inventor as a project in the VBA Editor. Then run the macro with the keyboard shortcut Alt+F8. You can choose between relative (sketch origin recalculated to 0,0,0) and absolute coordinates. The exported CSV file is named after the original IPT or IAM file and it is saved to the same folder.

The individual steps are illustrated in a video which can be found in the CAD Video section - see:

Inventor video #82

Export/generate 3D sketch coords

or on the CAD Studio's YouTube channel:

100% *  CAD 
27.6.2013    22145×  
Prices - CAD eShop:
applies to: Inventor 2014 · Inventor 2013 ·

See also:
Tip 13719:How to load a 2D DWG drawing of a part into Fusion 360?
Tip 13197:How to transfer a model or sketch parameter to iProperties?
Tip 13173:How to convert projection of a 3D model to a 2D DXF drawing?
Tip 12830:Converting pseudo-tables consisting of lines and texts to TABLE objects in AutoCAD DWGs.
Tip 12416:How to export DXF outline of unfolded sheetmetal in Fusion 360, with no bending lines.

Back   All CAD Tips

Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   

Save your floating licenses (NLS) consumed by inactive users - free unused licenses with
LogOff 2006 More info

Please use these tips at your own risk.
Arkance Systems is not responsible for possible problems that may occur as a result of using any of these tips.