Excel Import
Import asset data from an Excel spreadsheet to IAH. This allows creating assets in bulk and adding custom properties to the assets.
The admin role with global permission glb_file_import is required to perform the Excel import.
Refer to the Role and Access Management page for more role and permission information.
Warning
By using this feature, you accept responsibility for uploading asset data to IAH. Proceeding indicates your acceptance of these terms.
Import Data
Download the Excel template file to import asset data.
Warning
- Import up to 3000 assets at once, with a maximum of 10 custom properties per asset.
- For each tenant, only 2 import jobs can run at the same time. Additional jobs are queued and start automatically when a running job completes.
If an Excel file contains more than 3000 assets (rows), split it into multiple files, each with no more than 3000 rows. After the standard columns (up to IP address), add up to 10 additional columns for custom properties (such as Location, Department, or Asset Owner). Adding more than 10 custom property columns causes the file import job to fail.
Excel Template Columns
| Column Name | Description |
|---|---|
| Asset name | Name of the asset (e.g. hostname). |
| Asset family | Product family of the asset (e.g., SCALANCE 1500). |
| Article number | Article number of the asset. |
| Description | Description of the asset. |
| MAC address | MAC address of the asset. In format XX:XX:XX:XX:XX:XX or XX-XX-XX-XX-XX-XX where X is 0-9 or A-F (inclusive). |
| Serial number | Serial number of the asset. |
| Vendor | Manufacturer of the asset. |
| Hardware version | Product Version of the asset. |
| Firmware version | Firmware version of the asset. |
| Subnet mask | Network mask that segregates devices belonging to the same sub-network for the asset's IPv4 connectivity. In format X.X.X.X where X is 0-255 (inclusive). |
| Gateway | Router (AKA Gateway) address for the asset's IPv4 connectivity. In format X.X.X.X where X is 0-255 (inclusive). |
| IP address | IPv4 address of the asset. In format X.X.X.X where X is 0-255 (inclusive). |
Note
- Follow the provided template structure. Do not change the name or order of standard columns.
- Ensure that each column name in the Excel file is unique.
- Incorrect or missing data may result in import errors or incomplete asset creation.
- Maximum file size is 5 MB.
Custom Properties
Custom properties store additional asset-specific information (such as location, department, etc.) not covered by the standard columns. Add custom property columns after the standard columns in the Excel template. Each custom property column must have a unique name.
A maximum of 10 custom properties is allowed per asset. This limit includes any user-defined identifier columns, because a user-defined identifier is a custom property column. For example, 2 user-defined identifiers plus 8 regular custom properties reach the limit of 10; adding an 11th custom property column causes the import to fail.
The example column Custom property 1, highlighted in blue in the Excel template, illustrates how to add custom property fields.
Asset Identifier
MAC address is the default asset identifier. If a MAC address is not available, provide a user-defined identifier instead.
To add a user-defined identifier, create a custom property column with the identifier name and suffix '*'. A maximum of 2 user-defined identifiers is allowed. Because user-defined identifiers are custom property columns, they count toward the limit of 10 custom properties per asset (they are not additional to it).
Column names listed in the Excel Template Columns table cannot be used as user-defined identifiers. If such a column name is marked as a user-defined identifier by adding the suffix '*', the '*' suffix is ignored and the column is treated as its standard column (not as a user-defined identifier).
If no asset identifier is provided (neither a MAC address nor a user-defined identifier), that asset entry is skipped and not imported. When more than one user-defined identifier is specified, priority is assigned from left to right based on the column order in the Excel template.
The example column user-defined identifier 1*, highlighted in yellow in the Excel template, illustrates how to add user-defined identifier fields.
Import Errors and Troubleshooting
During the import process, some assets may be skipped or rejected if they do not meet the required criteria. Common reasons and examples are listed below.
Skipped Assets
Assets are skipped if:
- The asset entry has no asset identifier (neither a MAC address nor a user-defined identifier).
- A MAC address, IP address, Subnet mask, or Gateway value is present but not in the correct format.
Note
An empty MAC address cell is not treated as a format error. If the MAC address is left empty, the entry is only skipped when no user-defined identifier is provided. When a valid user-defined identifier is present, the asset is imported using that identifier and the empty MAC address is ignored. Format validation applies only to cells that contain a value.
This exemption applies to an empty MAC address only. A MAC address that is present but malformed always causes the entry to be skipped, even when a valid user-defined identifier is also provided. Correct or clear the malformed MAC address value to import the entry.
Examples of invalid formats:
- A MAC address like "ZZ:ZZ:ZZ:ZZ:ZZ:ZZ" or "123456" causes the asset to be skipped. Use formats like "00:1A:2B:3C:4D:5E".
- An IP address like "999.999.999.999" or "abc.def.ghi.jkl" is invalid. Use formats like "192.168.1.10".
- A malformed MAC address such as "123456" is skipped even when a valid user-defined identifier is present; clear the cell or fix the value.
Rejected Assets
Assets are rejected if:
- The asset entry has invalid values that do not comply with the asset schema. For more details, refer to the Base write schema.
- The imported asset entry uses the same identifier (or combination of identifiers) as an existing asset in the system. In this case, only the conflicting asset entry is rejected; the rest of the import continues and the existing asset is not modified.
- Import asset size is more than 64 KB (including all property values).
- Vendor length is longer than 128 characters.
- Other fields (such as description, asset name, custom property values) are longer than 512 characters.
Ensure the Excel file uses correct formats and reasonable field lengths before importing to avoid errors.