Form: Choose Tables to Export as Excel
Use the File menu > Export > SAP2000 MS Excel Spreadsheet .xls File command to export the model definition, analysis results, and design results as a SAP2000 tabular database to a Microsoft Excel Spreadsheet file, usually with an .xls extension.
Note: If objects were selected before the File menu > Export > SAP2000 MS Excel Spreadsheet .xls File command is used, the data for only the selected objects will be exported.
Click the File menu > Export > SAP2000 MS Excel Spreadsheet .xls File command to access the Choose Tables to Export to Excel form.
Check the check box(es) associated with the item(s) to be included in the export.
Click the OK button on the Choose Tables to Export to Excel form to complete the export.
As many files as necessary can be exported from a given SAP2000 model. Each file may contain different tables and/or may apply to different parts of the model. The files may be used for processing by other programs, for modification before re-importing into SAP2000, or for any other purpose. However, if the exported file is to contain a complete description of the model, be sure to export all importable model-definition data for the entire structure.