RevitCity.com Logo

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

Welcome !

216 Users Online (121 Members): Show Users Online - Most ever was 497 - Tue, Nov 18, 2014 at 4:58:46 PM

 

Forums

Forums >> Revit Building >> Tips & Tricks >> Importing Excel into Revit

Search this ThreadSearch this Thread | Page 1 of 1 |

Mon, Mar 30, 2009 at 10:14:54 AM | Importing Excel into Revit

#1

batkin


active

Joined: Mon, Mar 30, 2009
1 Posts
No Rating


  1. There isn't an easier way to do this, which I'm suprised about as excel is a much used tool linking data to drawings so if there is an easier way please let me know. I've seen on here creating an image file, which is time consuming and doesn't live link the data whereas this method does.

This method involves linking excel to CAD then linking CAD to Revit. Open up CAD and follow these steps:

To set up Data Links:

  1. Launch the TABLE command.
  2. Click “From a data link“, and launch the “Data Link Manager” by clicking the button (illustrated).
  3. Click “Create a new Excel Data Link”

 

  1. Name the Data Link – something intuitive.

  2.  

  3. Browse for your Excel Table

     

  4. The “New Excel Data Link” dialogue can be expanded by clicking the button in the bottom right corner.

     

  5. Under “Cell Contents”, uncheck “Convert data types to text”, and check both “Retain Formulas” and “Allow writing to source file”. Checking those options will make it so your Excel formulas will be preserved, and that you will be able to make edits to the table in AutoCAD, and they be populated to the origional Excel file.   
  6. Press the [Ok] button 3 times to get out of the command, and insert your linked table.

     

  7. Assuming you checked the “Retain Formulas” option when setting up the Data Link, you’ll notice fields (text with a grey background) for any calculated value.

After inserting your Excel table, any updates made in the source Excel file will be updated in AutoCAD. By default however you will not be able to update data from AutoCAD, and have it update in the source Excel document. To modify a table value in AutoCAD, select a cell, right-click, and navigate down to “Locking”, and select “Unlock”.

After unlocking a cell, you can click into a cell, change a value. As a deliberate checks and balances, to update the Excel file, you must right-click once again, and select “Write Data Links to External Source“.

To pop it into Revit, just link the CAD file by:

File>Import/Link>CAD format

Hope this helps!

 

 


This user is offline

 

Mon, Mar 30, 2009 at 9:18:37 PM | Importing Excel into Revit

#2

jarosa


active
jarosa Avatar

Joined: Tue, Feb 19, 2008
251 Posts
4 Stars: 5 Votes


DotSoft has a program. Looks like a good add on. Has anyone tried it? Below is the link.

http://www.dotsoft.com/revit/xl2cad.htm

 


This user is offline

View Website

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

IMPORTING EXCEL

Revit Building >> Technical Support

Sat, Sep 8, 2012 at 1:26:43 AM

6

Importing excel spreadsheets into Revit

Revit Building >> Technical Support

Thu, Feb 3, 2011 at 1:52:57 PM

10

Schedule Sync for importing/exporting Excel files

Workflow & Implementation >> API & Third Party Apps

Wed, Mar 5, 2014 at 5:12:17 PM

2

importing excel files

Revit Building >> Technical Support

Tue, Sep 17, 2013 at 5:50:04 PM

1

Importing Miscorosft Office Documents?

Community >> The Studio

Wed, Nov 14, 2007 at 10:07:01 PM

5

Site Stats

Members:

573959

Objects:

15586

Forum Posts:

132522

Job Listings:

4

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: 1.0266

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights