In Excel, you modify the worksheet that corresponds to the active node where you plan to import the spreadsheet. If you edit a worksheet that represents a child node, the import process ignores your changes.
It is important not to modify the names of worksheets in an exported Microsoft Excel spreadsheet. The import process uses worksheet names to identify a match with data in the Data Manager.
When you include child nodes in an export to CSV, you create multiple CSV files. You can edit data in the CSV files for import back into the Data Manager.
Some properties, such as PnPID, are read-only in the Data Manager. These read-only properties are also write-protected in an exported Microsoft Excel spreadsheet. While it is possible to edit read-only data in a CSV file, a subsequent import ignores these changes.