Skip to main content

Batch attribute block ref. creation from worksheet

NTCL Soft

Batch attribute block ref. creation from worksheet

NTCL Soft

Batch creates AutoCAD® Block instances of multiple types with attributes/dynamic props from an Excel worksheet. Data required for positioning block-ins is also retrieved from the pre-selected range.

$39.99

Autodesk® AutoCAD® attribute block, dynamic block are great; Microsoft® Excel® worksheet autofill is also marvelous. Why don't we combine them?

This app is designed to make use of both of the above great features in one place:

- You can batch-create block references with attributes' content 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 attribute's values.

- You can batch-create block references with dynamic properties' value read from an Excel worksheet. Each worksheet column can be set corresponding to a dynamic property; each worksheet row's text data corresponds to a block reference dynamic property's values.

- Block names can also be read from an Excel column for further mass production improvement. That means multi-block types can be inserted with a single click.

- For further automation, field attributes cloning from an existing block reference to other block references is also supported;

- A sub-option for insertion of block references through all layouts (except Model space) in X, Y positioning mode is available;

Data required for positioning block references in the drawing is also retrieved from the worksheet, the same mechanism as the attribute/ dynamic property, except the data type is numeric. Block references can be positioned in one of the following ways:

  1. Along with a profile view;
  2. By X, Y, and Z coordinate values in WCS;
  3. Along a 2D polyline;
  4. Along with an Autodesk® Civil 3D® alignment (Option (4) is only available in Civil 3D applications).

 

Typical usage scenarios are:

  • Insert structure block refs along profile/ alignment (eg, manhole block, pier/abutment block, culvert block, traffic sign block, tree block...)
  • Insert description/comment block refs for those structures, along with profile/ alignment

Typically, the app works with the World Coordinate System (WCS) and Model space.

If the User Coordinate System (UCS) was used in the model, an implicit transformation to WCS is applied; The App also works in Paper space (Layout) or inside an active Viewport, but in such cases, it is recommended that users should double-check the results before mass production.

 

Notes:

  • 30-day trial available. 30-day Trial requires signing in to the parent Autodesk application with a valid Autodesk ID that did the download. No offline license is provided for the Trial version.
  • This App is also available in the Block App package.  Users can get an additional 30-day Trial.
  • Users can get a free version of this app from here 
  • A paid license is a physical, computer hardware-dependent license. After purchasing, please run this App, open the About... panel, manually copy & send your registration info to NTCL support email NTCLApp1@gmail.com. For more details, please refer to the License Registration Guide.
  • While waiting for a perpetual license file, this App still runs with full functions;
  • 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.
  • Users will get a message if this App is launched from a virtual machine. The app launched from a virtual machine will be limited in features, like the free version.

Mode 3: Block insertion Along polyline

Details

Operating system

win64-platform-icon

Release date

May 6, 2022


Last updated

Jun 7, 2026


Version

2.2.2


Language

English

Compatible with

ACD-icon

ACD

2021, 2022, 2023, 2024, 2025, 2026, 2027

MAP-icon

MAP

2021, 2022, 2023, 2024, 2025, 2026, 2027

CIV3D-icon

CIV3D

2021, 2022, 2023, 2024, 2025, 2026, 2027

ACAD_E-icon

ACAD_E

2021, 2022, 2023, 2024, 2025, 2026, 2027

ADSTPR-icon

ADSTPR

2021, 2022, 2023, 2024, 2025, 2026, 2027

BLDSYS-icon

BLDSYS

2021, 2022, 2023, 2024, 2025, 2026, 2027

Capabilities

Landscaping

Blocks

Interoperability

Tags

Import and export

Scheduling

Road design

Frequently asked questions (FAQs)

  1. If no Excel worksheet is opened before, this app will try to open a blank worksheet. Your input must be copied to this blank worksheet. In case you want to use input values from an existing worksheet, just close the app and the blank worksheet, and pre-open the existing worksheet before running this app.
  2. This app only works with desktop versions of Excel. In case multiple Excel versions are installed, this app may work with the default version.
  3. Users can terminate the app during the Excel interaction process by pressing the ESC key (key press event only works with the App dialog, not with the Excel interface).
  4. Users will get a message if this App package is launched from a virtual machine. The app launched from a virtual machine will be limited in features, like the free version.
  5. When inserting multi-attribute block types at once, it is recommended that those blocks have the same order of the same attributes. Attribute tags are not necessarily to be the same, but attributes of the same contents should be placed in the same order in each block definition. Use the BATTMAN built-in command to arrange attribute order, and click SYNC to update existing block references.
  6. When inserting multiple dynamic block types at once, it is recommended that those blocks have the same dynamic properties. Property names are not necessarily to be the same, but similar properties should be placed in the same order in each block definition. To set dynamic properties in order, input a numeric value to its description in the Block Editor. (Warning: The order column in the parameter manager only affects the display order of dynamic properties in the Properties panel. It cannot be accessed by this App.
  7. When cloning fields from an existing attribute block reference, the source block reference's fields should display properly before, and similar attributes of source & destination block references should be placed in the same order;

1. In some cases, this app cannot connect Excel to Microsoft 365 (Office 365). The NTCL Error message, "Cannot open Microsoft Excel," appears right after the app is called.

This error can be fixed by running "Quick Repair" on Microsoft 365 (Office 365). For more information, please refer to: https://www.NTCLSoft.com/home/troubleshooting

2. Since version 2.1.3, App is installed to %AppData% \Autodesk\ApplicationPlugins folder  instead of  %ProgramData%\Autodesk\ApplicationPlugins folder.  The first session of Autodesk AutoCAD and/or verticals after updating will have to update some registry keys due to path change, The App will NOT work in this session.  Please close and re-open Autodesk AutoCAD and/or verticals.  The app will work properly from the second session onwards.

For questions/comments/suggestions/bug reports, etc, please send an email to NTCLApp1@gmail.com

For more information about the license, please visit: https://www.ntclsoft.com/home/license-registration-guide

Found an issue?

Report a problem