To Export and Import Spec Data

To export spec or catalog data to Excel

1. In the Spec Editor 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 edit exported spec data

1. Open the exported Excel file.
2. Go to the tab of the part you want to edit.
3. Edit the content you want to change.
   
   Note: Some fields are write-protected so they should not be edited.
4. Save the file.

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 2022 Content\\CS300.xlsx).
2. Click the part family 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. Hover over the right corner of the cell and when the mouse changes to a plus symbol, click it and drag over the cells below so they have the same formula.
9. Save the Excel Spreadsheet and exit Excel.

To import spec data from Excel

1. In the Spec Editor toolbar, click Import from Excel.

   The Resolve Excel Import Changes dialog box is displayed.

   
2. Select Only show parts with changes to view just the changes made to the data. All differences are highlighted with yellow.
3. Use the following buttons to review the changes:
   • Accept each change individually.
   • Reject each change individually.
   • Accept all changes.
   • Reject all changes.
4. Click Apply to save the modified spec data.