Civicade

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

  1. Open Assets → Import and choose your CSV file (UTF-8, up to 5 MB and 10,000 rows).
  2. Choose Check the file. Every row is validated.
  3. If there are problems, nothing will be imported; the list tells you which rows to fix.
  4. 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?