# Data.Import Excel

**URL:** <https://forum.dynamobim.com/t/data-import-excel/94204>\
**Category:** Revit\
**Tags:** revit, excel, dynamo\
**Created:** [October 2, 2023, 12:01pm UTC](https://forum.dynamobim.com/t/data-import-excel/94204 "2023-10-02T12:01:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bartosz.wielogorskiT](https://avatars.discourse-cdn.com/v4/letter/b/3ec8ea/32.png) [@bartosz.wielogorskiT](https://forum.dynamobim.com/u/bartosz.wielogorskiT)\
**Post date:** [October 2, 2023, 12:01pm UTC](https://forum.dynamobim.com/t/data-import-excel/94204/1 "2023-10-02T12:01:42Z")

</div>

Hello,  
I have a problem with node “Data.Import Excel”. “File From Path” node seem to be ok. I tested this script on other computers with the same Revit and Dynamo version and every other users has not this bug.

Revit 2020.2.9  
Dynamo Core 2.3.2.15696  
Dynamo Revit 2.3.2.15724

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/0/c0495e1d5da69b1322ebc37ed40dcfc736edb860.jpeg)

---

<div class="post-metadata">

**Author:** ![Draxl\_Andreas](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/draxl_andreas/32/145744_2.png) [@Draxl\_Andreas](https://forum.dynamobim.com/u/Draxl_Andreas)\
**Post date:** [October 2, 2023, 12:38pm UTC](https://forum.dynamobim.com/t/data-import-excel/94204/2 "2023-10-02T12:38:00Z")

</div>

@bartosz.wielogorskiT ,

can you do the workaround with

[https://dictionary.dynamobim.com/#/Office/Excel/Action/ReadFromFile](https://dictionary.dynamobim.com/#/Office/Excel/Action/ReadFromFile)

KR

Andreas

---

<div class="post-metadata">

**Author:** ![bartosz.wielogorskiT](https://avatars.discourse-cdn.com/v4/letter/b/3ec8ea/32.png) [@bartosz.wielogorskiT](https://forum.dynamobim.com/u/bartosz.wielogorskiT)\
**Post date:** [October 2, 2023, 1:22pm UTC](https://forum.dynamobim.com/t/data-import-excel/94204/3 "2023-10-02T13:22:44Z")

</div>

I found a solution,  
The bug was in Microsoft 365 Apps program.  
I made "Online Repair " in Control Panel and node works well.

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [October 2, 2023, 1:25pm UTC](https://forum.dynamobim.com/t/data-import-excel/94204/4 "2023-10-02T13:25:45Z")

</div>

> [@bartosz.wielogorskiT](#):
>
> I have a problem with node “Data.Import Excel”.

Near 100% certainty this is an issue with your office installation; Basically every time you update office MS breaks it’s own registry keys causing the interop tool to fail. There are online repairs for this, but in my experience you will be fighting it at every update/patch/anything from MS for the rest of the life of the system.

There are some options on how to get working again.

1. Utilize another format (CSV)
2. Upgrade to a supported Revit/Dynamo build with the new OpenXML excel nodes
3. Use a 3rd party package that leverages the OpenXML method (I think there is one called ExcelReader, but I can’t recall)

My advice is to go to CSV - you can open and save them with Excel natively, or import the data as a link to ensure formulas and such work.

---

<div class="post-metadata">

**Author:** ![bartosz.wielogorskiT](https://avatars.discourse-cdn.com/v4/letter/b/3ec8ea/32.png) [@bartosz.wielogorskiT](https://forum.dynamobim.com/u/bartosz.wielogorskiT)\
**Post date:** [October 2, 2023, 1:43pm UTC](https://forum.dynamobim.com/t/data-import-excel/94204/5 "2023-10-02T13:43:38Z")

</div>

Thank you for the advice.
