Enhanced block info to/from worksheet

Enhanced block info to/from worksheet

Digitally signed app

Bezahlt, Kostenlose 30-Tage-Testversion


Enhanced version can work with multi-drawing files without opening on screen

A two-way (read & write back) lite version of Data extraction command with the help of Excel® Autofill

Best for:

  • Batch filling Title block attributes with the help of AUTOFILL.  No more complicated Sheet set FIELDS are required.
  • Read and update devices status with Multiple Visibility States dynamic blocks.

The typical workflow is Export - Edit - Reimport.

For Multi files processing, it's not necessary to open the drawing on-screen or manually select Excel data range, just add files to the list, fill in parameters per file, then export or import.

For active drawing processing, the drawing should be active, Excel data range should be pre-selected before export or import.

Exported /imported Information includes:

  • Block insertion point (X, Y, Z) & rotation angle (in radian)
  • Block attributes (Visibility state, Block properties table value set are supported)
  • Custom (Dynamic) Properties (Visibility state, Lookup table parameter, Block properties table value set are supported)

 What's new in this App

  • Unlike classic commands (ATTIN, ATTOUT), this app can extract coordinates, and layout names which are useful for sorting block refs.
  • Unlike the new powerful DATAEXTRACTION command, this app can re-import values from worksheets to update existing drawing block refs. Also, exporting/importing procedures are minimized to save time;
  • The enhanced version now supports multi-file processing with jet speed (10x-20x times faster than Free version)

 Typical working scenarios are:

  • Batch numbering, naming, resizing .... title block instances: By using attribute / dynamic blocks as a title block, users can export attributes (drawing number/ name/ title ...), custom properties (paper size, visibility state...)   to Excel.   Editing attributes and/or custom properties... with the help of Excel Data sort & Autofill feature.  Re-import those updated values and the nightmare manual work of incremental numbering or defining complicated sheet set fields are done with ease.
  • Rebuild the drawing list from the existing attribute block (used as drawing title block).
  • Update coordinate attributes of block references: Export block refs' positions, copy new coordinate values X Cad, Y Cad columns to attribute column; re-import from Excel to update.
  • Exported block coordinates can be used for inquiry Station- offset, use Station offset for further sorting/editing.
  • Read, update electrical, hydraulic ... devices status in a network.


1. This app cannot create new block references, just export - edit - reimport to update objects. Block reference objects are recognized by their Handle property (some kind of object ID in a specific drawing).

2. To create a new block from Excel data, users can try this App for free, unlimited time: Batch attribute block ref. creation from worksheet 

3. User can run this App with:

  • (a) A simple signing-in parent Autodesk® application with a valid Autodesk® ID that did the purchase.  In this way, the user can run this App from any computer, provided that an internet connection is available; or
  • (b) An offline license file that is physical computer hardware dependent. After purchasing, please run this App, open the About... panel, and manually copy & send your registration info to the NTCL support email NTCLApp1@gmail.com. For more details, please refer to the License registration Guide.  During waiting for an offline license file, this App still runs with full functions;

4. 30-day Trial requires signing-in parent Autodesk® application with a valid Autodesk® ID that did the download.  No offline license is provided for Trial version.

5. For purchasing volume of 50 or more licenses, assuming that all PCs work in the same local domain network, a specific domain-based license may be distributed instead of an individual license if required and such a domain-based license is technically feasible.

6. Please uncheck "Open drawing before importing" option to improve processing speed when using App for the first time;

7. Users will get a message if this App package is launched from a virtual machine. App launched from a virtual machine will be limited in features.

Informationen zu dieser Version

Version, 23.06.2023
Bugs fixed: - Fix a bug where Multiline attribute text is incorrectly exported/ imported; - Fix a bug when a block has both multi visibility state & Lookup table, new visibility state value may not be applied; - Fix a bug when block instances of different drawing have same Handle and same name, new dynamic properties' values may be wrongly set from second block instance; - Dynamic Block instances that have constraint geometry may display incorrectly after importing new values from Excel Improvements: - Drawing table column widths, check box status, block source are saved on exit and restored on the next App open - Export mode: Add an option to hide attributes of which "Invisible" property is set to False. This option does not apply to multi-visibility-state dynamic block. - Export mode: Add an option to hide dynamic block's custom (dynamic) properties of which "Show" property is set to No. This option does not apply to multi-visibility-state dynamic block. - Export mode: Dynamic property with a list of allowed values will show its list in the column header cell's comment; - Import mode: Support Block properties table (optional) - Import mode: Support Lookup table (optional)

Screenshots und Videos


2 Bewertungen
Technische Hilfe erhalten
  • Awesome App
    Ranjit Singh | Oktober 24, 2023 Geprüfter Download (Was ist das?)

    This App has been a wonderful app to do my weekly job of compyling of any number of dwgs to single or multiple excel sheet, back and forth, fully transferable between both programs. App creator is very helpful and fixes the bugs in no time, if it needs a tweeks as well. Thank you NTCL for your help, using this app since Feb 2023.

    NTCL Main (Herausgeber) | Oktober 25, 2023

    Thank you for your comment. Also I am very grateful for your patience while helping me test and fix the bugs. Programming for AutoCAD dynamic block is really a challenge because of its super wide application that an individual developer cannot imagine. It was you, my customers, who helped me improve the App.

  • Powerful, huge time saver
    Dung Le Van | Februar 14, 2023 Geprüfter Download (Was ist das?)

    Amazing simple solution for batch numbering, naming bunch of drawing title blocks.  It may be much better if online office (like Google Sheet) is supported.

    NTCL Main (Herausgeber) | Februar 22, 2023

    Thank you for your review & suggestion.

Nach oben