Import assets
Add many assets, or update the ones you have, from an Excel file in the Import & Export Center: the template with your custom fields, the property path, updates from an export, serial numbers, branches and rows with errors.
Use this import to add many assets at once, with their custom fields, or to change the assets you already have from an exported file.
Where to start
- On Assets, open Assets Settings and select Bulk Import Assets, or
- open the Import & Export Center and select Import on the Assets row.
Import shows to whoever may import assets. The import then follows the steps in Import your data: file, review, import and result. Import the asset types and the properties first: an asset can only name a type and a property your account already has.
Note: Bulk Import Assets now opens this import screen instead of the bulk import page you already know; a batch you had already started on that page stays open for 30 days so you can finish it from Assets Settings › Continue the open import batch. After 30 days the batch page takes you to the new import screen with a message explaining why; the batch's rows are not carried over.
Fill in the template
Select Download template. The Assets sheet has the columns you know — Asset Name, Asset Type, Property, Serial Number, Description, Purchase Date, Purchase Price, Currency Code, Warranty Expires At, Usage Started At, Active, Maintenance Managers, Asset Supervisors, Service Providers and Branch — then one column for each custom field of your account. Columns marked with * are needed on every new asset, required custom fields included, and the drop-down lists hold your account's values. File custom fields are not in the template: upload those files on the asset form. Each custom field needs a label of its own: while two fields share a label, or a field has the same label as one of the columns above, the template does not download until you rename the field in custom fields. Files made from the old template, with or without the Branch column, are read the same way. Save the file as .xlsx.
- Asset Type: a type from the list, in any language. The import never creates a type: add a missing one under Asset Types Management first.
- Property: the property's full path as the list shows it, such as Building > Floor > Unit. Leave it empty for an asset without a property. Only a property in your branches can be named (an account admin can name any); another branch's property is not found. The import never creates a property, and a path that matches two properties (a duplicate, or the same name with an extra space) stops that row until you archive or rename the extra one in properties.
- Serial Number: unique in your account. The serial number of a deleted asset can be used again.
- Purchase Date, Warranty Expires At, Usage Started At: YYYY-MM-DD, for example 2025-01-31.
- Currency Code: from the list; empty adds the asset in SAR, as the asset form does. Active: Yes or No; empty means Yes.
- Maintenance Managers, Asset Supervisors, Service Providers: names from the list, separated by commas. If two people in your account share a name, a name alone does not tell them apart and the row stops: leave the cell as exported (or empty) to keep the current people.
- Custom fields: a Single Choice field takes one option from its list; Multi Choice and Checklist fields take several options separated by commas.
- Branch (accounts with branches): leave it empty to add the asset to its property's branch; an asset without a property goes to the branch you choose when you upload the file. A branch name adds it to that branch; an unknown name, or a branch you are not assigned to, stops that row only.
Tip: Each row is imported on its own. A row that cannot be saved — for example, its property was deleted after you uploaded the file — is listed with its reason, and the other rows are still imported.
Change assets you already have
- On Assets, open Assets Settings, select Export Assets and download the file (see Export your data). Its first column, Asset ID (do not edit), ties each row to its asset; the custom fields come after the core columns.
- Edit the cells you want to change. An empty cell keeps the current value; type
[CLEAR]to empty a field, a custom field included. The name, the type, the currency, the Active column and a required custom field cannot be emptied. - Import the file. Rows you did not change are shown as No change and nothing is written for them.
Updating assets needs the permission to edit them; without it the import only adds new assets and leaves the exported rows out. A value in the first column that is not an asset ID — an asset code, for example — stops that row: leave the column empty for a new asset.
Tip: A new row without an ID whose serial number belongs to an asset you can edit shows a message that names that asset. To update it instead of adding a new one, select Switch to update under the message, or Switch all matching rows to update.
After the import
The result lists the assets created and updated. Select Show them in Assets to open the list on this import's assets only, in the cards and the table; Show all brings the whole list back. Download the error file to fix the remaining rows and import them again as it is.
What's next
- Managing assets — the asset profile, branches and QR codes.
- Import asset types — add the types your assets use before importing them.
- Import properties — add the properties your assets sit on.
- Import your data — the four import steps and the error file.
- Export your data — export the list to edit it, then import it back.
- Custom fields — the extra fields that become template columns.