Import your asset inventory
Upload a spreadsheet of existing assets with a full check before anything is saved.
For public works managers · Updated
Before you start
Create your asset types first (Assets → Types), with an inspection interval if they're inspected on a schedule. Each row's type must match an existing type name.
Import
- Open Assets → Import and choose your CSV file (UTF-8, up to 5 MB and 10,000 rows).
- Choose Check the file. Every row is validated.
- If there are problems, nothing will be imported; the list tells you which rows to fix.
- If every row passes, choose Import.
Columns
Required: asset_tag, name, asset_type. Optional: department, location_text, latitude, longitude, status, condition (1–5), acquired_on, last_inspected_on, cost, manufacturer, model_number, serial_number, notes. Dates can be YYYY-MM-DD or MM/DD/YYYY. Assets with coordinates appear on the map.
Was this article helpful?