topic Re: Import Excel Into Revit in Revit Architecture Forum

Import Excel Into Revit

Irich — Mon, 05 Jun 2017 19:43:42 GMT

I am reasonably certain that you cannot directly import an Excel Spreadsheet into a Revit drawing so what could I do as a work around?

We used a spreadsheet similar to the screen shot below to show elevations of embeds. There is not a lot of intelligence built into it (maybe some simple formulas) but I not sure how to create this table or something similar inside of Revit.

Beyond that, if I can find a way to make the table more intelligent and pull information from the model- floor elevations, form elevations, etc. then I would be golden!

Thanks for the help!

Re: Import Excel Into Revit

ToanDN — Tue, 06 Jun 2017 16:23:28 GMT

You can link the Excel spreadsheet to an AutoCAD table using AutoCAD's datalink. Then link the AutoCAD file to Revit. When you update the Excel file, open AutoCAD and right click on the table to update it. Save and reload the link in Revit and it will be updated.

It may sound convoluted but it can actually be done fairly quickly.

Re: Import Excel Into Revit

Irich — Tue, 06 Jun 2017 16:25:57 GMT

I know this may not make much sense but....what if I don't have AutoCAD and only have access to Draftsight? I think I can get AutoCAD but I am not 100% sure on that.

Re: Import Excel Into Revit

ToanDN — Tue, 06 Jun 2017 16:47:49 GMT

If you don't have AutoCAD then you can't use that method. And I wouldn't buy AutoCAD just to do such task.

Create a key schedule in Revit and enter the information manually.

Re: Import Excel Into Revit

Irich — Tue, 06 Jun 2017 16:50:34 GMT

Fantastic! I will start there. Thank you very much!

Re: Import Excel Into Revit

Sahay_R — Tue, 06 Jun 2017 17:24:39 GMT

There are plug-ins that will do t his. For instance, we have Imaginit Utilities -

Re: Import Excel Into Revit

Anonymous — Tue, 06 Jun 2017 22:39:10 GMT

donde encuentro ese Plug in.??

Re: Import Excel Into Revit

Sahay_R — Wed, 07 Jun 2017 12:53:33 GMT

Not sure @Anonymous. Here is the website -

http://www.imaginit.com/software/imaginit-utilities-other-products/utilities-for-revit

Re: Import Excel Into Revit

Irich — Wed, 07 Jun 2017 13:22:43 GMT

That's great! Thanks for the info.

Re: Import Excel Into Revit

madyb — Mon, 12 Jun 2017 17:16:47 GMT

I have been working this problem myself. We have General Notes and Special Inspections in Excel. The do import fine into AutoCAD, but if you have a very long spreadsheet you have to break it up using viewports. This is just fine for AutoCAD but inserting into REVIT in comes in as the whole long spreadsheet and I can not get the borders to not plot.

Re: Import Excel Into Revit

ToanDN — Mon, 12 Jun 2017 17:40:26 GMT

@madyb

You can break the table in AutoCAD using the table break grip, arrange them to fit in the same sheet area as they would in Revit, and link the CAD file in Revit.

Re: Import Excel Into Revit

madyb — Mon, 12 Jun 2017 18:00:41 GMT

@ToanDN

What about getting rid of the Excel borders? In AutoCAD not a problem but when I import to Revit all borders show. I have NO BORDERS set in the Excel spreadsheet.

Re: Import Excel Into Revit

ToanDN — Mon, 12 Jun 2017 19:27:29 GMT

@madyb wrote:

What about getting rid of the Excel borders? In AutoCAD not a problem but when I import to Revit all borders show. I have NO BORDERS set in the Excel spreadsheet.

You can't.

Re: Import Excel Into Revit

Sahay_R — Fri, 28 Jul 2017 14:10:28 GMT

My two cents. When you bring in the linked Excel spreadsheet from AutoCAD per @ToanDN's note, what you get is un-editable and un-formattable in Revit. to edit you will need to go back into Excel and reload all the links. Too fiddly, especially when I am creating content for someone else to use. You can scale it up and down, that's it. Not very helpful when you have company standards that dictate how sheetable items are supposed to look. Learned this the hard way!

Import Excel Into Revit

ccg — Wed, 11 Oct 2017 07:33:17 GMT

I am entering this communication late, and am a new user of this forum, so apologies if this subject is covered elsewhere.

I have been using Revit and AutoCAD for a very long time, and granted, I still haven't really dug deep under the surface of these awesome packages, which have come a long way since when I started (AutoCAD R9!!).

I find it rather disappointing though when Revit, this world-leading BIM package, does not have the capabilities of simply importing a data sheet which has been produced in a fairly well known and relatively widely used spreadsheet program, called Excel? Surely the developers can find a way to link this directly, instead of work-arounds (link into AutoCAD, link into Revit, update links manually etc etc), or copy & paste data to a graphics program (Paint!) and save it to JGP and then import a dead image, repeat process should the original data get updated. I prefer the second option here - at least the appearance and format presented resembles the original spreadsheet.

I feel Revit already costs enough without having to support expensive add-on packages for such simple tasks, especially for occasional use.

Most appreciated,

Ray

Re: Import Excel Into Revit

Irich — Wed, 11 Oct 2017 13:19:34 GMT

I entirely agree with you Ray! It is absurd to not include such a highly useful functionality.

Re: Import Excel Into Revit

Basam.Yousif — Sat, 24 Feb 2018 16:47:56 GMT

@Anonymous wrote:

I know this may not make much sense but....what if I don't have AutoCAD and only have access to Draftsight? I think I can get AutoCAD but I am not 100% sure on that.

Hello there!
Yes you can!

Draftsight does have a similar functionality of AutoCAD to link or import an excel file and embed it into a table. Here isthe article:

http://blog.draftsight.com/2017/08/04/linking-draftsight-excel/

Once you create this, you can link into Revit. Not sure if you can save your files as DWG, but DXF is always an option!

It's also worth noting that neither Draftsight or AutoCAD need any special tools or add-ins to bring in excel data. Standard commands will do just fine.

Re: Import Excel Into Revit

Anonymous — Mon, 12 Mar 2018 12:17:40 GMT

Hello Guys, New to the Group.

Reading through all the posts, I think IMAGINIT (Suggested by SAHAY_R) looks a nice option. I was searching for the same as a method of linking clash reports to the projects progress directory. Linking Excel data to a project is very useful also, can add much value to information capturing if provided. And using AutoCad to convert your excel Data to a dead image doesn't sound very functional and helping.

Re: Import Excel Into Revit

Anonymous — Mon, 19 Mar 2018 17:58:31 GMT

How do you handle the "Import templates"? I am a bit confused about those. I made a schedule in excel that I need to import.

Re: Import Excel Into Revit

apadillami6 — Mon, 23 Apr 2018 18:00:23 GMT

It works ??and for what version 17, 18 ??