CAD tip # 8030:

Question

CAD

% platform category

Click2XLS - click points to export from AutoCAD to Excel.

With the free AutoCAD add-on utility CADstudio Click2XLS you can automatically export all "clicked" coordinates to an Excel table.

Download Click2XLS from Download, load it with APPLOAD and start the CLICK2XLS command.

This either creates a new Excel table or connects to an existing (opened) table at the selected cell. Any clicked points will be then copied over to individual rows in the Excel sheet.

This video shows how it works:

Since version 1.4, Click2XLS also contains the Text2XLS command which transfers picked drawing texts to Excel (supports any text entities except table cells written in a TrueType font).

Since version 1.5 you can insert blank lines (the option "Blank") to the XLS table.

Since version 1.7 you can toggle between the row and column insertion modes for coordinates.

See also the XLS2Curve utility and Click2OO (for OpenOffice Calc).

Click2XLS and many other freeware tools are available on www.cadstudio.cz, other CAD videos on CADstudio's YouTube channel.

ACAD

*CAD

9.6.2011 60697×

Comments Tell a friend

Prices - CAD eShop:

AutoCAD

applies to: AutoCAD ·

See also:
Tip 14304:	How to generate a report of used blocks including their visibility status in AutoCAD LT?
Tip 14059:	Import coordinates from CSV files into Fusion profiles.
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.

Selected tip: How to add new parameters to the Revit project information list?

Back All CAD Tips

How to remove styles in a pasted Table? « | » AutoCAD 2011 doesn't display documentation views from ACAD 2012.

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:

Text:

FAQ

Featuring:
Use Google Earth images in your AutoCAD projects with the Plex.Earth Tools

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

CADforum

Tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion, Forma, 3ds Max and other Autodesk software (support by ARKANCE).

ARKANCE CZ (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner

CONTACT:
webmaster.cz@arkance.world | tel. +420 910 970 111