Export and import spec sheet data using Microsoft Excel spreadsheet.
You can export spec data to a Microsoft Excel spreadsheet, and you can import spec data from the spreadsheet into a spec.
Some restrictions exist when importing data from an Excel spreadsheet:
- You must export using a Full Spec Data Export. This creates a Spec Data worksheet in the exported file.
- You cannot add additional rows to the Spec Data worksheet. Each row contains a PnPID that must match the existing PnPID in the spec.
- You cannot modify read-only properties. Properties that are read-only in the Edit Parts dialog are protected (locked) in the exported spreadsheet.
- You cannot remove or rename columns from the spreadsheet. The header cell that contains the property name is protected.
When importing modified spec information from the spreadsheet, you can accept or reject changes to individual parts.
When you import spec or catalog parts, you can specify which changes to accept and which to reject. Importing data into the Spec Editor is like importing data into the AutoCAD Plant 3D toolset Data Manager.