Export and Import Spec Data

To export spec or catalog data to Excel

  1. In the toolbar, click Export to Excel.
  2. In the Export Data dialog box, under Select Export Settings, click the appropriate export setting.

    If you plan to modify and import the data, use a full data export.

  3. In the box labeled Enter a File Name and Location For Exported Data, click Browse.
  4. In the Save As dialog box, in the File Name box, enter a name for the exported file. Navigate to and click a folder in which to save the file.
  5. Click Save.

To change a spec part description using Excel formulas

  1. Open a spreadsheet that was exported from a spec (for example:C:\AutoCAD Plant 3D 2015 Content\\CS300.xlsx).
  2. Click the Spec Data tab to make it the active worksheet.
  3. Right-click the header of the Part Size Long Desc column. Click Format Cells.
  4. In the Format Cells dialog box click General.

    If the cell type is Text, you cannot create a formula.

  5. Click OK.
  6. Click to highlight a cell that you want to modify (for example: F2).
  7. In the Formula bar, enter a formula. For example:
    =G2 & " w. hand lever , " & H2 & "nd, " & I2 & ", " & AB2 & "lb ," & X2
  8. Right-click the cell. Click copy.
  9. Paste the formula to additional cells.
  10. Save the Excel Spreadsheet and exit Excel.
Parent topic: Export and Import Spec Data