CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 4133

CAD tip CAD tip # 12926:

   
Question CAD 
 %  platform  category 
Q - question

How to import point coordinates from Excel to AutoCAD?

A - answer One of the most frequent questions when processing data in AutoCAD concerns the possibility of reading a list of coordinates from a text file into the form of points, blocks or polyline vertices in an AutoCAD DWG drawing.

While there are several ways to accomplish such task in the full AutoCAD (see e.g. the Import points utility, the LISP utility ASCPoint, XLS2Curve, CSV2Pts, etc.), AutoCAD LT users have had to rely on manual script file creation until now.

Even for them, a simple MS Excel add-in is now available that allows you to import a list of coordinates from an Excel XLS table - e.g., loaded from a CSV file, a database, a web service, a text file, or calculated by formulas directly in Excel.

Download the freeware utility by Arkance Systems (CAD Studio) - CADexcel - from the www.cadstudio.cz/download page and run its EXE installer. This will add a new "Arkance" ribbon with an "Export coords" tab to your Excel environment (MS Office versions 2007, 2010, 2013, 2016, 365 are supported). There you will find the "Export points", "Export Polyline" and "Export Blocks" functions. Using them, you can easily transfer coordinates from selected cells (select area) or columns (select columns or specify them by number or "By headings") to the script file .scr. Then just drag this file with your mouse into the AutoCAD or AutoCAD LT window, or run it in the AutoCAD environment using the _SCRIPT command.

The add-in takes care of correct formatting, decimal separators and other script file details. When importing blocks, you need to ensure that a block with the specified name already exists in the target drawing (or folder).

CADexcel is also included (together with other tools, e.g. Point export) in the bonus add-on application for AutoCAD LT - CS LT Extension.

Example of using the CADexcel tool:

The add-on is digitally signed and after installation it is automatically updated from the cadforum.cz/download service using the standard .vsto mechanism.

ACADACLTCivilMapADT
100% *  CAD 
16.4.2021    665×   FAQ  

See also:
Tip 12198:How to remove duplicate points and COGO points from a DWG?
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?
Tip 10167:Keyboard shortcuts in Autodesk Fusion 360.
Tip 9788:How to import named workpoints from Excel to Inventor?


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   



Featuring:
Export 3D VRML scenes from AutoCAD and Inventor
VRMLout More info


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