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

Welcome !

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



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

Search this ThreadSearch this Thread | Page 1 of 1 |

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




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.


  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 4:18:37 PM | Importing Excel into Revit



jarosa Avatar

Joined: Mon, Feb 18, 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.


This user is offline

View Website

Search this ThreadSearch this Thread | Page 1 of 1 |

Similar Threads

Thread/Thread Starter


Last Post



Revit Building >> Technical Support

Fri, Sep 7, 2012 at 8:26:43 PM


Importing excel spreadsheets into Revit

Revit Building >> Technical Support

Tue, Nov 6, 2018 at 3:35:39 PM


Schedule Sync for importing/exporting Excel files

Workflow & Implementation >> API & Third Party Apps

Wed, Mar 5, 2014 at 11:12:17 AM


importing excel files

Revit Building >> Technical Support

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


Importing Miscorosft Office Documents?

Community >> The Studio

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


Site Stats





Forum Posts:


Job Listings:


Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About | 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.7062


User Name:


Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search

Clear Highlights

Clear Highlights