The steps of importing coordinate data from excel into CAD and generating corresponding points are as follows:

First, we open the EXCEL software, and then open the coordinates that we want to import into CAD.

Secondly, then we click on the first empty cell in columns X and Y, which is cell C2, and then we enter the formula = A2 &；; & ampB2, we can change the XY coordinates into the format we need.

Third, then we use the mouse to drag the lower right corner of C2 cell to the bottom line.

Fourth, then we replicate with cells. After the copy is completed, we can check the correctness of the copy.

5. Then we select all the cells in the X and Y coordinates of column C in excle, and then press CTRL+C to copy. Then we switch the page to CAD and paste it.