Importing devices from your clipboard or a USB barcode scanner can be a very efficient way of performing bulk updates, deprovisioning, or enabling/disabling operations on a set of devices. This method works well with devices whose Asset IDs or SNs live in a document or Sheet, as well as for physically co-located devices, such as a group of machines in a single laptop cart, or as devices are enrolled during unboxing.
You can use this feature to import and make updates to one or more devices by Serial Number or by asset ID.
- From the sidebar, be sure the Load managed devices from tab is selected.
- In the Load managed devices from… field, select List of IDs.
- Place your cursor in the text area and scan a barcode with either device serial number or asset ID, followed by a newline or Enter.
Note: Most scanners ship with a set of configuration barcodes that can be used to make them auto-insert newlines after each scan.
- If you want to include telemetry data in the import, set the Include device telemetry data toggle to ON.
- If you are using Gopher Buddy and want to include that data in Gopher for Chrome, set the Include data collected from the Gopher Buddy extension toggle to ON.
- Click Load to Sheet. Data loads to the Devices tab in the following sections/columns:
Hardware Details (required) Device ID Serial Number Editable Device Properties Org Unit Path Annotated User Annotated Location Annotated Asset ID Notes Hardware Details Model Auto Update Expiration Mac Address Ethernet Mac Address Device Telemetry Battery Health Storage Used Total Storage (GB) Available Storage (GB) Calculated Values (read only-derived from Admin console & lookup tables Number of major Chrome versions behind Latest stable Chrome version for model Most Recent User Reported Activity Last Sync Last Known IP Last Known WAN IP Last Enrollment Time Hardware State Status Major Chrome Version Boot Mode
|

|
Resolving duplicate asset IDs
During manual entry of device id/serial numbers, you may enter the same device id more than once. When there are duplicate IDs, a warning message appears showing how many duplicates there are and a box showing the first 10 duplicates. Load to Sheet is not available while there are duplicates.
To manually resolve duplicate asset IDs:
- Use the list box of the first 10 duplicates to help locate the duplicate in the Serial number box.
- Delete or revise the id as necessary.
- Continue until there are no duplicates.
- Click Load to Sheet.
To remove the duplicates:
- Click Fix it.
- Click Load to Sheet.
|

|
Once you load devices you can make changes in the sheets you can use bulk actions to make changes to the devices.
See also:
Load devices from the Admin console
Load devices from device cache
Load devices from CSV file