Export dimensions to excel.

Export dimensions to excel.

Darwin33
Collaborator Collaborator
1,621 Views
7 Replies
Message 1 of 8

Export dimensions to excel.

Darwin33
Collaborator
Collaborator

I have some dimensions with an specific style that I would like to export to excel. Is this possible?

0 Likes
Accepted solutions (1)
1,622 Views
7 Replies
Replies (7)
Message 2 of 8

L.Maas
Mentor
Mentor
Not sure what you want to export to excel exactly. If it is data then you can create a schedule, export it as .txt file and import that ino Excel.
Other option is to create a Dynamo script, extract the data from Revit and store it in a Excel file

Louis

EESignature

Please mention Revit version, especially when uploading Revit files.

0 Likes
Message 3 of 8

Darwin33
Collaborator
Collaborator

I have placed several dimensions that are not related to specific elements, and I would like to export to an excel list or txt file. I know the procedure to export data linked to families and types, but I am wondering if I can export dimensions.

0 Likes
Message 4 of 8

mhiserZFHXS
Advisor
Advisor

I think we may need to understand the "why" here in order to help... I have no idea what you are asking for.

Message 5 of 8

L.Maas
Mentor
Mentor

Still not sure what you are trying to accomplish. But here a concept with Dynamo.

Here I extract the dimensions and its value. After that I can build out the script to export those length values to Excel.

Of course you can build it up to filter out certain dimensions or extract other information.

LMaas_0-1690376363994.png

 

Louis

EESignature

Please mention Revit version, especially when uploading Revit files.

0 Likes
Message 6 of 8

ToanDN
Consultant
Consultant

So you want to export values of a specific dimension type to excel?

0 Likes
Message 7 of 8

Darwin33
Collaborator
Collaborator

Hallo

 

Thankyou for answer.

 

We have a  plan view with different dimesions types, ie 8mm height for dimensions between pilars, 6mm dimensions between pilars and other diferent elemets, and I want to export only the dimensions related to a height ie al dimensioins red color wiht 6 mm height.

0 Likes
Message 8 of 8

L.Maas
Mentor
Mentor
Accepted solution

Here a concept.

In this case I filter all dimensions in a view and then group them by dimensiontype. Then I take one of the of the groups and have all the values of the dimension belonging to a certain dimensiontype.

LMaas_0-1690456005203.png

LMaas_1-1690456214109.png

 

There are many ways to something similar or expand on it, depending on your needs.

Louis

EESignature

Please mention Revit version, especially when uploading Revit files.

0 Likes