Block references to/ from Excel® worksheet package

Block references to/ from Excel® worksheet package

Digitally signed app

月, 年


The ultimate package for batch processing Block references with the assistance of Microsoft® Excel® AutoFill.

The package combines three NTCL-published apps with some enhanced features which are not available in the free version:

1. Enhanced Block info to/from the worksheet: 2-way (Read-Write) version of the classic Data Extraction command. Multi blocks per drawing\ multi drawings' info can be exported to just one worksheet, under a unique header row. Best for batch filling Title block attributes with the help of AUTOFILL.  No more complicated Sheet set FIELDS are required. Support Multiple Visibility States dynamic blocks

2. Batch attribute block ref. creation from the worksheet: The app can fill up to 12 block attributes, 12 dynamic properties, and clone fields after block reference creation, work with Autodesk® Civil 3D® alignment, deal with alignment station equations,  and possibly ignore hidden rows in Excel.

3. Alignment of SONE to worksheet: The app is now able to deal with station equation(s), and an option for blank columns is inserted automatically, the app can be terminated during processing with the ESC key.


Autodesk® AutoCAD® block is great, and the Excel worksheet autofill is also marvelous. Why don't we combine them?

NTLC Soft apps are designed to use both of these great features in one place. With our package, you can:

  1. Batch creates block references with attributes/dynamic properties read from an Excel worksheet. Each worksheet column can be set corresponding to an attribute tag; each worksheet row text data corresponds to a block reference attributes values.
  2. Batch query existing block references position, attributes, and dynamic properties from one or multi drawings; edit in Excel and then re-import those edited values into AutoCAD.
  3. Additional utilities: Batch query Civil 3D alignment station, offset/northing, easting, bearing values; Reverse 2D polyline direction.


The typical workflow is:

 Draft works:

  • Prepare a list of structures with positional data, descriptions, and comments in Excel.
  • Batch creates attribute block references from Excel.

 Refined works:

  • Manually edit block references in AutoCAD if necessary;
  • Batch export block references' attributes, and positional data to Excel;
  • Convert coordinates value to the station, offset, and vice-versa if necessary;
  • Edit attributes, positional data, and dynamic properties in Excel if necessary;
  • Update existing block references with data from Excel;



  1. For more information about how to use every single app in the package, please refer to NTCL Soft website or NTCL published apps
  2. User can use this App package 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 package from any computer, provided that an internet connection is available; or
    • (b) An offline license file, which 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 For more details, please refer to the License registration Guide.
  3. While waiting for a new/renewed license file, this app still runs with full functions.
  4. Renew subscription: For a renewed license purchase, a signing-in Autodesk account is required until an offline license file is sent to the user.
  5. For purchasing a 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. The single app version can still work with Paid package App. Please manually uninstall a single app version if necessary.
  7. App launched from a virtual machine will limit some features. Users will get a message if this app is launched from a virtual machine.


版本 2.0.10, 2023/3/28
Bugs fixed: (a) Batch export/import block info to/from worksheet sub-App: - Multi-file processing option cannot export data to Excel if Excel is in edit mode - Unexpected exporting result in single sheet mode if 3 or more different blocks with different field (attribute, dynamic property) names are exported - Unexpected exporting result when the first block has more fields than the second block - App won't work if Excel is closed after App is opened - Wrong number of Block refs. processed when importing - "Load Active Workbook" button discards unsaved content of the opening workbook which was saved to disk before - Esc key cannot terminate export/ import action, user click yes then the action still continues - When imported from Excel, dynamic block references of the second drawing onwards are reset or got wrong dynamic properties - Reload last state button does not work properly - Single file processing mode does not filter block references properly - Attribute values are sometimes changed accidentally because of Excel auto-format. - Confused license status report when signing-in to parent application & running App without an offline license file. Improvements: (a) Batch export/import block info to/from worksheet sub-App: - Add an option "Uni Header": Combine all fields of all blocks from all drawings into a unique header row (nearly the same as the Data Extraction command result) - Allow user to export data from multi-block per one drawing - Better support Multi visibility state dynamic block: invisible attributes in a specific state won't be exported or imported. - Mtext attribute now export value without format code - Add 2 commands: Load and Save configuration to the context menu which appears when right click inside tables - Allow user to set value for some selected cells in Block name or Source column (Ctrl+Click to select cells, Right click in the last selected cell) - App starts with Multi file processing mode (b) Batch attribute block ref. creation from worksheet sub-App - Mode 2 Batch creating block references at coordinates: Z coordinate can be retrieved from the Excel column


0 评论