---
title: How to import assets
description: How to import assets into emdecs one using a spreadsheet template upload.
---

[Skip to content](https://knowledge.brightorder.com/how-to-import-customers-2#main-content)

English

Show submenu for translations

[More support](https://knowledge.brightorder.com/kb-tickets/new?hsLang=en) [Customer portal](https://help.brightorder.com/tickets?hsLang=en)

[![BO Logo](https://knowledge.brightorder.com/hs-fs/hubfs/BO%20Logo.png?width=384&height=89&name=BO%20Logo.png)](https://knowledge.brightorder.com?hsLang=en)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [More support](https://knowledge.brightorder.com/kb-tickets/new)
- [Customer portal](https://help.brightorder.com/tickets)
- Go to www.brightorder.com

 Go to www.brightorder.com

 How can we help you?

- There are no suggestions because the search field is empty.

1. [BrightOrder Knowledge Base](https://knowledge.brightorder.com/?hsLang=en)
2. [emdecs one](https://knowledge.brightorder.com/emdecs-one?hsLang=en)
3. [Maintenance](https://knowledge.brightorder.com/emdecs-one?hsLang=en#maintenance)

# How to import assets

## Instead of entering assets (vehicles and trailers) by hand, you have the option of importing them from a file. This is especially useful if you're transitioning to emdecs one from another software.

This article is for **emdecs one** admins looking to add assets in bulk.

### Importing using the **emdecs one** asset template

If you are using the pre-existing template for assets ([learn how to download one if you'd like to use it](https://knowledge.brightorder.com/how-to-download-a-template-for-?hsLang=en)), then you'll need to open it in a spreadsheet program. Once you've done that you'll see something like this:

![04 - Assets template](https://knowledge.brightorder.com/hs-fs/hubfs/04%20-%20Assets%20template.png?width=670&height=52&name=04%20-%20Assets%20template.png)

The first row of this template is the column headings and should not be changed. The second row is an example asset, so overwrite it with the details of the first asset you'd like to import into the system then continue adding assets one per line until you've entered them all.

There are a few of these fields which are mandatory, and this is how to fill them in:

- **Asset Type**: This must be one of *Vehicle*, *Trailer*, or *Equipment*. Any other value will prevent that asset from being imported.
- **Unit Number**: Any combination of letters, numbers, and special characters
- **VIN**: Any combination of letters and numbers
- **Make**: Any combination of letters and numbers, including spaces
- **Model**: Any combination of letters and numbers, including spaces
- **Year**: Any four-digit number
- **License Plate**: Any combination of letters, numbers, and special characters, including spaces
- **Color**: Any one of Beige/Tan, Black, Blue, Brown, Cream/Ivory, Gold, Green, Gray, Maroon/Burgundy, Navy, Orange, Pink, Purple, Red, Silver, Teal, Turquoise/Cyan, White, Yellow, Multi-colour, Other, and Unknown. Note that this field is only used to help technicians when they are looking for a vehicle in the yard or shop, so if you think it is unnecessary use *Other* or *Unknown* for your assets. Note that any other value besides the ones listed here will prevent the asset from being loaded into **emdecs one**.
- **Category**: [List of acceptable categories (US/Canada),](https://knowledge.brightorder.com/list-of-asset-classifications-for-us/canada?hsLang=en)[List of acceptable categories (UK/EU)](https://knowledge.brightorder.com/list-of-asset-classifications-for-us/canada-0?hsLang=en)
- **Subtype**: [List of acceptable subtypes (US/Canada),](https://knowledge.brightorder.com/list-of-asset-classifications-for-us/canada?hsLang=en)[List of acceptable subtypes (UK/EU)](https://knowledge.brightorder.com/list-of-asset-classifications-for-us/canada-0?hsLang=en)
- **Customer**: Any combination of letters, numbers, and special characters, including spaces

There are also some fields which you can fill in if you like, but they are not mandatory. Leave them blank if you don't want to use them.

- **Active**: *true* or *false*. Used so you can include assets which you'd like to track but that will never have a repair order against them. Using *false* prevents the asset from being listed as a possibility when creating a work order or estimate.
- **Registration Date**: A date in the format *YYYY-MM-DD*
- **Registration Expiration Date**: A date in the format *YYYY-MM-DD*
- **Notes**: Any text, numbers, special characters, and spaces/paragraph spaces. Usually used to add information to an asset which is not covered by the other columns.

- [EMDECS](https://knowledge.brightorder.com/emdecs?hsLang=en#main-content)

    - [Getting Started](https://knowledge.brightorder.com/emdecs?hsLang=en#getting-started)
    - [How-To Guides](https://knowledge.brightorder.com/emdecs?hsLang=en#how-to-guides)
    - [Troubleshooting](https://knowledge.brightorder.com/emdecs?hsLang=en#troubleshooting)
    - [Account & User Management](https://knowledge.brightorder.com/emdecs?hsLang=en#account-user-management)
    - [Integrations](https://knowledge.brightorder.com/emdecs?hsLang=en#integrations)
    - [Release Notes](https://knowledge.brightorder.com/emdecs?hsLang=en#release-notes)
- [emdecs one](https://knowledge.brightorder.com/emdecs-one?hsLang=en#main-content)

    - [Maintenance](https://knowledge.brightorder.com/emdecs-one?hsLang=en#maintenance)
- [emdecs one ELD](https://knowledge.brightorder.com/emdecs-one-eld?hsLang=en#main-content)

    - [Troubleshooting](https://knowledge.brightorder.com/emdecs-one-eld?hsLang=en#troubleshooting)
    - [How-To Guides](https://knowledge.brightorder.com/emdecs-one-eld?hsLang=en#how-to-guides)
    - [Getting Started](https://knowledge.brightorder.com/emdecs-one-eld?hsLang=en#getting-started)
    - [Account & User Management](https://knowledge.brightorder.com/emdecs-one-eld?hsLang=en#account-user-management)
- [Tracking](https://knowledge.brightorder.com/tracking?hsLang=en#main-content)

    - [Getting Started](https://knowledge.brightorder.com/tracking?hsLang=en#getting-started)
    - [Troubleshooting](https://knowledge.brightorder.com/tracking?hsLang=en#troubleshooting)
    - [How-To Guides](https://knowledge.brightorder.com/tracking?hsLang=en#how-to-guides)
    - [Account & User Management](https://knowledge.brightorder.com/tracking?hsLang=en#account-user-management)
    - [Integrations](https://knowledge.brightorder.com/tracking?hsLang=en#integrations)
- [ELD](https://knowledge.brightorder.com/eld?hsLang=en#main-content)

    - [Release Notes](https://knowledge.brightorder.com/eld?hsLang=en#release-notes)
    - [Legacy Device Troubleshooting](https://knowledge.brightorder.com/eld?hsLang=en#legacy-device-troubleshooting)
    - [How-To Guides (Legacy Devices)](https://knowledge.brightorder.com/eld?hsLang=en#how-to-guides-legacy-devices)
- [Dashcam](https://knowledge.brightorder.com/dashcam?hsLang=en#main-content)

    - [How-To Guides](https://knowledge.brightorder.com/dashcam?hsLang=en#how-to-guides)
- [General](https://knowledge.brightorder.com/general?hsLang=en#main-content)

    - [Contact Us](https://knowledge.brightorder.com/general?hsLang=en#contact-us)
- [Getting started](https://knowledge.brightorder.com/getting-started?hsLang=en)

[![No Margin White BO Logo](https://knowledge.brightorder.com/hs-fs/hubfs/No%20Margin%20White%20BO%20Logo.png?width=384&height=112&name=No%20Margin%20White%20BO%20Logo.png "No Margin White BO Logo")](https://knowledge.brightorder.com/?hsLang=en)

www.brightorder.com   Help Center

<https://www.facebook.com/> <https://www.twitter.com/> <https://www.instagram.com/> <https://podcasts.apple.com/> [mailto:email@email.com](mailto:email@email.com)

Copyright © 2026, BrightOrder Inc.