Sunday, December 22, 2019

Free Import/Export Excel v20.0.1

From the Autodesk App Store:

About This Version

Version 20.0.1, 12/17/2019
  • Corrections made
    • Export
      • Improved export speed when using multiple ”room” settings
      • View shared parameter values
      • Display parameter values for  “space” and “project”.
      • Sorts on multiple parameters when exporting
    • Import
      • Importing "integer" and "boolean" values
      • Importing shared parameter values

  • Improvements made
    • Export of schedule of sheets
    • Improved visual display of tables in Excel.
    • Adding the grand total at the end of the table


The Import/Export Excel allows you to synchronize data back and forth between Autodesk® Revit® and Excel. It also means you can alleviate the data management process by delegating tasks related to the model to team members that don’t use the model. You can export schedules as well as Revit standards to manage them in Excel. Once modified, you import the data back to Revit and your schedules or standards are going to be updated.

  • Data management without managing the 3D model
  • Better segregation of duties
  • Reduced training costs on BIM software's

Documentation can be found here




Read only and type parameters:
Some parameters in Revit are considered as “read-only” when their value is controlled by the Revit engine. You won’t be able to modify this kind of parameters even you modify it in the Excel file because you aren’t allowed to write in those parameters. Type parameters are one in a kind parameters too. If we modify them, we modify all the instances of that type. For that matter, type parameter modifications are not supported by our application. Read only parameters and type parameters are colored in light gray when exporting to Excel so you can distinguish them from the rest.

Importing Issue:
It is mandatory to use the Export feature at first and let the add-in generate its own fields. Importing a man-made Excel file will not work as Revit will only answer to a specific structure of data. Once the file has been exported, you can only modify existing data in the fields generated during the export. Adding lines/columns will not work as they won't be recognized by Revit. However, you can fill-in empty fields as long as they belong to a line/column that was generated by the export tool.

Read Help Document

Import/Export Excel is brought to you by Virtual construction and technology BIM One Inc. It's free.

This add-in is compatible with Revit 2020, 2019, 2018, and 2017.

Download from the Autodesk App Store »

Questions? Contact the developer »

No comments: