
Export-Import Excel
Free
OS:
Language:
Description
The application historically developed by BIM One is no longer supported and is now available as open source on GitHub here:
- Excel Export-Import: https://github.com/bimone/addins-excelexporterimporter
The community can now use and improve these add-ins that helped many of you in your daily tasks since our beginnings.
- this page will be removed in the coming weeks -
Note that additionally, the Addin Manager has been retired.
About This Version
Version 21.0.0.0, 9/28/2021
Added support for Revit 2021.
We need a new version for 2022 & 2023, please!
we can use DiRootsOne to export and import excel
It would be great if you could also publish for 2022 version.
Thanks!
Please review the new app description. The app is now open source and available here: https://github.com/bimone/addins-excelexporterimporter
Many thanks for your quick response. I checked the link but I didn't get the addins for Revit 2022 version. Please help. The addins is for Revit 2015-2021.
Check this one https://github.com/bimone/addins-excelexporterimporter/issues/2#issuecomment-977245472 it explains how to get it running in 2022
Need an updated to use in 2022
I also need for Revit 2022 version.
Please review the new app description. The app is now open source and available here: https://github.com/bimone/addins-excelexporterimporter
detects my electrical schedule for export but not my panel schedules.
Panel schedules aren't supported. They actually are an entirely different beast in the Revit API. You can still submit an issue on https://github.com/bimone/addins-excelexporterimporter/issues
The Plugin works great, will save me a lot time
i can't install in revit 2022
Please review the new app description. The app is now open source and available here: https://github.com/bimone/addins-excelexporterimporter
Vai sair a versão desse plugin pro revit 2022 ?
Please review the new app description. The app is now open source and available here: https://github.com/bimone/addins-excelexporterimporter
Will the 2022 version be available soon?
We have new plans for the addin. I can't tell you much more right now, but stay tuned jm
Please review the new app description. The app is now open source and available here: https://github.com/bimone/addins-excelexporterimporter
ótimo plugin, funciona bem. obrigado
Obrigado pelo seu apoio
Thank you very much for making this free for everyone to use.The app is truly useful
Thanks for the positive feedback
감사합니다 이걸로 한번에 엑셀로 변환했네요
It simply saves time, an essential tool for Revit! We have recently switched to Revit 2021, when will it become compatible with the newest Revit?
Hi Gabor, It is available as of today for Revit 2021 Enjoy
like. thanks
Very useful
Bitte schnell Update auf Version 2020 machen!
2020 support ist hier
It doesnt work for certain parameters, it can output the table but does not populate with the data in your revit schedule. It also struggles with importing the data back in and will not work unless you are using a very basic table with limited data it will not work properly.
Also support is non existent
The plug-in is great but I had one problem: it's not working well with slope parameters. The exported works well but the import don't. Is it just with me or is it how the app works?
material takeoff can't export by your add-in.... Can u upgrade??
This app is very good, but we can't use every shedules for the exsport.
Will it be upgraded in a new version?
If yes, when ?
(forgive my English)
I did a lot of tests with this tool. In my opinion, this is one of the most useful apps so far.
The idea is awesome, and it works fine in most scenarios (decimal number, text, etc).
The problem I have is, that I can not import bool and integer operations.
When I try doing so, I always get an error massage.
Even than, when I am exporting a schedule, change one parameter (f.e.: False to True or changing a 4 into a 3) and run the import, I get an error.
Is it not possible to import those types of operations or should this work as well?
Thanks for any reply!
Btw.: I work with Revit2019
Hi Have you tried to convert all your bool & integer operations to plain values in excel before importing into Revit. That might help you. Best regards, Andreas
Excellent Tool. Great for Sheet renaming etc. The huge limitation is that it does not do Type Parameters. wish it did that. I understand that if they did it, the last line will win. so you have to be consistent for each instance.
The APP works great. Although it should be mention that any sorting with breakline and foot note will mess up with the generated excel file. And, as expect, you can't override element's attribute within group with the APP.
Excellent plugin
please 2019 version !!!
merci pour cette mise à jour !
ça serait parfait si vous pouviez ajouter les nomenclatures de vues et de feuilles dans le transfert !
Works well; you can export RVT sheets, edit in excell and then import back the updated values
When come the version for Revit 2019 ???
Grate app :) 2019 please :)
Works great with revit 2016, exports exactly as constructed in revit schedule.
Thanks!
Unfortunately we cant use it now. We are now on subscription so it wont work in the updated software :-(
Super Application très utile
I have been a big fan on BIMOne for a long time and was thrilled to come in this morning and find the 2018 build!
Hi Eric, thank you for your valuable feedback and great rating. Do not hesitate to contact us via support@bimone.com if you have any questions!
Thank you for sharing with us.
Hi Mouaad, thank you for your feedback and we're glad you like our add-in. Do no hesitate to contact us via support@bimone.com if you have any questions!
Why can't export drawings schedule?Any solution?
Hi Damon, could you write an email to our help desk(support@bimone.com) and our team will take a look at the issue. Thanks!
we need your update as soon as
Hi Steve, thank you for the great rating. Please note that a new version that is compatible with Revit 2018 has been released. Let us know if you have any questions.
Necesitamos la version 2018, esperamos con ancias tu actualización,
Hola, lo siento por el retraso. Tenemos una nueva version que es compatible con Revit 2018.
Para cuando la versión para el Revit 2018 ? Estamos viendo que estáis tardando mucho, por lo que hemos probado otras app que son interesantes y hacen el mismo trabajo que vuestra app....Y después de meses de espera nos hemos decantado por otra app, recomiendo: ScheduleSync Pro. Un saludo a todos los usuarios de Revit.
Hola, lo siento por el retraso. Tenemos una nueva version que es compatible con Revit 2018.
Hi, I have a Key schedule and Door schedule with the created keys. I wanna overwrite the keys in Door schedule with excel. I tried it in normal way, but its unsuccessful.
Hi Ganesh, thank you for the great rating! Could you raise the issue to our help desk(support@bimone.com)? We'll get in touch with you and try to find a solution.
Thanks a lot for this great tool! Have some problems when exporting schedules though, especially when they are sorted by multiple parameters
Hi M7ammad, thank you for your valuable feedback. Could you raise the issue to our help desk(support@bimone.com)? We'll get in touch with you and try to find a solution.
See someone could help on this: While I am exporting revit schedules to the excel file seems it does not appear in the same order/sorting as shown in the revit schedules, is that possible to amend somehow without having to alterate excel? The other question is that trying to export area schedules from a linked revit file is not working in the excel sheet as areas appear to show 0 result in every excell field. That means I need to export from the linked file, not from the central? Thanks in advance.
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.
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.
Works perfect! Saved me good few hours of imputing hundreds of data back into Revit!
import function doesn't work.
Import does not work as instructed. Cannot import Excel Sheet after navigating to it and populating the search bar.
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.
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.
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!
When importing into Revit 2017 it asks for you to select a worksheet(s) but does not give anyway of doing so.
Ya had the same problem but tried to export the file first it seemed to work
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!
Pop-up message says please select worksheets to import, not worksheets to select are provided.
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!
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
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.
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. sheets can't be choosen after giving path.
same here
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!
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.
Very great excel import/exporter compared with other add-in. Highly suggest to include Sheet List import/exporting function in the future.
It doesnt work for importing excel files, It doesnt find any worksheets. Does anybody know whats wrong?
Does not work with Sheet List Schedules
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
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 ;)
I just found this add-on for Revit. It's great. I'm interested, that will be released a version for Revit 2017?
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?
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 ;-)
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!
Thanks for your good add in. I like it so much
Thank you for your great rating!
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.
"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.!
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
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.
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.
its a good tool, but be great if you can create a excel and import it into like a Drafting or something too
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.
BIM workflow is all very well but in the real world drawings need to be produced with text, Notes and tables on them. to be able to import an XL file as a table in draughting views or legends or schedules would be tremendously useful
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.
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 :-(
Type parameters are not supported. All grey cells are read only.
Hello Carl, It wasn't about any type parameter. It was something about units, value is somewhere wrongly transformed.
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!
I have exported a schedule from a revit project and tried to import it into another project but cannot see any tabs to select.
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.
This addin does not work at all with type parameters.
It just work, good job!
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?
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
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.
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!
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.
AAA+++ Genial
Great tool as always. I notice thought that the Project Settings export of Parameters in v. 21 no longer includes the "Description". This is unfortunate as this tool is the only way I know of (knew of) to grab that information and see if everything was documented usefully.
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.