From the course: AutoCAD Facilities Management: Areas

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Editing exported area table data in Excel

Editing exported area table data in Excel - AutoCAD Tutorial

From the course: AutoCAD Facilities Management: Areas

Start my 1-month free trial

Editing exported area table data in Excel

“

- [Voiceover] So as you can see we're still in 00 ground FM TDATA.dwg. And in the previous video we exported out our table data to an Excel CSV comma delimited file. So what I'm gonna do now is just quickly jump down to my taskbar and I'm gonna open up Excel here, and as you can see, there's the CSV file that we exported out. Now there's not a lot of data there, but I'll just expand these fields, I'll just do the double-click thing in Excel to make sure we can see. So there's AREA TABLE, there's the name of the CSV file, and there's the two columns that came out. So basically what we've got, there's title, there's the headers, and there's the data that's come out of our table. Now at the moment it is a CSV file, so what you do now is you'd save that out, so you do File, and you do a Save As, and you save that now instead of a CSV there, I'm actually running Office 365 if you're not used to this interface, and what I'll do there is I'll save that out now as a regular Excel Workbook…

Contents