ScheduleLink is a free Autodesk Revit add-in from IB-BIM that creates a round-trip connection between Revit schedules and Microsoft Excel. It allows users to export Revit schedules to professionally formatted Excel workbooks, edit schedule values in Excel, and import the changes back into Revit so that the underlying Revit elements are updated directly.
Purpose and Design Intent
The add-in is designed for Revit users who prefer to review, edit, and coordinate schedule data in Excel while still keeping the Revit model as the source of truth. Instead of manually changing many parameter values inside Revit schedules, users can use Excel’s familiar editing environment for bulk changes, then use ScheduleLink to validate and synchronize those edits back to model elements.
Core Workflow
ScheduleLink works through a simple export-edit-import process. Users launch the tool from an open Revit project, choose any schedule from the project list, preview the schedule parameters with color-coded editability indicators, export the schedule to Excel, make edits in the workbook, and then import the modified file back into Revit. During import, the add-in checks the workbook, applies only changed values, and provides a detailed results summary.
Key Features
- Exports Revit schedules to Excel with a WYSIWYG approach so the workbook reflects the schedule’s sorting, grouping, filters, and column order.
- Allows users to pick from all schedules in the current project without opening the schedule view first.
- Includes fast dynamic search for locating schedules by name.
- Displays a parameter preview with color-coded columns that indicate editable, type, calculated, and read-only fields.
- Imports modified Excel data back into Revit and updates only values that changed.
- Uses smart pre-checks to detect whether the Excel file contains changes before beginning import.
- Provides project validation to help prevent importing data into the wrong Revit project.
- Includes detailed import progress, error reporting, and copy-to-clipboard results.
- Supports full undo behavior by applying imports in a single Revit transaction.
- Includes right-to-left language support for Hebrew, Arabic, and other RTL languages.
Excel Export Behavior
Each exported workbook includes a formatted Excel schedule and an Instructions sheet. The Instructions sheet explains the color legend, editing rules, column mapping, project information, schedule name, schedule ID, export date, and Revit version. Exported files include auto-filtered headers and frozen panes to make review and editing easier.
The add-in also exports hidden Element ID data used to match edited Excel rows back to the correct Revit elements during import. Because rows are matched by Element ID rather than by spreadsheet position, users can sort or reorder rows in Excel without breaking the import process. However, users should not add, remove, or rearrange columns because the original column structure is required for synchronization.
Supported Schedule Types and Parameters
ScheduleLink supports common Revit schedule types including element schedules, room schedules, door schedules, equipment schedules, sheet lists, view lists, material takeoffs, and custom schedules. It can work with instance parameters, type parameters, calculated fields, system parameters, and special fields such as Sheet Number. Editable parameters can be changed through Excel import, while read-only or calculated values are exported for reference only.
Data Validation and Import Safeguards
ScheduleLink emphasizes safe round-trip editing. Before import, it verifies that the Excel file belongs to the correct Revit project and checks whether the workbook actually contains changes. During import, it updates only modified values and reports updated, unchanged, skipped, or failed items. If a read-only column is changed in Excel, the change is ignored and reported as skipped. If a row is deleted, the corresponding Revit element remains unchanged; if a new row is added, it is ignored because the tool only updates existing elements identified by Element ID.
Sheet numbers receive special handling because Revit requires sheet numbers to be unique. ScheduleLink uses duplicate detection and a two-pass approach to reduce conflicts when sheet numbers are renamed. If duplicate sheet numbers are found in the Excel file, the add-in detects the problem and helps prevent invalid updates from being applied.
Error Handling and Reliability
The add-in includes several reliability features intended to reduce common export and import problems. If a selected save location fails because of a cloud-sync issue, locked file, or restricted folder, ScheduleLink can prompt the user to choose another location. If the Excel file is open in another application, the add-in includes a retry mechanism. It also provides import progress tracking and detailed error results to help users troubleshoot unsuccessful rows without canceling the entire operation.
Workflow Benefits
- Speeds up bulk schedule editing by allowing users to work in Excel.
- Reduces repetitive manual parameter entry inside Revit.
- Maintains a controlled connection between schedule rows and Revit elements through Element IDs.
- Improves review clarity with formatted Excel output, color-coded columns, filters, and frozen panes.
- Helps prevent accidental wrong-project imports through validation.
- Supports safer sheet list management with duplicate sheet number detection.
- Allows imports to be undone in Revit with a single undo operation.
- Improves coordination between BIM managers, project teams, and spreadsheet-based reviewers.
Best-Fit Users and Use Cases
ScheduleLink is best suited for BIM coordinators, BIM managers, architects, engineers, Revit production teams, project administrators, and anyone who frequently works with schedule-based model data. Typical use cases include editing room data, updating door or equipment parameters, managing sheet lists, reviewing view lists, coordinating material takeoffs, cleaning custom schedules, and making controlled bulk updates to model parameter values.
Overall Assessment
Overall, ScheduleLink is a focused and practical Revit productivity add-in for teams that rely heavily on schedules and Excel-based review workflows. Its strength is not just exporting schedule data, but allowing validated round-trip editing back into Revit elements. For BIM teams, it can reduce manual data-entry time, improve schedule coordination, support safer bulk edits, and make schedule-based model management more accessible to users who are comfortable working in Excel.
Advertisement
No comments:
Post a Comment