Skip to main content

Import from Excel

Import from Excel
Show in Revit

Several Revit applications are running. Choose one:

Attention! The plugin is purchased for the specified version of Revit!
$14.40
Discount system: 0%
Discount system
Name Discount Total value of individual orders Total value of corporate orders
Regular user 0%
3% discount 3% $84 $180
5% discount 5% $120 $360
7% discount 7% $180 $600
10% discount 10% $300 $900
15% discount 15% $360 $1 200
Partners 30%
BIM Consulting 50%
Super VIP 100%
A subscription is your best choice. Find out why!
To use the purchased license, use the Personal Area of the ModPlus software installed on your computer
Excel data visualization and importing data from Excel file to the current Schedule

Icon

mprExcelImport_32x32 mprExcelImport_16x16 mprExcelImport_32x32_dark mprExcelImport_16x16_dark

Related news and articles


Using

The plugin includes two commands:

Import from Excel

mprExcelImport_32x32 mprExcelImport_16x16 mprExcelImport_32x32_dark mprExcelImport_16x16_dark

The main window of the plugin is divided into two parts. In the left part of the window, the list of imported Excel sheets in the current project is displayed. On the right side there are buttons for import management.

1

Each item in the list of imported worksheets contains the following information:

  • Table – corresponds to the name of the view on which the table is drawn
  • View Type – type of view on which the table is drawn
  • Status – the status of the table. Possible values are: Ok, Table update required, The source file is missing, Source sheet is missing or renamed
  • Source file– the name of the Excel file from which the table was imported
  • Source sheet– the name of the sheet that was drawn
  • Consider the scale on the view – option that allows to take into account the scale of the view on which the table is drawn (available for drawing views and legends). If this option is disabled, the table will be redrawn in the view at a scale of 1:1.

Import control buttons

Add – opens a dialog box for adding a new table (see below).

Update… – opens options for updating tables:

  • Update current table – redraws the table selected in the list.
  • Update all outdated tables – redraws all tables that require updating.

Update all tables – redraws all tables in the list.

Replace Source– replace the original Excel file and redraw the table.

Open… – Open source file from which the table was imported, or Open the folder with the source file.

Open source file – open the Excel file from which the table was imported.

Remove link– remove the selected table from the list, but the view on which the table is drawn remains (remove the link to the original Excel file).

Delete – delete a view on which the table selected in the list is drawn.

In the upper right part of the window there is a button that opens the settings window:

2

Thickness of lines – a list of line thickness ratios from Excel with Revit line weights. Valid values are from 1 to 16.

In the lower part of the window, you can choose one of the options for interaction with the drafting view after importing. The following actions are available: Ask, Open, or Do not open.

Add new table

4

In this window, you need to specify from which file and sheet to import the table and into which view it should be inserted (drawn).

In the Import section, select the Excel file by clicking the corresponding button with three dots. After selecting the file, the list of sheets within it will be displayed below. Then, choose the required sheet from the list and specify the Import range: Used cells, Print area, or Custom range.

In the Insertsection, choose whether to create a new view or insert the table into an existing one.

If Create View is selected, you need to specify the view type and name in the fields below. For drafting views and legends, the Consider the scale of the view option is available. When enabled, you can define the scale for the new drafting view or legend.

If the Insert table into existing view is selected, a dropdown list of available drafting views, legends, and Schedules will become active. When a drafting view or legend is selected, its scale is shown in the Scale field. If the Consider the scale of the view option is enabled, the current view scale will be preserved.

When you import a table into an existing drafting view, all data in the view is deleted!

Image processing is available from Revit version 2020 onwards.

Table information is saved to the extended data of the view at the moment of import. After all required settings are configured, click the Insert button to start the import process. The selected sheet will be converted into intermediate data, a new view will be created if necessary, and the table will be drawn using Revit annotation elements.

Tracking changes in real time

At the moment when the main window of the plugin is openly monitoring changes to the source file in real time. As soon as the changes to the source file are saved, in the main window of the plugin for all items in the list referring to the source file, the status:

3

Excel to Schedule

mprExcelToSchedule_32x32 mprExcelToSchedule_16x16 mprExcelToSchedule_32x32_dark mprExcelToSchedule_16x16_dark

5

When the command is launched, a window opens where you need to click the Import button to select an Excel table.

6

In the opened window, select the Excel file by clicking the corresponding button with three dots. After selecting the file, the list of sheets it contains will appear below. Then, choose the required sheet from the list and specify the Import range: Used cells, Print area, or Custom range.

7

At the top of the plugin window, there are options for inserting the table into a schedule:

The row from which to start reading data – specifies the row number in the plugin's table from which data will be read to fill in parameters in the schedule. The number updates when a row is selected in the table.

The Schedule row from which data filling begins – defines the row number in the Revit Schedule (excluding the title and headers) where the data insertion begins. The count starts from 1 and refers to the rows containing parameter values.

The main part of the plugin window displays the Excel data table that will be written into the schedule. Columns can be reordered by dragging them while holding the left mouse button.

If the Write empty values option is enabled and there are empty cells in the plugin table, empty values will be written into the corresponding schedule cells: blank for text parameters and "0" for numeric ones.

Clicking the Fill in Schedule button starts the process of filling ielement parameters with values from the table.

The plugin fills the rows related to the model elements. Rows with intermediate totals are ignored. Therefore, to fill such Schedules correctly, you should use an Excel file with data without intermediate rows. For example:

8

ModPlus YouTube
New
Fixed an error due to which the window with the plugin results could end up behind the Revit window
Fix
Fixed an error that occurred in some cases when importing into a schedule
Improved
Added an explanation about the table size in the "Import from Excel" window
New
Improved the accuracy of importing tables into a view: the column widths now match the sizes displayed in Excel in "Page Layout" mode
New
Added consideration of the sheet print scale ("Adjust to … % normal size"): the table in Revit gets the same size as in "Page Layout" mode
New
The text indent from the cell borders now matches Excel
Improved
The interface was migrated to the current version of the ModPlus styling library
Fix
Fixed an error in which the width of hidden columns was taken into account when importing merged cells
Improved
Added an improvement to the schedule view import algorithm that prevents the appearance of empty rows
Fix
Fixed an error where the screen scale was determined incorrectly
Fix
Fixed an error that occurred when a compound text contained a line break
Fix
Fixed an error that caused slow processing of sheets where cell borders were set to the full width or height of the sheet
Fix
Fixed an error where formatted text was not processed
New
Added a new command "Import to Schedule"
New
Added the ability to insert a table into a legend
New
Added the ability to create pseudo-schedules
New
Added the ability to specify a cell range for import
New
Added the ability to consider view scale when importing into a drafting view or legend
New
Added image processing
New
Added the ability to open the folder with the source file
New
Added the ability to batch update tables
New
Added xlsm file processing
New
Added support for composite text (superscript, subscript, bold, italic, underlined) when importing into a drafting view or legend
Fix
Fixed "Cannot access a disposed object" error occurring when rendering a table
Improved
Made minor improvements to the text width measurement method
New
Prioritize using the cached value when retrieving a cell value
Fix
Added check for falling within the range of acceptable values of width and height of the created text
Improved
Changed icons
Improved
Added command access settings on the ribbon
Improved
Added an option to choose an action after importing a table (to open or not to open the view) to the settings
Improved
Displaying cell read errors after the whole Excel worksheet has been processed
Fix
Fixed an error that occurs in some cases when reading cells with formulas
Improved
Improved algorithm for determining cell width
Fix
Fixed an error reading the contents of some cells
New
Replacement of the main library for reading Excel files
New
Added ability to delete a table without deleting the drafting view
Improved
Consideration of the screen scale when converting cell sizes
Improved
Consideration of the screen scale when converting cell sizes
Improved
Correct display of plugin windows (on top of the Revit window, but not on top of other application windows)
Fix
Ignoring an error when failing to read the color of existing colors in the project
Fix
Removed the use of a static resource dictionary, which in some cases leads to errors when starting plugins
New
Added an option to change the source for an existing table
Improved
Added saving of the last opened folder when selecting an Excel file.
Fix
Improved the accuracy of getting the width of the cells
Fix
Fixed an error that occurs when adding new tables if the color of filled region type created when tables were previously added has a changed fill color
Fix
Added replacement of prohibited characters in the name of the drafting view being created
Fix
Bug fix selection width in the localized value text buttons
FIX
Added capturing and displaying top-level errors
FIX
Added processing of text rotated 90 degrees (only Revit 2019 and higher)
FIX
Fixed error when trying to create text cells that contain only whitespace
FIX
Fixed bug with reading Excel file with number of sheets is less than three in the limited version of the function
FIX
Fixed a fatal error when reading data from a drafting view on computers with the optional designation of the time before noon and afternoon (AM/PM)
FIX
Added update view name when re-open function after rename a view in the project manager
FIX
Fixed error when deleting a table if open only one drafting view
FIX
Fixed an error when searching for a suitable type of the TextNote
FIX
Improved merged cell handling
FIX
Functions rebuilt to work with the format of Open Office Xml (xlsx)
FIX
Removed the settings window. Settings moved to main function window
FIX
Added error handling when converting/building an excel sheet without interrupting the process of the function
FIX
Small bugs fixed
FIX
ModPlusStyle styling
FIX
Fixed the cause of fatal completion of the work of Revit in case of error reading excel file