RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

134 Users Online (33 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

Forums >> Revit Building >> Technical Support >> Exporting Electrical panel schedules to Excel

Search this ThreadSearch this Thread | Page 1 of 1 |

Fri, Mar 28, 2008 at 4:19:31 PM | Exporting Electrical panel schedules to Excel

#1

mtrmcemjrsfr


active

Joined: Fri, Feb 15, 2008
2 Posts
No Rating


Does anyone know if it is possible to export panel schedules created by Revit to excel format?

 

Thanks,

mtrmcemjrsfr 

 


This user is offline

 

Wed, Sep 24, 2008 at 6:09:23 PM | Exporting Electrical panel schedules to Excel

#2

lorne17


active
lorne17 Avatar

Joined: Wed, Aug 29, 2007
417 Posts
3.5 Stars: 7 Votes


Hello there,

 

If you are merely trying to get a schedule into excel format, you don't need OBDC.  All you need to do is got  to your schedule.  Then go to file>export>schedule.  It'll save it as a delimiter text file.  Then go to Excel.  Go to Data>import external data...>import data.  Go find your .txt delimiter text file and you'll get a few dialogs to edit your excel layout.  I just leave as default, and click finish.  You'll see all your schedule in.  

 Now you'll probably have to edit it a bit as you lose merged cells etc.  But a lot easier than typing it out!

 

Hope that helps,

Lorne


-----------------------------------

AutoDesk Revit Certified Professional

Denver, CO

Revit Architecture

This user is offline

 

Wed, Sep 24, 2008 at 11:23:47 PM | Exporting Electrical panel schedules to Excel

#3

mtrmcemjrsfr


active

Joined: Fri, Feb 15, 2008
2 Posts
No Rating


I tried to do that and in File>Export>Schedule, Schedule was not available, (Grayed out). I had the panel schedule opened but it didn't work. What else do i need to do?

 

Thanks,

Mike 

 


This user is offline

 

Wed, Sep 24, 2008 at 11:29:30 PM | Exporting Electrical panel schedules to Excel

#4

lorne17


active
lorne17 Avatar

Joined: Wed, Aug 29, 2007
417 Posts
3.5 Stars: 7 Votes


hrmmm well that stumps me.  I went to my door schedule and it worked fine.  I would say just make sure your schedule is the active window and also make sure it's a Revit schedule.  Not a legend or drawing view.

 

Make sense?

 


-----------------------------------

AutoDesk Revit Certified Professional

Denver, CO

Revit Architecture

This user is offline

 

Wed, Feb 18, 2009 at 8:28:36 PM | Exporting Electrical panel schedules to Excel

#5

SamLerman


active

Joined: Mon, Oct 20, 2008
22 Posts
No Rating


Exporting is nice, but what is the use of it, if you can't import Excel file back to Revit?

Or, maybe I don't know how?

I'm trying to link AutoCAD file with linked Excel schedules, it does not work, Revit don't take schedules.

Maybe I do something wrong?

 


This user is offline

View Website

Wed, Feb 18, 2009 at 8:53:31 PM | SamLerman

#6

lorne17


active
lorne17 Avatar

Joined: Wed, Aug 29, 2007
417 Posts
3.5 Stars: 7 Votes


Quoting SamLerman from 2009-02-18 14:28:36

"

Exporting is nice, but what is the use of it, if you can't import Excel file back to Revit?

Or, maybe I don't know how?

I'm trying to link AutoCAD file with linked Excel schedules, it does not work, Revit don't take schedules.

Maybe I do something wrong?

 

"

 

Well the only use I see, is when you need to send your door/window schedule to say a consultant to edit it and they don't have Revit.  I don't know how to import back into Revit, as the schedule is linked to actual model objects so I don't think it's possible (not for sure).

 

As for autocad, I try not to use it.  So I can't help you there.  Sorry.


-----------------------------------

AutoDesk Revit Certified Professional

Denver, CO

Revit Architecture

This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Exporting Multiple schedules to excel at once?

Revit Building >> Technical Support

Wed, May 21, 2008 at 3:11:07 PM

0

Exporting Schedules into excel format

General Discussion >> Revit Project Management

Fri, Mar 13, 2015 at 10:53:44 AM

3

exporting to excel

Revit Systems >> Technical Support

Mon, Feb 6, 2012 at 12:26:26 PM

3

electrical panel schedules in 2011

Revit Building >> Technical Support

Fri, Oct 22, 2010 at 5:11:22 PM

2

Electrical Panel Schedules - Space numbers

Revit Systems >> Technical Support

Wed, Sep 3, 2014 at 7:49:40 PM

0

Site Stats

Members:

1842229

Objects:

22620

Forum Posts:

152043

Job Listings:

3

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 0.2711

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights