Skip to main content

Block references to/ from Excel® worksheet package

NTCL Soft

Block references to/ from Excel® worksheet package

NTCL Soft

AutoCAD® Block ↔ Excel® data exchange, batch Block attribute creation, alignment station offset inquiry, finding & numbering intersections of 2 groups, & Multi files advanced Batch Plot 6-in-1 App.

$4.99/month

July promotion: Buy the App Section view Quantity Take-Off tool and get a free one-year subscription of Block references to/ from Excel® worksheet package App.  Offer valid until Aug 8th, 2026

*

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

The package combines 6 apps with some enhanced features that 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. Support Multiple Visibility States dynamic blocks, which may be useful for managing devices' status in a device circuit. Field attributes export/import is also supported.

Quick intro video

Detailed instruction

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

Quick intro video

Detailed instruction

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.

Quick intro video

Detailed instruction

4. 2-group intersection with order: Create and assign numbers to intersections between 2 groups of polylines/lines/splines. Insert block/point/text objects at intersections. Export results to Excel worksheet.

Quick intro video

Detailed instruction

5. Advanced Batch Plot: Plot/print multi-drawings, multi-layouts, and multi-sheets per layout. The printing configuration of each drawing is automatically saved. Sheets may be auto-combined into one PDF file with bookmarks. Auto turn on/turn off PaperSpace viewports. It auto-ignores null content sheets. Read the sheet list from Autodesk® AutoCAD® .DST and .DSD files.

Quick intro video

Detailed instruction

6. More block utilities:

- A batch dynamic block converter: Convert dynamic blocks of multi-drawings to static blocks. This tool may help users to protect precious, complicated dynamic blocks from unauthorized copies.

Detailed instruction

- An advanced version of the Block replace tool: Blocks with attributes and dynamic (custom) properties are replaced properly without errors. Attributes, fields, and custom properties of old blocks can be retained. Only support active drawing.

Detailed instruction

- A tool for copying entities across multiple layouts: Overlapping entities at destination layouts may be erased at will. Only support active drawing.

Detailed instruction

 

Notes:

  1. For more information about how to use every single app in the package, please refer to the NTCL Soft website or NTCL published apps
  2. Users can use this app package with:
    • (a) A simple signing-in parent Autodesk application with a valid Autodesk ID that made 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 dependent on physical computer hardware. 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.
  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 the paid package app. Please manually uninstall a single app version if necessary.
  7. The app launched from a virtual machine will limit some features. Users will get a message if this app is launched from a virtual machine.

No more complicated Sheet set fields - AutoFill will cover that incremental numbering works for you

Details

Operating system

win64-platform-icon

Release date

Sep 8, 2022


Last updated

Jul 8, 2026


Version

2.2.3


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

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 within the app dialog. The ESC key cannot terminate the app if the key-pressed action occurs in the Excel interface.
  4. The single app version can still work with the paid package app. Please manually uninstall a single app version if necessary.
  5. The app launched from a virtual machine will limit some features. Users will get a message if this app is launched from a virtual machine.
  6. Since version 2.1.3, the app is installed to the %AppData%\Autodesk\ApplicationPlugins folder instead of the %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 changes; the app will NOT work in this session. Please close and reopen Autodesk® AutoCAD® and/or verticals. The app will work properly from the second session onwards.

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. The Excel OLE table is printed with a black background and white text in AutoCAD 2022. To avoid this, update to AutoCAD 2022 ver. 1.1 or later.

3. Some third-party virtual printers may not be compatible with some versions of AutoCAD. A crash occurred when trying to initialize the ProgeCAD® 2022 virtual printer in Civil 3D® 2016

4. During batch plot, when trying to open newer-version drawing(s) in an older version of AutoCAD/AutoCAD verticals, a message box "This drawing was created with a newer version of..." may appear and require the user to manually interact.

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