Import assets

​

Overview

Use Import in the asset register when you want to add many assets without creating them one by one. Teamper lets company admins upload a UTF-8 CSV, map source columns, review every row, and save the import only after the preview is valid. This flow is create-only. It does not update existing assets, and Teamper blocks the whole import if any row still needs fixing.

​

Who can use this

• Company admins in companies where the asset_tracking module is enabled

​

Before you start

• Make sure the assets you want to import do not already exist in the same company with the same asset_code
• Make sure any assignee email in the CSV belongs to an invited or active employee in the current company
• Save the file as UTF-8 CSV if your spreadsheet tool gives you multiple export options
• Keep the import to 200 asset rows or fewer after blank rows are removed

​

What you can import

Required mappings:

• Asset code
• Name

Optional mappings:

• Category
• Serial number
• Purchase date
• Purchase cost
• Warranty expires on
• Assignee email
• Notes

​

How the import behaves

• Teamper treats asset_code as the unique create key for this flow.
• The import only creates new assets. It does not update an existing asset with the same asset_code.
• Teamper trims extra spaces before checking asset_code, name, category, serial_number, notes, and assignee_email.
• asset_code matching is case-insensitive, so values such as LAP-001 and lap-001 count as the same code.
• A blank assignee_email creates the asset as available.
• A matched assignee_email creates the asset as assigned.

​

Step-by-step guide

​

1. Upload the CSV

1. Open Assets.
2. Click Import.
3. Click Download template if you want a starter file.
4. Choose the CSV file.
5. Review the create-only helper copy on the page.
6. Click Analyze file.

​

2. Map your columns

1. Review the suggested mappings on Map your columns.
2. Confirm that Asset code and Name are mapped.
3. Add any optional mappings you want to include.
4. Check the sample values to confirm Teamper is reading the right source column.
5. Leave extra source columns unmapped if you do not need them.
6. Click Preview import.

Teamper accepts flexible source headers. You do not have to match the template headers exactly.

​

3. Review the preview

1. Review the row counts for Create and Needs fixing.
2. Check the derived status for each row.
3. Review the assignee resolution shown for each assignee_email.
4. Review any field-level errors before continuing.
5. Fix the CSV and upload it again if any row is marked Needs fixing.
6. Click Confirm import only when every row is ready.

​

4. Review the result

1. Review the Import complete page after a successful import.
2. Check the created count.
3. Review the row-level results and imported values.
4. Click View assets to return to the register.

​

What happens next

• Teamper creates every valid row in one import transaction after you click Confirm import.
• Imported rows with a matched assignee start as assigned.
• Imported rows without an assignee start as available.
• The result page stays available during the current import flow, but Teamper can clear it when you start a new asset import.

​

Troubleshooting

​

Analyze file does not continue to mapping

Check for an empty CSV, malformed CSV formatting, invalid UTF-8, no asset data rows, or more than 200 asset rows after blank rows are ignored.

​

Preview import says required fields are missing

Check that Asset code and Name are each mapped to a different source column.

​

Preview import shows duplicate or existing asset codes

Check whether the CSV repeats the same asset_code, even with different letter case or extra spaces. Also check whether that asset_code already exists in the current company.

​

Preview import says the assignee email does not match

Check that the email belongs to an invited or active employee in the current company. Archived employees cannot be assigned through this flow.

​

Preview import shows date or cost errors

Check that purchase_date and warranty_expires_on use YYYY-MM-DD, that warranty is not earlier than purchase date, and that purchase_cost is a non-negative decimal with up to two decimal places.

​

Confirm import is disabled

Check whether any row is still marked Needs fixing or whether the CSV file needs to be selected again after a page refresh or after reopening the step.

​

FAQs

​

What is asset CSV import in Teamper?

It is an admin-only bulk import flow for creating new asset records from a CSV file after column mapping and full-row preview.

​

Who can import assets?

Only company admins in companies with asset tracking enabled can open and complete the asset import flow.

​

How do I download the asset import template?

Open Assets, click Import, then click Download template on the start page.

​

Which asset CSV columns are supported?

Teamper supports asset_code, name, category, serial_number, purchase_date, purchase_cost, warranty_expires_on, assignee_email, and notes.

​

Which fields are required for asset import?

You must map asset_code and name. The other supported fields are optional.

​

Can asset import update existing assets?

No. This flow only creates new assets.

​

What happens if an asset code already exists?

Teamper marks that row as invalid in preview and blocks the import until you fix the CSV.

​

What happens if the CSV contains duplicate asset codes?

Teamper marks every duplicate row as invalid in preview and tells you which rows conflict.

​

How does Teamper decide whether an imported asset is available or assigned?

It uses assignee_email. A matched assignee creates the asset as assigned. A blank assignee creates it as available.

​

Which employees can be used as asset assignees during import?

Only invited and active employees in the current company.

​

What happens if assignee email does not match an employee?

The row is marked invalid in preview and the import cannot continue until you fix the CSV.

​

What date and number formats does asset import require?

purchase_date and warranty_expires_on must use YYYY-MM-DD. purchase_cost must be a non-negative decimal with up to two decimal places.

​

What is the maximum number of rows per asset import?

200 asset rows after blank rows are ignored.

​

What happens if one row has an error?

Teamper blocks the whole import and does not save any assets until every row is valid.

​

Where can admins see the import result after confirmation?

Teamper opens an Import complete result page with the created count and row-level summary.

​

Related articles

• Asset tracking
• Leave policies