%  platform  category

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

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

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

 See also: Tip 11913: Simple export of vertex-coordinates from a selected polyline. 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?