Revit MEP

Revit MEP

Reply
Contributor
SteveR...
Posts: 17
Registered: ‎01-25-2010
Message 1 of 7 (3,562 Views)

Is there really no way to import Excel directly into REVIT?

3562 Views, 6 Replies
01-23-2013 07:25 AM

Searching through prior threads it seems that this is the case.  It is baffling that Autodesk hasn't included a simple way to do this.  It seems that their excuse is that this defeats the purpose of a BIM model.  Excel is a very powerful calculation tool, not to mention just a very efficient way of presenting data, until REVIT can do the same things, Excel will continue to be necessary.

 

Autodesk people, do you do ANY market research to determine how people in the real world actually use your software?  It seems that you have absolutely no understanding of the need to do things quickly.

*Expert Elite*
abulla
Posts: 352
Registered: ‎10-14-2008
Message 2 of 7 (3,554 Views)

Re: Is there really no way to import Excel directly into REVIT?

01-23-2013 08:34 AM in reply to: SteveR...

I agree it's frustrating at first, but give Revit schedules a chance. They use the same formula formatting as Excel, and they're just as powerful, if not more so once you get them down. That being said, getting them down does take a while, and we still combine AutoCAD drawings with Excel schedules on them with our Revit plans.

Contributor
SteveR...
Posts: 17
Registered: ‎01-25-2010
Message 3 of 7 (3,511 Views)

Re: Is there really no way to import Excel directly into REVIT?

01-24-2013 06:40 AM in reply to: abulla

Tens of thousands of users should not need to re-write perfectly functional macros, formulas, etc just because Autodesk refuses to provide an appropriate solution to Excel.  Not to mention there are just too many things that Revit schedules simply can't do as well or at all that Excel does.  If Autodesk had any competition they would be forced to do stuff like this.

 

Hopefully one day Google will create some BIM or CAD software.

*Expert Elite*
CADastrophe
Posts: 3,227
Registered: ‎08-28-2009
Message 4 of 7 (3,507 Views)

Re: Is there really no way to import Excel directly into REVIT?

01-24-2013 07:05 AM in reply to: SteveR...

I'm a heavy user of Excel and feel the pain when dealing with Revit's amputated formula's and functions, which is one of my top issues with Revit currently. (See my posts in this thread for specifics). I create a network database for our electrical panels/systems in Excel which works very well, and is imported into AutoCAD via a script that is written by the program. When we first began using Revit this was a major issue for us. We would create an AutoCAD drawings and create our schedules there, and then link that .dwg into Revit.

 

However, now that we are moving forward more and more into Revit and it's systems, the scheduling power of Revit is (for the most part) eclipsing the use of the excel spreadsheets. Why? Because Revit's schedules directly interact with the elements with a Revit Project. If fact, one of the more powerful features is that if you make changes directly to a Revit Schedule (could be a single element or even all elements), that change is carried on to all applicable elements in the Project instantly. Revit's schedules directly interact with the database, rather than simply report data. At this point, our longing to be able to link Excel files into Revit has greatly diminished.

 

Again, as mentioned above, I WISH that Revit has even the most basic functions of Excel, but this Revit program is in continuous evolution (albeit extremely slow) and perpetual development. I doubt that it will ever reach Excel's potential, but there is evident of advancement, notable with the addition of the ROUND functions.

Corey D.                                                                                                                  ADSK_Logo_EE_2013.png    AutoCAD 2014 User  Revit 2014 User
──────────────────────────────────────────────────────────────────────
⁞|⁞ Please use Mark Solutions!.Accept as Solution and Give Kudos!Give Kudos as appropriate to further enhance these forums. Thank you!
New Member
AmeliePhaine
Posts: 1
Registered: ‎01-23-2014
Message 5 of 7 (2,271 Views)

Re: Is there really no way to import Excel directly into REVIT?

01-23-2014 12:01 PM in reply to: SteveR...

I know this question is ages old, but I was looking for a solution to the same thing. I'm in a small firm and running its first Revit project alone. There simply isn't time for me to develop everything (namely schedules that look like the principal wants) the first time around. So for the pricing set, I imported an Excel sheet as a data link into an empty AutoCAD file and then linked that file into my Revit sheet. It's absolutely backward, but it works! Hope this helps someone.

*Expert Elite*
abulla
Posts: 352
Registered: ‎10-14-2008
Message 6 of 7 (2,263 Views)

Re: Is there really no way to import Excel directly into REVIT?

01-23-2014 12:32 PM in reply to: AmeliePhaine

Nice, good tip. I've also recently found an add-in that has some neat Revit to Excel and Excel to Revit functionality. Check out Excel 2 Revit. We've used the trial version, and it works pretty well.

Active Member
Sinha
Posts: 9
Registered: ‎09-13-2006
Message 7 of 7 (1,586 Views)

Re: Is there really no way to import Excel directly into REVIT?

05-02-2014 08:18 AM in reply to: CADastrophe

I link EXCEL into AutoCAD as a TABLE, then Link AutoCAD into Revit. Long Process but works.

 

Update EXCEL File 

Then Reload/Refresh TABLE in AutoCAD,

Then Reload your LINKED AutoCAD File in Revit.

 

:smileyhappy:

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.