You and your team may operate in several locations or you might have assets stationed in different areas. Use your locations to organize and optimize your team’s workflow. If you have multiple locations, you can quickly add this data into UpKeep using the import feature.
There are two levels of location hierarchy: the Parent Location and Sub-Location. Your Sub-Locations would be more specific areas within the Parent Location. Here is a video tutorial on just importing your locations.
NOTE: Make sure to import your Parent Locations first. You’ll need to do this so you can assign your sub-locations to the Parent Locations by using the unique ID!
Start with your Parent Locations
Primary locations will include your main buildings, facilities, addresses, etc.
- Download the Location Data Import Sheet.csv
- Open the CSV in Excel or Google Sheets.
- Do not add, change, or remove any headers in Row 1
- Start adding information in Row 2. (Do not add anything to the “Parent Location ID” column – this will be used for sub-locations!)
- Save your CSV!
- Upload the CSV in the Locations tab > Import > Upload CSV.
TIP: The maximum amount of locations you can import at one time on a CSV is 1000. BUT there is no limit to the total amount of locations in the UpKeep system!
Here is a GIF on where to download the template and upload it:
Need to add a custom field?
- You can add custom additional properties to your locations beginning in Column G.
- Title a new column CUSTOM|(new field name/additional property).
- For example: CUSTOM|GPS #
- Add in your custom values in the rows below.
Sub-Locations
Sub-locations will include designated spaces or areas within the confines of your main building, facilities, etc. Some examples would be floors, zones, or rooms!
- You’ll need another copy of the sample CSV – Location Data Import Sheet.csv.
- Open the CSV in Excel or Google Sheets and make your edits.
- Do not add, change, or remove any headers in Row 1
- Start adding information in Row 2Add the 10-character Parent location ID to Column E.
- Save your CSV!
- Upload the CSV in the Locations tab > Import > Upload CSV.
TIP: The 10-character Parent location ID is found by clicking on the desired Parent Location. It is the last 10 characters after the forward-slash in the URL. You can also export your Parent Locations to a CSV (the IDs are found in Column A)!
Importing 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/Format/Notes |
A – Name | Carlsbad Building | The name of your building/location |
B – Address | 2505 Palomar Airport Rd, Carlsbad, CA 92011 | The full address for this location |
C – Latitude | 33.1277562 | Map coordinates |
D – Longitude | -117.2702606 | Map coordinates |
E – Parent Location ID | 3oWno8HxQw | This is the 10-character unique ID of the Parent location that you will assign this location to
|
F – Assigned to ID | zpz3YxdBve|H6oY7NpJuA | This is the 10-character unique ID of the user(s) that will be assigned to this location
|
G – Team Assigned ID | TTP0gJh48D | This is the 10-character unique ID of the team(s) that you will assign this location to
|
H – Customer Assigned ID | CVtAO9gCDT | This is the 10-character unique ID of the customer(s) that will be assigned to this location
|
I – Vendor Assigned ID | NOpyNXZ48d | This is the 10-character unique ID of the vendor(s) that will be assigned to this location
|