--- title: How do I import assets from a CSV file? description: Import assets into SiteConnect's Asset Register from a CSV file using the provided template, then check the results by email. --- [Skip to content](https://docs.sitesoft.com/import-assets-from-csv#main-content) [![SiteConnect Logos (LinkedIn Post)](https://docs.sitesoft.com/hs-fs/hubfs/SiteConnect%20Logos%20(LinkedIn%20Post).png?width=161&height=26&name=SiteConnect%20Logos%20(LinkedIn%20Post).png)](https://siteconnect.io/gb) Open main navigation Close main navigation - [Portal](https://app.sitesoft.com/) [Portal](https://app.sitesoft.com/) Need help? - There are no suggestions because the search field is empty. 1. [SiteConnect User Guide](https://docs.sitesoft.com/?hsLang=en) 2. [Assets](https://docs.sitesoft.com/assets?hsLang=en) 3. [Set Up Your Asset Register](https://docs.sitesoft.com/assets?hsLang=en#set-up-your-asset-register) # How do I import assets from a CSV file? ## Bring your existing asset list into the Asset Register in one go, instead of adding records one at a time. Import assets from a CSV file so your existing list is added to the Asset Register together, with Asset Types created automatically if they don't already exist. ### At a glance | For | Company administrators | | --- | --- | | Platform | Web Portal | | Applies to | All regions | | Time to Read | About 3 minutes | | You’ll learn how to | • Download and fill in the import template. • Import assets with their required and optional details. • Check your import results | ### Before you begin Make sure you: - Have permission to manage **Assets**. - Have reviewed and created your **Asset Types** and **Asset Subtypes** — see *What are asset types and subtypes?* SiteConnect can create missing Asset Types and Subtypes during import. Creating them first helps prevent duplicate or inconsistent classifications caused by spelling or naming differences. ### Step-by-step guide #### 1. Open the import tool Go to **Assets** in the Web Portal, then select **Import**. ![Screenshot 2026-07-22 143546](https://docs.sitesoft.com/hs-fs/hubfs/Knowledge%20Base%202026/Assets/Set%20Up%20Your%20Asset%20Register/How%20do%20I%20import%20Assets%20from%20a%20CSV%20file/Screenshot%202026-07-22%20143546.png?width=670&height=330&name=Screenshot%202026-07-22%20143546.png)   #### 2. Download the template Select **Download CSV Template** for a correctly formatted starter file. #### 3. Fill in your rows **Name** and **Asset Type** are the only required import fields. Add optional information such as classifications, identifiers, costs and lifecycle dates where relevant. The **Code Prefix** is *not* required when importing assets via CSV. If you choose to leave this field unmapped, the system will automatically generate a prefix based on the **Asset Type**. Auto‑generated prefixes are always **6 characters**, created from the first three letters of each word in the asset type. Examples: - *Motor Vehicles* → **MOTVEH** - *Plant & Equipment* → **PLAEQU** If you **do** map the Code Prefix field in your CSV, the value must be **between 3 and 6 characters**. Any prefix shorter than 3 characters or longer than 6 characters will be rejected during import. #### Use the accepted field values The **Status**, **Condition Rating** and **Owner Type** fields use predefined values. Enter the wording exactly as shown. | **Field** | **Accepted values** | | --- | --- | | Status | Active/Operational Standby Under Repair Out of Service In Storage/Stock Decommissioned Sold Scrapped/Disposed | | Condition Rating | Excellent Good Fair Poor Unsafe | | Owner Type | Owned Leased Hired Contractor Owned | Do not use alternative wording or abbreviations in these fields. #### Turn asset settings on The template includes three Yes/No settings: - **Visible on Mobile app?** - **Mobile Asset?** - **Safety Critical?** Enter **Yes** in each column where you want that setting turned on. You can enter **Yes** in more than one column for the same asset. Leave the cell blank when the setting does not apply. For example, an asset that needs to appear in the Mobile App and is safety-critical can have **Yes** under both **Visible on Mobile app?** and **Safety Critical?**. **Note** Use a consistent day-first date format, such as DD/MM/YYYY, and check the imported records afterwards. If SiteConnect cannot read a date, the row may still import successfully, but the date is left blank. #### 4. Upload and map your columns Select **Select & Upload CSV File**, map each column to the matching field, then select **Import Assets**. ![image\_2026-07-22\_144932703](https://docs.sitesoft.com/hs-fs/hubfs/Knowledge%20Base%202026/Assets/Set%20Up%20Your%20Asset%20Register/How%20do%20I%20import%20Assets%20from%20a%20CSV%20file/image_2026-07-22_144932703.png?width=670&height=333&name=image_2026-07-22_144932703.png) ### Result You’ll know the import is complete when you receive an email showing how many rows were imported or failed, including the reason for each failed row. Imported assets then appear in the **Asset Register**. Sites cannot currently be linked through the asset CSV import. After importing, link each asset to the appropriate site. ### Next recommended step Find out how the QR code on each imported asset works. **Next article:** [How do asset QR codes work?](https://docs.sitesoft.com/how-do-asset-qr-codes-work?hsLang=en) - [About SiteConnect](https://docs.sitesoft.com/about-siteconnect?hsLang=en) - [Get Started](https://docs.sitesoft.com/get-started?hsLang=en#main-content) - [Understand Roles & Permissions](https://docs.sitesoft.com/get-started?hsLang=en#understand-roles-permissions) - [Manage Roles & Permissions](https://docs.sitesoft.com/get-started?hsLang=en#manage-roles-permissions) - [Assets](https://docs.sitesoft.com/assets?hsLang=en#main-content) - [Getting Started With Assets](https://docs.sitesoft.com/assets?hsLang=en#getting-started-with-assets) - [Set Up Your Asset Register](https://docs.sitesoft.com/assets?hsLang=en#set-up-your-asset-register) - [Manage Your Assets](https://docs.sitesoft.com/assets?hsLang=en#manage-your-assets) - [Manage Asset Safety](https://docs.sitesoft.com/assets?hsLang=en#manage-asset-safety) - [Troubleshoot Assets](https://docs.sitesoft.com/assets?hsLang=en#troubleshoot-assets) - [Account](https://docs.sitesoft.com/account?hsLang=en#main-content) - [Company Documents](https://docs.sitesoft.com/account?hsLang=en#company-documents) - [Charts & Graphs](https://docs.sitesoft.com/charts-graphs?hsLang=en) - [Contractors](https://docs.sitesoft.com/contractors?hsLang=en) - [Covid-19 Module](https://docs.sitesoft.com/covid-19-module?hsLang=en) - [Digital Signatures](https://docs.sitesoft.com/digital-signatures?hsLang=en) - [Employees](https://docs.sitesoft.com/employees?hsLang=en#main-content) - [Documents](https://docs.sitesoft.com/employees?hsLang=en#documents) - [Export](https://docs.sitesoft.com/employees?hsLang=en#export) - [Forms](https://docs.sitesoft.com/employees?hsLang=en#forms) - [Form Builder](https://docs.sitesoft.com/form-builder?hsLang=en) - [Hazards/Risks](https://docs.sitesoft.com/hazards-risks?hsLang=en#main-content) - [hazards/risks in mobile app](https://docs.sitesoft.com/hazards-risks?hsLang=en#hazards-risks-in-mobile-app) - [Incidents](https://docs.sitesoft.com/incidents?hsLang=en) - [Inductions](https://docs.sitesoft.com/inductions?hsLang=en) - [Inspections/Audits](https://docs.sitesoft.com/inspections-audits?hsLang=en) - [Messages](https://docs.sitesoft.com/messages?hsLang=en) - [My Pre-Qualifications](https://docs.sitesoft.com/my-pre-qualifications?hsLang=en) - [Notifications](https://docs.sitesoft.com/notifications?hsLang=en) - [TA/JSA/SWMS/RAMS](https://docs.sitesoft.com/ta-jsa-swms-rams?hsLang=en) - [Tasks](https://docs.sitesoft.com/tasks?hsLang=en) - [Templates](https://docs.sitesoft.com/templates?hsLang=en#main-content) - [Hazardous Substances/COSHH](https://docs.sitesoft.com/templates?hsLang=en#hazardous-substances-coshh) - [Documents](https://docs.sitesoft.com/templates?hsLang=en#documents) - [Reporting](https://docs.sitesoft.com/reporting?hsLang=en) - [Sites and Subsites](https://docs.sitesoft.com/sites-and-subsites?hsLang=en) - [Safety Observations](https://docs.sitesoft.com/safety-observations?hsLang=en) - [SiteConnect Mobile App](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#main-content) - [Site Induction](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#site-induction) - [Toolbox Talks](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#toolbox-talks) - [Tasks](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#tasks) - [Troubleshooting](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#troubleshooting) - [Incidents](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#incidents) - [Forms](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#forms) - [Inspections/Audits](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#inspections-audits) - [User Profile](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#user-profile) - [Sign Out](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#sign-out) - [Geofencing](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#geofencing) - [Training](https://docs.sitesoft.com/siteconnect-mobile-app?hsLang=en#training) - [Sites](https://docs.sitesoft.com/sites?hsLang=en#main-content) - [Manage Site](https://docs.sitesoft.com/sites?hsLang=en#manage-site) - [QR Codes](https://docs.sitesoft.com/sites?hsLang=en#qr-codes) - [Toolbox Talks](https://docs.sitesoft.com/sites?hsLang=en#toolbox-talks) - [Task Analysis Documents](https://docs.sitesoft.com/sites?hsLang=en#task-analysis-documents) - [Geofencing](https://docs.sitesoft.com/sites?hsLang=en#geofencing) - [Safety Plan/Phase Plan](https://docs.sitesoft.com/safety-plan-phase-plan?hsLang=en) - [Manage Sign-in and Inductions](https://docs.sitesoft.com/manage-sign-in-and-inductions?hsLang=en#main-content) - [Get started with sign-in and inductions](https://docs.sitesoft.com/manage-sign-in-and-inductions?hsLang=en#get-started-with-sign-in-and-inductions) - [Manage geofencing sign-in and out](https://docs.sitesoft.com/manage-sign-in-and-inductions?hsLang=en#manage-geofencing-sign-in-and-out) - [Troubleshoot sign-in and inductions](https://docs.sitesoft.com/manage-sign-in-and-inductions?hsLang=en#troubleshoot-sign-in-and-inductions) - [Visitor Kiosk App](https://docs.sitesoft.com/visitor-kiosk-app?hsLang=en) - [SiteConnect Super Admins Only](https://docs.sitesoft.com/siteconnect-super-admins-only?hsLang=en) - [Use SiteConnect on Mobile](https://docs.sitesoft.com/use-siteconnect-on-mobile?hsLang=en#main-content) - [Manage your profile and app settings](https://docs.sitesoft.com/use-siteconnect-on-mobile?hsLang=en#manage-your-profile-and-app-settings) [![SiteConnect Logos (LinkedIn Post)](https://docs.sitesoft.com/hs-fs/hubfs/SiteConnect%20Logos%20(LinkedIn%20Post).png?width=155&height=25&name=SiteConnect%20Logos%20(LinkedIn%20Post).png "SiteConnect Logos (LinkedIn Post)")](https://siteconnect.io/) ###### **Still need help?** We're here if you can't find the answer you're looking for. AU & NZ• support@siteconnect.io • NZ 0800 748 763 • AU 1300 637 183 UK • support.uk@siteconnect.io • +44 333 043 5727 Copyright © 2026, SiteConnect.io Limited