|
Forums >> Revit Building >> Technical Support >> Importing excel spreadsheets into Revit
|
|
|
active
Joined: Thu, Jul 27, 2006
38 Posts
No Rating |
How can I import a door or window schedule created in Excel into Revit?
|
This user is offline |
|
 |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
 |
If you're in transition from something else to REVIT on an already started project, then you might want to do this but if not, then the question is why would you want to lose all the advatages of REVIT? I suppose you have some standard door types and you feel you will be wasting someting by not using what you have.
We are rather new to REVIT but I think the rewards will be there if we don't bastardize it too much. Change is tough! ....and there is a time investment. We're not there yet but we're going to get there. Just have to work on our thought process.
If you must ... copy and paste the Excel file into AutoCAD, then import it into REVIT. But better yet, start building you families so your schedule will be automatic.
|
This user is offline |
|
|
|
active
Joined: Thu, Jul 5, 2007
7 Posts
No Rating |
One of the biggest reasons that I have found to use Excel over Revit's inhierent processes is the electrical Panelboard Schedule. Revit's schedule has a good deal to be desired, in appearance, in functionality and in customization. How do you add an existing load to an existing panelboard? How do you add spare circuit breakers to a panel? How do you change the appearance of a panel board? I haven't even attempted to allow Revit to perform my electrical load summary calculations, especially considering that it will take into consideration that not all of the elements in the electrical load calculations will fall within the elements of a project. For these reasons alone, Microsoft Excel is crucial to project completion.
|
This user is offline |
View Website
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
Update ... now a year later & thinking about your panel board problem. I say put as much as you can into REVIT's automatic scheduling. Then export that to an excel file. It's been awhile since I did it but I think this file can be linked into a file that has all of your formulas - look-up charts ... whatever. This process would allow you to do periodic exports and re-calcs as the model changes and your schedules are all still automatic.
|
This user is offline |
|
|
|
active
Joined: Thu, Jul 5, 2007
7 Posts
No Rating |
Yes, I can see the benefit to that, however, I would still have to bring the Excel spreadsheet back into Revit. Now we're back to importing an Excel spreadsheet and with the current capabilities it's about as much fun as stapling your tounge to your shirt.
|
This user is offline |
View Website
|
|
|
active
Joined: Wed, Sep 30, 2009
9 Posts
No Rating |
jfosterIII, Have you found any Revit way of producing a building load summary, or is importing from excel still the only way?
|
This user is offline |
|
|
|
active
Joined: Thu, Jul 27, 2006
38 Posts
No Rating |
Wow, it's 2011 and still not a solution from Autodesk on how to import a spreadsheet from excel!
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
Available as an add-on: http://www.cadig.com/products/excel-to-revit.php?gclid=CPvDu7nU6aYCFZ065QodtjFd3A
|
This user is offline |
|
|
|
active
Joined: Thu, Jul 27, 2006
38 Posts
No Rating |
Thank you very much!!! It seems this is a paid add on. Apparently it does the same as to first import the excel file to acad, save it as a cad file or dxf and then import it from Revit as a link. The problem is that it keeps the same formatting and fonts from excel or acad and doesnt match to the one in revit...
|
This user is offline |
|
|
|
active
Joined: Thu, Jul 27, 2006
38 Posts
No Rating |
I waited 4 years for an answer! Thank you.
|
This user is offline |
|
|
|
|
|
active
Joined: Thu, Mar 9, 2006
118 Posts
 |
I use an printer that prints excel sheets to a jpg and then import the image into revit.
|
This user is offline |
View Website
|
|
|
active
Joined: Wed, Oct 3, 2018
0 Posts
 |
Using version 2019 and I still don't see a way to do it!
|
This user is offline |
|
|
|
Search