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

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:


or just:



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).

100% *  CAD 
18.3.2014    37528×  
Prices - CAD eShop:
applies to: AutoCAD · AutoCAD LT ·

See also:
Tip 13784:Export block coordinates to a table. How to use the DATAEXTRACTION command in AutoCAD LT?
Tip 12926:How to import point coordinates from Excel to AutoCAD?
Tip 11913:Simple export of vertex-coordinates from a selected polyline.
Tip 11076:Reading and displaying 3D point matrix from a CSV file.
Tip 10709:How to create a profile from imported XYZ points in Fusion 360?

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   

DwgTextTranslator translates a series of drawings from one language to another using MS Access.
Download a fully functional trial version.

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.