This article explains how your team admin can upload assets into UpKeep. You can add assets one at a time, but this will allow you to save a lot of time and import them all at once! You can even bulk update your assets as well.
We have two levels on the Asset hierarchy. This includes our Parent Asset and our Child-Asset.
Child assets are components of the Parent asset where you may be completing work on or maintaining as well. Your assets may qualify as a child asset if your parent asset does not function without that asset.
TIP: Make sure you import your Parent Assets first so you can assign your Child-Asset to the Parent Asset by using the unique ID!
NOTE: Business Plus users are able to add Columns K-P on their CSV for their Depreciation and Warranty Information.
Parent Assets
First, let’s add in your Parent Assets. These are the main pieces of equipment or machinery. An example would be an HVAC unit or a truck.
NOTE: The maximum amount of Assets on an individual CSV is 1000, but there is no limit to the total amount of assets you can have.
Steps:
- Download the sample CSV “Asset Data Import Sheet.csv” (or check the GIF below on where you can download it in your account)
- Open the CSV in Excel or Google Sheets
- Do not remove or change any headers in Row 1
- Add in your data beginning with Row 2
- Do not add anything to the “Parent Asset ID” column - this will be used when importing child assets
- To assign this Asset to a Location, fill in the Location ID in the “Location ID” column
- See the next section to add custom fields*
- Save as a new CSV file
- Upload new CSV under the Assets tab > Import > Upload CSV
Here is a GIF of where you can find download the CSV and upload it:
*Need to add a custom field?
- You can add custom additional properties to your locations beginning in Column R.
- Title a new column CUSTOM|(new field name/additional property).
For example: CUSTOM|GPS # - Add in your custom values in the rows below.
Child Assets
Next, let’s add in your Child Assets. These are components of the Parent asset where you may be completing work on or maintaining as well. Your assets may qualify as a child asset if your parent asset does not function without that child. An example would be a compressor that goes with the HVAC unit or the engine in a truck.
- Download the sample CSV “Asset Data Import Sheet.csv” (or check the GIF below on where you can download it in your account)
- Open the CSV in Excel or Google Sheets
- Do not remove or change any headers in Row 1
- Add in your data beginning with Row 2
- This time, in the “Parent Asset ID” column, fill in the name of the corresponding Parent Asset ID (check the Guide section below for more information)
- See the section above to add custom fields.*
- Save as a new CSV file
- Upload new CSV under the Assets tab > Import > Upload CSV
Guide
NOTE: The ID refers to a unique, UpKeep assigned ID. You can find each 10-character ID in the URL when clicking into the location/asset/part/etc. All IDs can also be found when exporting each data set in Column A of the CSV!
Column Header | Example Entry | Acceptable Values/Notes |
A - Asset Name | Building 1 - HVAC 1 | Enter a name/title for your Asset |
B - Description | Make/Manufacturer information | Enter a description for the asset |
C - Model | 38EZA048310 | Model information for your asset |
D - Serial Number | 7233498875 | Synonymous with barcode
|
E - Area | Zone 3, NE Corner | If you assign a location, you can specify an area within that location.
|
F - Additional Information | Measurements/year of manufacturer | Enter any additional Asset details or information |
G - Location ID | CVtAO9gCDT | This is the 10-character unique ID of the location that this part is assigned to |
H - Parent Asset ID | P4p0cSNLrF | This is the 10-character unique ID of the asset that this part is assigned to
|
I - User Assigned ID | NOpyNXZ48d | This is the 10-character unique ID of the user that will be assigned to this part
|
J - Category | Fleet | Categories will allow you to easily find a group of assets in the future and generate accurate reports |
K - Purchase Date | 11/25/2021 | Enter in the Asset’s purchase date
|
L - Service Date | 11/25/2021 | Enter in the date the asset went into service/operation
|
M - Purchase Price | 50000 | Enter in the Asset’s purchase price |
N - Warranty Expiration Date | 11/25/2030 | Enter in when the asset's warranty expires
|
O - Residual Price | 2000 | Enter in the asset's residual price |
P - Useful Life | 3 years | Enter the asset's useful life (in years) |
M - Team IDs | zpz3YxdBve,Xx1235YDg5 | This is the 10-character unique ID of the team that will be assigned to this part
|