ОС:
Язык:

Описание

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.

Прочитать справку

Сведения об этой версии

Версия 17.0.1, 15.12.2016
Fixed the unit conversion issue

Скриншоты и видео


Рецензии клиентов

(38 оценки)

|

Техническая поддержка
  • So much promise...
    Scott Dakin | июня 15, 2017 Проверенная загрузка (Что это такое?)

    While it looks good it randomly changes the Family Type of some data devices when the Mark is changed in Excel and then imported back into Revit 2016. I'm working with hundreds of elements so maybe you need to test with a larger amount of elements as it doesn't do this with a small number of elements.


    BIM One Support | июня 21, 2017

    Thank you for your report Scott. We'll take a look at the issue.


  • Neat
    Jeff Weeden | июня 13, 2017 Проверенная загрузка (Что это такое?)

    This will significantly reduce the amount of time needed for teledata labeling. After a trial on a small schedule, it seems to work as advertised. I really wish we would have had this 3 years ago.


    BIM One Support | июня 21, 2017

    Hi Jeff, thank you for the great feedback! We'll be soon releasing an update that will also support Revit 2018.


  • Pile load table
    Zuzana Hrabusova | мая 30, 2017 Проверенная загрузка (Что это такое?)

    Works perfect! Saved me good few hours of imputing hundreds of data back into Revit!


    BIM One Support | июня 21, 2017

    Hi Zuzana, thank you for the great feedback! We're glad you like it!


  • not working on revit 2017
    jaspreet rai | мая 18, 2017 Проверенная загрузка (Что это такое?)

    import function doesn't work.


    BIM One Support | июня 21, 2017

    The addin is not meant to import man-made Excel sheets. It is mandatory to use the export feature first as mentioned in the app description. The addin uses GUIDs to recover the information from the exported Excel sheet to sync it back into Revit. Without those GUIDs, the import won't work.


  • Waste of time
    A PATEL | апреля 10, 2017 Проверенная загрузка (Что это такое?)

    Import does not work as instructed. Cannot import Excel Sheet after navigating to it and populating the search bar.


    BIM One Support | июня 21, 2017

    The addin is not meant to import man-made Excel sheets. It is mandatory to use the export feature first as mentioned in the app description. The addin uses GUIDs to recover the information from the exported Excel sheet to sync it back into Revit. Without those GUIDs, the import won't work.


  • IMPORT DOES NOT WORK
    DCA Design | марта 27, 2017

    Contrary to what the developers reply has been in previous posts with the stock answer. "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. I have exported, with the BIMone app, from a project to globally change and add a prefix to my project parameters. That worked great, I then changed , in excel, the field i needed and saved. On import I got the same problem as others before, after picking the original amended exported excel file i get the error "Please select a worksheet to import" Any feed back???


    Osahon Umweni | апреля 04, 2017

    hello, I created shared and project parameters. When i exported, only the project parameters can be edited in excel and transported back again. But the shared parameters are greyed out to show it can't be edited. When I add the shared parameters as part of the project parameters, they can now be edited. The problem with this is that on the properties of all the objects, you now have project parameters on all of them. How can I solve this problem.


  • Not export information in schedule
    Osahon Umweni | марта 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.


    BIM One Support | июня 21, 2017

    Unfortunately shared parameters are not supported by this addin if they are type parameters. Modifying type parameter requires to change the parameter in all the families it was inserted.


  • Great App!
    ROBERT THOMPSON | декабря 30, 2016 Проверенная загрузка (Что это такое?)

    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!


  • Import Does Not Work in Revit 2017
    Craig Boersen | декабря 14, 2016 Проверенная загрузка (Что это такое?)

    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 | февраля 21, 2017

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


    BIM One Support | февраля 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 | ноября 16, 2016 Проверенная загрузка (Что это такое?)

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


    BIM One Support | февраля 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 | октября 13, 2016 Проверенная загрузка (Что это такое?)

    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 | февраля 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 | октября 05, 2016 Проверенная загрузка (Что это такое?)

    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 | августа 22, 2016 Проверенная загрузка (Что это такое?)

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


    Ki Fung Li | октября 06, 2016

    same here


    BIM One Support | февраля 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 | августа 04, 2016 Проверенная загрузка (Что это такое?)

    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 | февраля 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 | июля 11, 2016 Проверенная загрузка (Что это такое?)

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


    Alexandre Cantin | июля 20, 2016

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


  • Great tool, very useful and free
    Carlos De Castro | июня 16, 2016 Проверенная загрузка (Что это такое?)

    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 | июля 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 | мая 27, 2016 Проверенная загрузка (Что это такое?)

    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 | июля 11, 2016

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


    Alexandre Cantin | июля 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 | мая 10, 2016 Проверенная загрузка (Что это такое?)

    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 | февраля 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 | марта 14, 2016 Проверенная загрузка (Что это такое?)

    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 | мая 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 | июля 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 | марта 09, 2016 Проверенная загрузка (Что это такое?)

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


    Alexandre Cantin | июля 20, 2016

    Thank you for your great rating!


  • Very Good APP
    Luis Herrero | февраля 09, 2016 Проверенная загрузка (Что это такое?)

    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 | марта 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.!


  • Great Tool
    Bernhard Fetzer | января 20, 2016 Проверенная загрузка (Что это такое?)

    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 | февраля 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 | января 17, 2016 Проверенная загрузка (Что это такое?)

    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 | ноября 25, 2015 Проверенная загрузка (Что это такое?)

    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 | ноября 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 | ноября 20, 2015 Проверенная загрузка (Что это такое?)

    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 | ноября 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 | ноября 14, 2015 Проверенная загрузка (Что это такое?)

    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 | ноября 04, 2015 Проверенная загрузка (Что это такое?)

    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 | ноября 16, 2015

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


    Cyril Waechter | ноября 28, 2015

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


    Alexandre Cantin | ноября 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 | октября 28, 2015 Проверенная загрузка (Что это такое?)

    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 | октября 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 | октября 06, 2015

    This addin does not work at all with type parameters.


  • Simple, Free and Excellent
    Danil Poletavkin | сентября 30, 2015 Проверенная загрузка (Что это такое?)

    It just work, good job!


  • No Sheets
    G Cf | сентября 26, 2015 Проверенная загрузка (Что это такое?)

    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 | октября 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 | сентября 24, 2015 Проверенная загрузка (Что это такое?)

    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 | сентября 09, 2015 Проверенная загрузка (Что это такое?)

    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 | августа 21, 2015 Проверенная загрузка (Что это такое?)

    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 | августа 13, 2015 Проверенная загрузка (Что это такое?)

    AAA+++ Genial


  • Works great!
    Duncan Lithgow | августа 06, 2015 Проверенная загрузка (Что это такое?)

    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 | июля 27, 2015 Проверенная загрузка (Что это такое?)

    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.

Наверх