CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor and other Autodesk products [www.cadforum.cz]
Cesky English Deutsch
Login/Register:
 Visitors: 3253 

CAD tip CAD tip # 9743:

Question CAD 
 %  platform  category 
Q - question

How to use XY coordinates from Excel as polyline vertices in AutoCAD?

A - answer If you need to draw a curve in AutoCAD (and especially in AutoCAD LT where you cannot use add-ons), defined by X-Y coordinates from a measurement or calculated from a math function, you can use copying from Excel.

But you cannot use a plain copy/paste as AutoCAD expects XY coordinates delimited by comma and a dot "." as the decimal separator (Excel uses comma in some European localizations). So you need to first concatenate the Excel columns containing the X-coordinate and Y-coordinate to a single value. Use string concatenation and the function "SUBSTITUTE" (WECHSELN in German, SUBSTITUE in French, SOSTITUISCI in Italian, SUSTITUIR in Spanish, SUBSTITUEREN in Dutch, PODSTAW in Polish, ПОДСТАВИТЬ in Russian) if needed to replace commas with dots. So e.g. to combine the A and B columns on the second row, the function will look so:

=SUBSTITUTE(A2;",";".")&","&SUBSTITUTE(B2;",";".")

or just:

=A2&","&B2

Parabola

If the decimal comma replacement is not needed and if the list separator defined in your Windows localization is a comma (not semicolon), you can also use the CSV export from Excel to get a proper list of XY coordinates for AutoCAD.

Then just select the newly created column in Excel from the first to the last used row, press Ctrl+C and in AutoCAD paste this data using mouse right-click on the prompt for entering vertex coordinate in the started command PLINE.

You can use this procedure to draw any math curve/function (parabola, sinusoid...) or otherwise acquired XY values, both in AutoCAD and in AutoCAD LT. In the full AutoCAD version you can also draw functions with 2DPLOT or more conveniently by transferring Excel data with Xls2Curve (see).

ACADLT
100% *  CAD 
18.3.2014    10964x  
Comments   Tell a friend
applies to: AutoCAD · AutoCAD LT ·

See also:
Tip 11076:Reading 3D point matrix from a CSV file.
Tip 10709:How to create a profile from imported XYZ points in Fusion 360?
Tip 10231:How to draw spiral in AutoCAD LT?
Tip 9788:How to import named workpoints from Excel to Inventor?
Tip 9594:Click2OO - export of AutoCAD coordinates to OpenOffice Calc.


Back   All CAD Tips All CAD tips&tricks

The option "Open Express" is grayed for an Inventor assembly. « | » How to disable NS at component annotations in Plant ISO?

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   



Featuring:
Generate hatch patterns automatically from your DWG drawings with
HGEN 2006 More info


Please use these tips at your own risk.
CAD Studio (Xanadu) is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist