Announcements
Welcome to the Revit Ideas Board! Before posting, please read the helpful tips here. Thank you for your Ideas!
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Revit Integration with Excel

Revit Integration with Excel

We need a lot to have a full- direct integrated tool between Revit and excel,

which enable us to export an excel sheet from Revit , update the schedule and the exported parameter values in excel , import again in Revit , and by default all updated data that has been modified in excel , to be updated in Revit too after import.

71 Comments
Viveka_CD
Autodesk Support

Posting on behalf of customer @jonny.eden who is looking for a similar request - 

 

Revit schedule export to excel with a functionality

  • to preserve line spacing,
  • match the sheet instance format and
  • without having the issue of a field missing multi-line breaks
  • populate the spreadsheet to mirror what was shown in the schedule in Revit
Anonymous
Not applicable

We should be able to import an Excel file directly into Revit. There are many schedules that need to be created for information purposes only, and have no bearing on the information produced by the model. This ranges from inputing project's code data that needs to be charted and not simply text formatted - such as building or zoning code information - to creating generic notes for a project that would benefit from being excel based rather than text boxes. The same functions that AutoCAD has for importing excel, needs to be in Revit. I should be able to directly link Excel files into Revit. Once the file is in Revit, I should be able to make any column alterations to the chart to fit the sheet appropriately. Furthermore, when links are saved in their original software, I should receive a pop-up indicating that a file has been saved, similarly to AutoCAD, and should be able to instantly update a file rather than going to Manage Links. Using styles to create what Excel already does is not the answer. Also, changing an Excel file to a .txt format is also not the answer. We need to import standard Excel formats in general. 

mattpick10
Advocate

Got to be a good idea to import excel into revit with importing to cad and then cad to revit. Can’t believe this is not a standard function. Come on Autodesk get it sorted. 

casquatch
Collaborator

Agreed. Even if the file was a CSV that would be an improvement and maybe more feasible. I'm thinking far more often folks want an Excel compatible format rather than just a text file and if they want a .txt file, then they could export from Excel afterwards.

AnneSolenn
Explorer

An OLE link with the Microsoft tools would be great!! Please : Allplan can do that since 2013..!

AnneSolenn
Explorer

An OLE Link would be perfect

Anonymous
Not applicable

Integration with Excel is already available as a free add-in: SheetLink add-in. If this functionality is available for free, why do you need it natively in Revit? Anything I am missing here?

semhustej
Advocate

Hi Neerva,

firstly, I am Revit LT user. You cannot install add-ins when using this version of Revit. Secondly I think this function is quite important and should be provided as a core Revit capability by Autodesk. Not as a outsourced project by another company, which can be discontinued at any time.

Thank you for the tip anyway, I didn't know about this add-in and I am not positive it's known well in the community. Have you been using it? Is it stable, does it work well?

 

Tomas

Magnus.B
Advocate

@Anonymous 

As @semhustej said. Third party software rarely stays free.. They tend to be subscriptions or discontinued. 

I'm also of the idea that basic functionality of a software should not depend on external developers. Special implementations yes but not core functionality. 

Anonymous
Not applicable

Update Revit so that a user can directly import Excel spreadsheets into a sheet in Revit.

Our company uses a lot of spreadsheets for schedules etc. that are not smart and just need to be shown. I currently import them into AutoCAD then import them into Revit. The formatting always changes from AutoCAD to Revit so I have to keep playing with the AutoCAD and spreadsheet formats until it shows up correctly in Revit. Huge time consumer.

 

Anonymous
Not applicable

This has been posted here:

https://forums.autodesk.com/t5/revit-ideas/import-excel-into-revit/idi-p/8630068?advanced=false&coll...

 

And here:

https://forums.autodesk.com/t5/revit-ideas/import-export-excel-into-revit/idi-p/7943689?advanced=fal...

 

And here:

https://forums.autodesk.com/t5/revit-ideas/revit-integration-with-excel/idi-p/6950055?advanced=false...

 

Adding another idea for the same thing instead upvoting one of the above (which all should be combined) just lets the ideas fall through the cracks and lost.

roquealfonso
Advocate

Similar to AutoCAD where you could import tables and update links from Excel, Revit should be able to perform this task as well. 

ipselute
Advisor
zhaohui.chen5TEA7
Enthusiast

There are third party add-ins can do this. But it would be nice to have this functionality in Revit natively.

SamBerk
Advocate

This add-in bimright.com is a bit different from the other Excel add-ins because it works in realtime, and it's bidirectional, the way it works is:

  1. you link an excel file to the revit project.
  2. create a table in excel.
  3. link it to a schedule in revit.

then if you change a cell in the excel table, the revit schedule will get updated and vice versa.

Anonymous
Not applicable

Hi!

Just wanted to know if there is now - 3 years later - a free revit internal solution for the issue?

Thanks in advance

filipefrancisco
Collaborator
Need this I know that are many apps/puglins, but is not the same thing
elzohry2007
Collaborator

Diroot has the ability to export from revit to excel sheet and dynamo also
also has the abilty to import from excel to draft view
we hope it's built in Revit

haitham.anwer94
Contributor

I think every architect felt this pain with me. 

it's really about time to create a bridge between excel and Revit, 

schedules should have the ability to be exported to excel files and at the same time the ability to import excel files into Revit as dummy schedules. 

wr.marshall
Advisor

Note I am not on Beta program and therefore do not know anything about the up coming release of Revit 2022.

I suspect we will see the ability to save directly to CSV as per this item in the Revit roadmap in the next release

Export Schedules to .CSV 

What would be handy is the ability to save to . XLS and .XLSX formats too as most people use MS Excel. The roadmap item does not state if this is the plan

Can't find what you're looking for? Ask the community or share your knowledge.

Submit Idea  

Autodesk Design & Make Report