Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
Professional CAD/CAM tools built on Inventor and AutoCAD
Any referenced datasets can be downloaded from "Module downloads" in the module overview.
Transcript
00:01
In this session, we will discuss exporting data to Excel.
00:04
We have a completed and organized graph
00:06
already in Dynamo with the intent
00:08
to export that information and share with the project team.
00:12
We are in the final step of importing and exporting
00:15
data workflow.
00:16
Let's get started by switching over to Civil 3D
00:19
and Dynamo my drawing file already open since the graph
00:23
that I'm working with is connected
00:24
to this particular drawing file to open Dynamo.
00:28
We want to head to the Manage tab visual programming panel
00:32
and click on the Dynamo icon.
00:35
Once inside the Dynamo interface we're
00:37
going to open alignment stoichiometry table begin first
00:42
run the graph.
00:43
So that the data is captured from the current drawing file
00:47
the graph is complete with alignment geometry stations
00:50
and coordinate values and our list is organized.
00:54
The final step in this process is
00:56
to export in the Dynamo library under the import export
01:02
category under the data subcategory.
01:05
We have the option to export CSV or Excel.
01:09
Click the Export Excel to add the node to the workspace
01:15
starting at the top left.
01:16
We need to specify the location of the file.
01:19
The data will write to in the import
01:21
export category underneath file system subcategory.
01:26
We're going to scroll down and click on File path
01:31
to add that no to our workspace and moving into place.
01:35
Click browse on the file path node and locate
01:38
the existing Excel document.
01:42
Let's take a look at the Excel document that we just path to.
01:47
As you noticed this alignment data result Excel spreadsheet
01:50
that I've path to is empty and it currently
01:53
has one tab at the bottom by the name of sheet one
01:57
will want to take note of the capitalization.
01:59
So that way we can entered into the node back in Dynamo.
02:03
For now, we need to close out of this document.
02:05
Otherwise Dynamo will give us an error because the document is
02:08
open and it cannot write as read.
02:10
Only it's important to note the Dynamo will not create an Excel
02:14
spreadsheet from scratch.
02:16
So we need the path to an existing Excel spreadsheet
02:19
document before we connect to it.
02:23
Lastly, we connect the output to the input sheet name
02:28
is expecting a string data type.
02:31
So we add a string node to the workspace
02:36
and we enter the name of the tab that we just viewed.
02:38
And it is case sensitive, so we'll enter in sheet 1
02:42
and connect to the input for the Export Excel node rights data
02:50
by rows with sub list written in successive rows both rows
02:54
and columns are 0 indexed meaning a 0 value start
02:58
corresponds to sell a 1 in Excel.
03:01
The only way to skip columns and/or rows
03:04
would be to insert empty values in your data list
03:07
prior to importing that into your data Excel.
03:10
Node will add a number node to the graph
03:16
and enter 0 and connect that to the start row
03:22
and start column input values the data input
03:27
port accepts a variable.
03:29
So we will connect the list transpose data
03:31
node right to the data input our last input value will
03:36
be to overwrite existing data in the Excel document,
03:42
we will add a Boolean node since we are writing data
03:47
to an empty document.
03:49
And this is our first pass at exporting
03:51
we'll just add true to overwrite the data in the existing
03:54
document connect the data ports and run
03:58
the graph at this point, the Excel document
04:01
should open and display the exported information.
Video transcript
00:01
In this session, we will discuss exporting data to Excel.
00:04
We have a completed and organized graph
00:06
already in Dynamo with the intent
00:08
to export that information and share with the project team.
00:12
We are in the final step of importing and exporting
00:15
data workflow.
00:16
Let's get started by switching over to Civil 3D
00:19
and Dynamo my drawing file already open since the graph
00:23
that I'm working with is connected
00:24
to this particular drawing file to open Dynamo.
00:28
We want to head to the Manage tab visual programming panel
00:32
and click on the Dynamo icon.
00:35
Once inside the Dynamo interface we're
00:37
going to open alignment stoichiometry table begin first
00:42
run the graph.
00:43
So that the data is captured from the current drawing file
00:47
the graph is complete with alignment geometry stations
00:50
and coordinate values and our list is organized.
00:54
The final step in this process is
00:56
to export in the Dynamo library under the import export
01:02
category under the data subcategory.
01:05
We have the option to export CSV or Excel.
01:09
Click the Export Excel to add the node to the workspace
01:15
starting at the top left.
01:16
We need to specify the location of the file.
01:19
The data will write to in the import
01:21
export category underneath file system subcategory.
01:26
We're going to scroll down and click on File path
01:31
to add that no to our workspace and moving into place.
01:35
Click browse on the file path node and locate
01:38
the existing Excel document.
01:42
Let's take a look at the Excel document that we just path to.
01:47
As you noticed this alignment data result Excel spreadsheet
01:50
that I've path to is empty and it currently
01:53
has one tab at the bottom by the name of sheet one
01:57
will want to take note of the capitalization.
01:59
So that way we can entered into the node back in Dynamo.
02:03
For now, we need to close out of this document.
02:05
Otherwise Dynamo will give us an error because the document is
02:08
open and it cannot write as read.
02:10
Only it's important to note the Dynamo will not create an Excel
02:14
spreadsheet from scratch.
02:16
So we need the path to an existing Excel spreadsheet
02:19
document before we connect to it.
02:23
Lastly, we connect the output to the input sheet name
02:28
is expecting a string data type.
02:31
So we add a string node to the workspace
02:36
and we enter the name of the tab that we just viewed.
02:38
And it is case sensitive, so we'll enter in sheet 1
02:42
and connect to the input for the Export Excel node rights data
02:50
by rows with sub list written in successive rows both rows
02:54
and columns are 0 indexed meaning a 0 value start
02:58
corresponds to sell a 1 in Excel.
03:01
The only way to skip columns and/or rows
03:04
would be to insert empty values in your data list
03:07
prior to importing that into your data Excel.
03:10
Node will add a number node to the graph
03:16
and enter 0 and connect that to the start row
03:22
and start column input values the data input
03:27
port accepts a variable.
03:29
So we will connect the list transpose data
03:31
node right to the data input our last input value will
03:36
be to overwrite existing data in the Excel document,
03:42
we will add a Boolean node since we are writing data
03:47
to an empty document.
03:49
And this is our first pass at exporting
03:51
we'll just add true to overwrite the data in the existing
03:54
document connect the data ports and run
03:58
the graph at this point, the Excel document
04:01
should open and display the exported information.
How to buy
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © 2025 Autodesk Inc. All rights reserved
Sign in to start learning
Sign in for unlimited free access to all learning content.Save your progress
Take assessments
Receive personalized recommendations
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement. May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.