OS:
Language:

Description

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.

 

Benefits 

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

 

Documentation can be found here

French: http://bimone.com/userguide/Import-Export%20Excel%20-%20Guide%20Utilisateur.pdf

English: http://bimone.com/userguide/Import-Export%20Excel%20-%20User%20Guide.pdf

 

ADD-IN LIMITATIONS

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

About This Version

Version 17.0.1, 12/15/2016
Fixed the unit conversion issue

Screenshots and Videos


Customer Reviews

(31 reviews)

|

Get Technical Help
  • Not export information in schedule
    osahon umweni | March 13, 2017 Verified Download (What's this?)

    I have tried it and guess it misses out many information. I created shared parameters. exported to excel and all it showed was just the families and no information on the shared parameters as seen on the schedule.


  • Great App!
    ROBERT THOMPSON | December 30, 2016 Verified Download (What's this?)

    Just did a quick check on capabilities - does exactly what i want! Seems like you can import/export schedules and standards. both are slick and allow you to choose betw export to multiple single files or mult sheets in a single file. Import is also slick like that. Works seamlessly!


    osahon umweni | March 13, 2017

    I have tried it and guess it misses out many information. I created shared parameters. exported to excel and all it showed was just the families and no information on the shared parameters as seen on the schedule.


  • Import Does Not Work in Revit 2017
    Craig Boersen | December 14, 2016 Verified Download (What's this?)

    When importing into Revit 2017 it asks for you to select a worksheet(s) but does not give anyway of doing so.


    Nondo-Jacob Sikazwe | February 21, 2017

    Ya had the same problem but tried to export the file first it seemed to work


    BIM One Support | February 28, 2017

    Hi Craig, 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. Thanks for the feedback!


  • Import Doesn't work
    Kliton Shehu | November 16, 2016 Verified Download (What's this?)

    Pop-up message says please select worksheets to import, not worksheets to select are provided.


    BIM One Support | February 28, 2017

    Hi Kliton, 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. Thanks for the feedback!


  • Very Good Tool if...
    Mohd Azizul Hakim Rahimi | October 13, 2016 Verified Download (What's this?)

    Hi, I wonder if this tool can also export Calculated Value Parameter and the table sorting just exactly like what we have setup in Revit. But still a very good tool


    BIM One Support | February 28, 2017

    Hi Mohd, Unfortunately our addin has a limitation with calculated values. We'll consider this problem for a future update. As for the sorting, this has to be adjusted within the Excel file itself using the built-in features. Thanks for the feedback.


  • Just Works!
    Nauman BIMOLOGIST | October 05, 2016 Verified Download (What's this?)

    Awesome tool for free. Saved me hours of work. the only part I don't like is that it does not retain revit schedule sort order


  • import doesn't work
    Asmus Kemmann | August 22, 2016 Verified Download (What's this?)

    Import doesn't work. sheets can't be choosen after giving path.


    Ki Fung Li | October 06, 2016

    same here


    BIM One Support | February 28, 2017

    Hi Asmus & Ki, 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. Thanks for the feedback!


  • Constantly crashes program
    Kevin Desrouilleres | August 04, 2016 Verified Download (What's this?)

    Downloaded this file based upon the reviews read here but I have not been fortunate as some have posted. A worksheet is not available to select once you select the file and to make matters worse, every attempt to import a schedule from Excel to Revit results in the programming crashing. I've uninstalled and reinstalled the program, restarted my computer and end up with the same result.


    BIM One Support | February 28, 2017

    Hi Kevin, 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. Thanks for the feedback!


  • Great but need improvement
    Chris Lee | July 11, 2016 Verified Download (What's this?)

    Very great excel import/exporter compared with other add-in. Highly suggest to include Sheet List import/exporting function in the future.


    Alexandre Cantin | July 20, 2016

    Thank you for your great feedback! We take note of that request!


  • Great tool, very useful and free
    Carlos De Castro | June 16, 2016 Verified Download (What's this?)

    Thanks a lot for the tool. It's very stable and useful. Maybe a clearer schedule export with no styles could improve the general experience. Great tool though, definitely a must-have


    Alexandre Cantin | July 20, 2016

    Could you elaborate about the "clearer schedule export with no styles"? Please send that feedback to support@bimone.com. Thank you for that great rating!


  • No type parameters import
    Wijnand Bonsel | May 27, 2016 Verified Download (What's this?)

    This app has no use for me since you can't import type parameters (only instance parameters). It works oke for room schedules. The one star is because only at the end of the documentation it says "no type parameters". By this time I had already installed & tried the app and read the complete documentation. Please mention this in the description of the app! Not just the benefits but also the limitations ;)


    Chris Lee | July 11, 2016

    Please use Share Parameter / instance parameter which can be scheduling among multiple families


    Alexandre Cantin | July 20, 2016

    We understand your rating. We will try to adjust the documentation to highlight both the benefits and the limitations.


  • Revit 2017?
    Gyula Kelemen | May 10, 2016 Verified Download (What's this?)

    I just found this add-on for Revit. It's great. I'm interested, that will be released a version for Revit 2017?


    BIM One Support | February 28, 2017

    Hi Gyula, the addin now support Revit 2017. We also plan to release an update to support Revit 2018. Thanks for the feedback!


  • Problème importation
    THIBAULT CASSAT | March 14, 2016 Verified Download (What's this?)

    Bonjour, Lorsque je réimporte une nomenclature dans REVIT (par exemple, nomenclature de bouches d'aérations), les valeur de flux sont complètement erronées! Quel est ce mystère?


    Matthieu Carlier | May 19, 2016

    Bonjour j'ai également noté ce problème. Apparemment l'application est basée sur le système anglo-saxon et convertie les distances et vitesses d'Excel en Miles, pieds, pouces ... peut être qu'un développeur francophone entendra cet appel ;-)


    Alexandre Cantin | July 20, 2016

    Bonjour, ce problème a été résolu avec la version 17.0.1.0, faites-nous signe si vous avez encore des problème de conversion. Merci!


  • Very good add-in
    Duy Doan | March 09, 2016 Verified Download (What's this?)

    Thanks for your good add in. I like it so much


    Alexandre Cantin | July 20, 2016

    Thank you for your great rating!


  • Very Good APP
    Luis Herrero | February 09, 2016 Verified Download (What's this?)

    I was looking for a way to import a project sheet list from excel and populate my sheet list in Revit, but you can´t export this kind of list with the app. But, the good side is the export of the project standards and the way to clean and organize them, very good.


    Jeremiah Robker | March 15, 2016

    "I was looking for a way to import a project sheet list from excel and populate my sheet list in Revit" Use Dynamo. It works perfect for this.!


    Luis Herrero | March 18, 2016

    Well, i found it in the project standards. I can list to Excell all the sheet list and populatre it in excell. I have another question about the elements RGB color exported to excel. (Excel related question) Is posible to apply in Ecel, the RGB values in the column to the cell with its values? To control the project standards it would be very fast. I have been searching but didint found a easy way to do it.


  • Great Tool
    Bernhard Fetzer | January 20, 2016 Verified Download (What's this?)

    For me this (free!) tool works great. But there is one question about the material list export: would it be possible to insert the file path of the linked Map-File (jpg etc.) of the material appearance ? Kind Regards, Bernhard Added: There is a Probleme with Material Schedules. This Kind of Schedules will not be exported. This Kind of Schedule is not shown in the upper Window for Excel-Export. Hope this will be fixed.


    Alexandre Cantin | February 01, 2016

    Hi Bernhard, this comment about the material takeoff is recurrent so we look forward to implement that feature in an upcoming version. Thank you for your positive comment/rating!


  • Grand total table
    Thanh Nguyen | January 17, 2016 Verified Download (What's this?)

    Thanks for great tool, but when I tried to export the general material summary, It always itemize every individual object, not the grand total of each type of item. I'm using Revit MEP. could you plz fix? Thanks


  • Cannot import
    Stephen Whyte | November 25, 2015 Verified Download (What's this?)

    Can you import an excel sheet that has not been already exported from a revit schedule? I have excel sheets i need to import into revit but i have not created them in revit previously.


    Alexandre Cantin | November 30, 2015

    Hi Stephen, you could organize your existing data in the new excel file generated from Revit. You will then be able to import it back in Revit.


  • good, but
    David Chobanoff | November 20, 2015 Verified Download (What's this?)

    its a good tool, but be great if you can create a excel and import it into like a Drafting or something too


    Alexandre Cantin | November 30, 2015

    Hi David, our apps are more aiming towards BIM workflows where the data is embeded into elements instead of inserted beside as text. We hope you will find an app that fits your needs.


  • Bonne application
    Guy Chapados | November 14, 2015 Verified Download (What's this?)

    Bonne application. Excellent travail. Par contre y'a-t-il une version à venir qui permettra l'Import/Export de valeur issu de paramètre de Type? Merci pour le partage.


  • Looks good but got disappointed
    Cyril Waechter | November 04, 2015 Verified Download (What's this?)

    It look's great unfortunatly, data synchronisation is not reliable. I tried with many schedule, some kind of fields perfectly work but some other don't work at all, input values in excel are not transfered to Revit. Is it something about unit ? I don't know but I can't use this untrustable addin :-(


    Carl Veillette | November 16, 2015

    Type parameters are not supported. All grey cells are read only.


    Cyril Waechter | November 28, 2015

    Hello Carl, It wasn't about any type parameter. It was something about units, value is somewhere wrongly transformed.


    Alexandre Cantin | November 30, 2015

    Hi Cyril, There's a known issue regarding data units that we are going to fix soon. We'll send a newsletter about that update as soon as it's ready. Stay tuned!


  • no import tabs visible
    N G | October 28, 2015 Verified Download (What's this?)

    I have exported a schedule from a revit project and tried to import it into another project but cannot see any tabs to select.


  • Exporting shared parameters
    L.J. Van Der Voet | October 26, 2015

    This tool works good for the standard project parameters. But when I have shared parameters (system families) in my project and add them to my schedule the excel cells keep blanc after exporting. Maybe something to fix to complete this great tool. Thanks in advance.


  • Does not work with type parameters
    Steven Lopez | October 06, 2015

    This addin does not work at all with type parameters.


  • Simple, Free and Excellent
    Danil Poletavkin | September 30, 2015 Verified Download (What's this?)

    It just work, good job!


  • No Sheets
    G Cf | September 26, 2015 Verified Download (What's this?)

    When attempting to import an Excel spreadsheet, l can locate and select a spreadsheet, but once selected, l cannot select any sheets held within that spreadsheet for import purposes. Nothing appears. Any solution?


    Alexandre Cantin | October 23, 2015

    Hi G CF, you need to export the data from a Revit schedule first to establish the link between the spreadsheet and the Revit elements as the application is GUID based. From Excel, you will be able to modify the data you want (Except the read-only and type parameters) and you can then import it back in Revit to visualize your changes. Hope this helps


  • Does not Import Excel files!
    Ita Ekanem | September 24, 2015 Verified Download (What's this?)

    This app does not import excel files. I am surprised other users are satisfied with it. I keep getting the message to select the worksheets I wish to import from the excel document but it does not detect any of the worksheets in the excel document. This would be an otherwise useful tool if that can work.


  • Best yet
    Antony Mcphee | September 09, 2015 Verified Download (What's this?)

    Simple to use, robust. Does lockup (protect) and hides Row 1 and Column A of the exported Excel file, which some might find confusing. Doesn't export material schedule (Quantity Take-Offs) which is a pity, but hey, its free!


  • Very good but calculated value can't export
    SEHON KIM | August 21, 2015 Verified Download (What's this?)

    This tool is awesome and free!! Thanks. But It can't export "calculated value" in schedule. If some schedule contains a calculated value, it can't export to excel and stops working. I really would like to ask you to fix this problem. Thanks.


  • Works great!
    Dieter Wolf | August 13, 2015 Verified Download (What's this?)

    AAA+++ Genial


  • Works great!
    Duncan Lithgow | August 06, 2015 Verified Download (What's this?)

    The export / import of Revit settings/standards is fantastic for checking and cleaning up files. Thanks! Missing Text Styles though. Export of regular schedules is not quite so great visually, but maybe that's not the priority.


  • Very good tool to link Revit and excel
    Ilyas Abdelmoula | July 27, 2015 Verified Download (What's this?)

    Thank you for this useful tool. It does a great job to export schedules from Revit to Excel. The addin provides some cool options that help in different workflows. I really like the way it converts the Revit schedule totals to Excel SUM function. However, there is an issue: Revit has several types of schedules (schedule/Quantities, Material takeoff, view lists, sheet list...). The addin doesn't enlist all of them in its shedules list. In fact, it doesn't detect the material takeoffs at all, hence it can't export them to excel. So, I would like to ask you to add support for them.

Go top