Block references to/ from Excel® worksheet package

Block references to/ from Excel® worksheet package

Digitally signed app

A, M


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.

Acerca de esta versión

Versión 2.0.15, 09/09/2023
Bugs fixed: (a) Batch export/import block info to/from worksheet sub-App: - 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: (a) Batch export/import block info to/from worksheet sub-App: - 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)

Capturas de pantalla y vídeos

Reseñas de clientes

0 reseña
Obtener ayuda técnica
Ir arriba