Transfer Data to and from Excel

Note: The Compare/Update facility can also be used to update drawing data with data from an Excel spreadsheet. Refer to Compare and Update Drawing Data with Data from External Sources.

All the item and drawing data of a drawing can be exported to Microsoft Excel spreadsheets. This data can then be edited in the spreadsheet using Excel facilities and imported back into AVEVA P&ID to update the drawing. Data can be exported from and to a single drawing or a batch of drawings.

Refer to:

• Export Data to Excel

• Edit P&ID Data in an Excel Spreadsheet

• Import Data from Excel

As part of the import procedure, changed data is validated. Invalid changes are highlighted on the spreadsheet so that they can easily be identified and corrected.

The format of the exported spreadsheet and the scope of data that is imported are specified in the Excel Interface Configuration Category of the AVEVA P&ID Project Administration program.

For details of the format of the spreadsheet refer to Format of the Excel Interface Spreadsheet.