From the course: AutoCAD Plant 3D Essential Training: User
Join today to access over 24,500 courses taught by industry experts.
Importing and exporting project data to Excel spreadsheets
From the course: AutoCAD Plant 3D Essential Training: User
Importing and exporting project data to Excel spreadsheets
- [Instructor] One of the most powerful features of Plant 3D is that we can export the data into an Excel spreadsheet and make the edits externally. Once complete, we just simply import the spreadsheet and have the revised data pushed into the drawings. I'm going to demonstrate this by exporting an equipment list, adding some data and then reimporting the data into the Plant 3D drawing. Let's go ahead and open 07_05_DATA. Now, we're going to look in Data Manager and we're going to look through into our current drawing and we're going to just filter for pumps. Now, you should see three centripetal pumps here. Now, what I'm going to do is I'm going to export this, I'm going to add some information such as the manufacturer, another couple little pieces of information we can add in and when we import this back in it should batch update that manufacturer field inside Data Manager and also inside each piece of equipment. The way we do this is we filter through what we want to see and then…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.