Importing Tracking Devices

Updated by Chris Harley

Use Import devices to register many tracking devices at once from an Excel file, and optionally link each one to the serialized item it is attached to. To register a single device, see Registering a Tracking Device.

Preparing the file
  1. Open Asset Tracking in the left menu and select Tracking Devices.
  2. Click Import devices.
  3. Click Sample Template to download the Tracking Devices template.
  4. Enter one device per row and save the file as an Excel (.xlsx) file. The column names must remain exactly as shown in the template.
ColumnContents
Serial NumberRequired. The serial number from the label on the device. Spaces, dashes, colons and periods are ignored. Each serial number can appear only once in the file. If a serial number starts with zero, format the column as Text so Excel keeps the leading zero.
Asset NumberOptional. The Item ID of the serialized item the device is attached to. Leave it blank to register the device without linking it. The item must be in one of your locations and must not already have a tracking device. Each item can appear only once in the file.
Importing the file
  1. Click Import devices and select the file.
  2. Review the preview. Rows that cannot be imported are marked with the reason, for example a device that is already registered, a serial number that ToolHound did not ship to your company, or an Item ID that does not exist or already has a device.
  3. Click Import. Valid rows are imported; rows with errors are skipped.
  4. If any rows were skipped, download the failed rows, correct them and import that file again.
A file can hold up to 500 devices; import a larger fleet as several files. ToolHound reads only the first sheet of the workbook. Every device must be one that ToolHound has shipped to your company.
Importing the same file again is safe. Devices that are already registered are not registered twice.

See also:

Copyright © 2020-2026 ToolHound Inc. All Rights Reserved.

How did we do?