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: 3954

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 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    7006×   FAQ  

See also:
Tip 13296:How to correctly load a KML/KMZ file into Civil or Map 3D?
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.


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:
Use Google Earth images in your AutoCAD projects with the Plex.Earth Tools More info


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