.. _export-data-sheet-layout:

Export data sheet layout
------------------------

This topic explains formatted and unformatted exported sheets containing data.


.. rubric:: General structure 

* **Header and columns**: The header and column layout of formatted and unformatted sheets correspond with the 
  bulk load template sheet.
* **# Comment column**: Displays "Exported data" in green for each row of data.
* **# Hierarchy Node column**: Indicates the source hierarchy of each exported row. 
* **Sheet header (hierarchy)**: Shows the hierarchy used during export.


.. rubric:: Key columns 

* **# Device**: Lists the device's business key (for example, host, port, hierarchy) if device data 
  is exported.
* **# CFT Template**: Displays the name of the applied configuration template (if used), 
  also shown in the header. For example, if it applied to the Admin Portal form, the *# CFT Template* column
  will show this name for each row, as well as the *template* value in the sheet header. 
  If the sheet is used for loading, row values override header values.

* **# Unique Identifier (pkid)**: 

  * Identifies the exported resource in each row.
  * Used for modify, delete, execute, and custom actions to identify the resource instance on the database 
    represented in the row data.
  * Takes precedence over search fields.
  * Unique to the resource on the particular database. Cannot be reused across different databases.


.. rubric:: Sheet types 

* **Formatted Excel Export**: Columns match the bulk load template sheet. 
* **Unformatted Excel Export**: Columns reflect the properties of an exported JSON file 
  (only non-empty strings and boolean values are included).


.. rubric:: Reusability

* Formatted, export sheets can be used as bulk load templates to bulk load data 
* For other actions, complete the **# Search Fields** column. Refer to :ref:`bulk-load-sheet-layout`.
* Remove *Default* values from ungrouped fields before bulk loading. 


.. rubric:: Limitations 

* Excel cell content is limited to the maximum length allowed in a Microsoft Excel cell (32 767 characters).  
* Longer property values will be truncated in the exported sheet.