Skip to main content
GoGuardian Fleet uses CSV files to bulk import or update device information. A correctly formatted CSV lets you set serial numbers, asset IDs, OUs, locations, and student assignments for many devices at once.

​
Understand the CSV Format

Fleet CSV files must include all 6 column headers, in this exact order and with these exact names: Blank cells: Blank cells are treated as null. For most columns, a blank cell preserves the existing value in Fleet. The Loaner column is the exception — it must always contain true/1 or false/0. Importing an existing device: If a device with the same serial number already exists in Fleet, the CSV values overwrite the values in Fleet. For example, if Fleet shows user@school.edu for a device but the CSV shows newuser@school.edu, Fleet updates to newuser@school.edu. The new email must be a valid, existing address in your domain.

​
Create a Fleet CSV File

  1. Open Google Sheets and create a new blank spreadsheet.
  2. In row 1, enter the column headers in order: Serial Number, Asset ID, OU, Location, Student (email), Loaner.
  3. Add device data in the rows below. Only Serial Number and Loaner are required for each row.
  4. Select File → Download → Comma-separated values (.csv, current sheet).
  5. Verify the result: A .csv file downloads to your computer.
Spreadsheet for Fleet Columns A. Serial Number and F. Loaner are highlighted and Marked as Required Fields. Loaner… a GoGuardian CSV template displaying a CSV file with headers for Serial Number, Asset ID, OU, Location, Student…

​
Import Devices into Fleet

  1. Go to fleet.goguardian.com and select the Devices tab.
  2. Click Update Device Data.
  3. Drag and drop your CSV file into the upload panel, or click inside the panel to browse and select the file.
  4. Click Upload CSV.
  5. Verify the result: Devices appear in the Devices tab. See Sync with Google Admin Console to confirm counts match.

​
Sync GAC Data into Fleet via CSV

When Google Admin Console has updated values (such as OU or Asset ID) that are not yet reflected in Fleet, use this method to force GAC values into Fleet:
  1. Export devices from Google Admin Console: go to admin.google.com → Devices → Chrome Devices, select all organizational units, and export to CSV.
  2. Delete all columns except: serial number, orgunitpath, annotatedAssetId, annotatedUser, annotatedLocation.
  3. Rename the column headers to match the Fleet format: Serial Number, Asset ID, OU, Location, Student (email), Loaner.
  4. Add the Loaner column with appropriate true/false values.
  5. Make 2 copies of this file.
  6. In one copy, set the values you want to reset to blank or zero (for example, set all OUs to /). Upload this copy to Fleet — this “zeros out” the fields.
  7. Upload the original copy with the correct GAC values — this pushes the correct values into both Fleet and Google Admin Console.

​
Resources

Last modified on July 15, 2026