The Export Wizard in Asset Tracker allows you to download a CSV file of your current asset view, making it easier to review, share, or work with your data outside the platform.
Common use cases include generating a list of assets due for rental return or preventive maintenance, or preparing a CSV file for a bulk update using the Import Wizard. For example, you might export a set of assets that need their Asset Type updated, modify the CSV file, and then re-import it using the Import Wizard to apply the changes.
Topics include:
-
You must be assigned to Asset Tracker Administrator or User role.
-
The Export Wizard can be accessed from both the Asset Management menu and also the Settings > Assets menu.
For the best experience, we recommended accessing the Export Wizard from the Asset Management menu.
The Settings > Assets view displays a maximum of 250 assets, and the Export Wizard only exports the assets currently displayed in the view.
-
To limit the export to specific assets, apply filters before opening the wizard. This allows you to export only the data relevant to your task.
-
From the wizard, you can select and reorder the fields to include in the export to meet your reporting or data requirements
-
Dates in the CSV file follow the YYYY-MM-DD format (e.g., 2025-07-13), adhering to the ISO 8601 standard.
-
If you plan to use the export CSV file to perform a bulk update via the Import Wizard, refer to the section Important guidelines when using third-party apps to update a CSV file to update the CSV file.
-
From the left menu, select Asset Management.
-
(Optional) Apply filters to export specific assets.
-
Select Export Wizard.
-
The wizard includes system-default selected fields.
To customize the data exported, you can:
Select or deselect all columns
Reorder the columns
Select which columns to include or exclude (select a column).
-
(Optional) To include the assets’ custom attributes (user-defined fields based on their Asset Type), enable Export all custom attributes.
In the CSV file, custom attribute columns do no include “Kio” in the column name.
-
When ready, select Export CSV.
The file is automatically downloaded to your computer's default download location.
This section defines each field included in the exported CSV file.
Note
Field names (column headings) must remain unchanged if you plan to use this file to import and update existing assets via the Import Wizard. Modifying a column heading will prevent the import process from recognizing or applying updates correctly.
If Export all custom attributes was enabled during the export, the custom attribute data does not include "Kio" at the beginning of the column name.
|
Column heading (field name) |
Definition |
|---|---|
|
*Kio:External ID |
The system's unique identifier of the asset Displayed within Asset Tracker as the Asset ID NoteTo change this value, add column Kio:New External ID and provide the value of the External ID the asset is to be changed to. |
|
Kio:Type |
The Asset Type assigned to the asset When adding or updating, this value must be the name of an Asset Type displayed within Asset Tracker. |
|
Kio:Name |
Name of the asset; maximum of 35 characters. Displayed in Asset Tracker as an asset's Name. |
|
Kio:Manufacturer |
Manufacturer of the asset |
|
Kio:Next PM Date |
Date of the next scheduled preventive maintenance |
|
Kio:Acquisition Rental Due Date |
Date of the Rental return/due date; Acquisition Method is RENTAL Dates in the CSV file follow the YYYY-MM-DD format (e.g., 2025-07-13), adhering to the ISO 8601 standard. |
|
Kio:Tag status |
System-generated status determined by an asset's state and its assigned Tag. Possible values (one of):
|
|
Kio:Last Location Campus ID |
ID of the Campus where the asset was last located |
|
Kio:Last Location Campus Name |
Name of the Campus where the asset was last located |
|
Kio:Last Location Building ID |
ID of the Building where the asset was last located |
|
Kio:Last Location Building Name |
Name of the Building where the asset was last located |
|
Kio:Last Location Floor ID |
ID of the Floor where the asset was last located |
|
Kio:Last Location Floor Name |
Name of the Floor where the asset was last located |
|
Kio:Last Location Room ID |
ID of the Room where the asset was last located |
|
Kio:Last Location Room Name |
Name of the Room where the asset was last located |
|
Kio:Last Location Department ID |
ID of the Department where the asset was last located |
|
Kio:Last Location Department Name |
Name of the Department where the asset was last located |
|
Kio:Tag ID |
The 12-character MAC address of the Kontakt.io Tag BLE assigned to the asset. |
|
Kio:Status |
Read-only system generated value of the current status of the asset; status is not displayed within the Asset Tracker app. System value (one of):
|
|
Kio:Virtual Tag ID |
Reserved for future use. This field is not currently applicable and can be left blank. |
|
Kio:Staff Role |
Reserved for future use. This field is not currently applicable and can be left blank. |
|
Kio:Home Campus ID |
ID of the asset's assigned Home Campus |
|
Kio:Home Building ID |
ID of the asset's assigned Home Building |
|
Kio:Home Floor ID |
ID of the asset's assigned Home Floor |
|
Kio:Home Room ID |
ID of the asset's assigned Home Room |
|
Kio:Home Department |
Name of the asset's assigned Home Department |
|
Kio:Home Department ID |
ID of the asset's assigned Home Department |
|
Kio:Model |
Model number of the asset |
|
Kio:Serial Number |
Serial number of the asset |
|
Kio:PM Required |
Indicates if preventive maintenance is required (tracked) Allowed system value: TRUE or FALSE |
|
Kio:Acquisition Date |
Date the asset was acquired Dates in the CSV file follow the YYYY-MM-DD format (e.g., 2025-07-13), adhering to the ISO 8601 standard. |
|
Kio:Acquisition Method |
Method of acquisition Allowed system value: RENTAL or PURCHASED |
|
Kio:Acquisition Return Date |
Expected return date of the leased/rented asset Dates in the CSV file follow the YYYY-MM-DD format (e.g., 2025-07-13), adhering to the ISO 8601 standard. |
|
Kio:Groups |
Custom groups/tags the asset belongs to |
|
Kio:Lost |
Read-only system value for information purposes. Indicates whether the asset is marked as lost (TRUE, FALSE) |
When editing CSV files using third-party applications like Excel or Google Sheets, automatic formatting may misinterpret data (e.g., converting long numeric strings to scientific notation), which can lead to errors during import.
Follow these guidelines to ensure compatibility:
-
Open Excel and create a new blank workbook.
-
Go to the Data tab.
-
Select From Text/CSV in the Get External Data section.
-
Locate and import your CSV file.
-
For each column, set the data type to Text. By specifying the columns as a text format, Excel preserves the original data format.
Do not select General or any other format.