After much effort you've developed an amazing schedule in Revit but now that information is needed in another format for another reason. Could be for further development as room data sheets or programming. Following are simple steps for exporting any scheduled information out to Excel.
From the active schedule view browse through File - Export - Reports - Schedule. Assign a name and location for what will be the Delimited text (*.txt) file.
Launch Excel and from the Data tab -From Text browse to the location and file that was created on export from Revit and select Import. I'm sure the next three dialogue boxes offer amazing Excel features but I'm a Revit user not an Office user so I tend to leave these on their default settings.
From the active schedule view browse through File - Export - Reports - Schedule. Assign a name and location for what will be the Delimited text (*.txt) file.
Launch Excel and from the Data tab -From Text browse to the location and file that was created on export from Revit and select Import. I'm sure the next three dialogue boxes offer amazing Excel features but I'm a Revit user not an Office user so I tend to leave these on their default settings.
After clicking finish the Import Data dialogue box pops. I usual leave this as default as well.
The end results should be an Excel worksheet that mimics the schedule that was created in Revit. Revit Yes/No check box parameters are reported as either Yes or No text fields in Excel. Formatting isn't great but it's a good starting point for using this data outside of the BIM. Links could be made between worksheets so that as exports are updated the links refresh the data sets. It would be nice if we could go back the other way and populate changes in the Revit model; not sure we can do that...yet.
No comments:
Post a Comment