Importing assets from a spreadsheet

Most organisations start with a spreadsheet of assets. You can import it as a CSV file so you don't have to type anything again.

Prepare your file

• Save the spreadsheet as CSV. One row per asset, with a header row.
• Up to 50,000 rows per file.
• Your column names don't need to match ours. You map them during the import.

Columns you can map:

Choose how rows are matched

• Mode. Create only adds new assets and skips rows that already exist. Create or update also updates existing assets.
• Match on. Existing assets are found by asset tag or by serial number.
• Date format. Tell AssetTrove how your dates are written, for example DD/MM/YYYY.

Always do a test run first

Tick Test only (dry run). AssetTrove checks every row and shows exactly what would happen, without saving anything:

• how many assets would be created, updated, skipped or would fail;
• an error for each failing row, with the row number and column, for example "Serial C02XYZ already belongs to LT-0003" or "31/02/2025 is not a valid date";
• warnings that don't stop the row, for example when the person in Assigned To doesn't exist yet.

When the test run looks right, run the import for real.

What happens during the import

• Each row is handled on its own, so one bad row never stops the rest.
• If Assigned To contains the email of an active user, the asset is assigned to them from the moment of the import. If not, the asset is imported unassigned with a warning.
• You can download an error report listing every failed row, fix those rows in your spreadsheet, and import just them again.