CAD tip # 6692:

Question

CAD

% platform category

Simply create points or polyline from coordinates in Excel.

If you need to import a list of coordinates from Excel, generate blocks at computed coordinates, or draw a mathematic curve computed with Excel expressions, you may need the CADstudio Xls2Curve utility.

This tool imports coordinates (XY or XYZ) from a previously selected region in an opened (active) Excel sheet. From these 2D or 3D coordinates, it then creates points (Point), curves (LWPolyline, 3DPolyline), splines or block references (Insert) in your drawing. In the Excel table just mouse-select any contiguous range containing the point coordinates.

An example of import of the results from a mathematic expression describing a lemniscate curve (see the attached XLS sample):

List of coordinates X-Y in Excel

Imported spline curve in AutoCAD

Included is the complementary function Curve2Xls which exports coordinates (XY or XYZ) of curves and points to Excel (the selected cell of the running Excel sheet).

You can download the Xls2Curve utility at Download. The activation of this trial version (limited to 10 points) can be done with the XANADUREG command.

ACADADTMapCivil

*CAD

25.5.2009 61259×

Comments Tell a friend

this tip shared by ARKANCE experts applies to: AutoCAD · AutoCAD Architecture · AutoCAD Map 3D · Civil 3D ·

See also:
Tip 14630:	Extended ASCPOINT - import coordinates from CSV file, including blocks with attributes, GPS coordinates, etc.
Tip 14613:	How to set the elevation of objects according to the value of Object Data, OD? (OD2Z)
Tip 14093:	3D terrain model of any place in Czechia - elevation data by the Czech Land Survey Office (CUZK) into Civil 3D.
Tip 14059:	Import coordinates from CSV files into Fusion profiles.
Tip 13692:	What is the precision in Revit?

Selected tip: How to add own materials to Inventor catalog?

Back All CAD Tips

What is the maximum number of vertices in AutoCAD polylines? « | » Switching Display configurations from command line.

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:

Text:

FAQ

Featuring:
Increase your productivity with our set of add-on functions for Autodesk Inventor
Be.Smart T4I

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

CADforum

Tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion, Forma, 3ds Max and other Autodesk software (community support by ARKANCE). See About CADforum.

ARKANCE CZ (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner

CONTACT:
webmaster.cz@arkance.world | tel. +420 910 970 111



Visitors now: 8217