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 52458×

Comments Tell a friend

Prices - CAD eShop:

AutoCAD

applies to: AutoCAD ·

See also:
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.
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?

Selected tip: Clipboard entities are sometimes pasted separately, sometimes as a block.

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:

CAD: OS: Categ:
Text:	FAQ glossary

Featuring:
Extend your AutoCAD LT productivity with our popular add-on
CADstudio LT Extension 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.

	CAD Forum - tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion 360, Forma, 3ds Max and other Autodesk software (support by Arkance Systems) - see About	Arkance Systems CZ s.r.o. (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner	CONTACT: webmaster.cz@arkance-systems.com tel. +420 910 970 111
	Copyright © 2023 \| Advertise with us \| Online privacy

CZ \| EN \| DE
Login or
registration
	Visitors: 7385