All Collections
UpKeep Locations
How to Import/Update Locations
How to Import/Update Locations

Learn to import your locations and facilities into UpKeep using spreadsheets

Joseph Schmitt avatar
Written by Joseph Schmitt
Updated over a week ago

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.

NOTES:

  • You can use a CSV, XLS, XLSX, TSV or XML file type

    • You can also manually enter items to the table under Import

  • If you need to Update a Location you need to use the ID

  • You can import Parent and Sub at the same time, but the Parent needs to be higher/listed before sublocation on the sheet.

    Example:

Name

Parent Location

Parent Location

Sub Location

Parent Location

Please Note** File size is limited to 10MB and names MUST be unique.


Importing Guide

  1. To create new Locations download the Location template by navigating to the import page and clicking "Download Template."

    Image 2-17-2023 at 4.22 PM

  2. To Update Locations select Export Current Locations and makes changes to any columns EXCEPT the ID column. When done save the file for import.

  3. Image 2-17-2023 at 4.19 PM

  4. When ready select Start Location Import Process, then select the file you saved from step 3.

    Image 2-17-2023 at 4.21 PM
  5. Click Upload data from file or enter the data manually in to the table provided below.

    *Please note it is possible to have duplicate named records, so we recommend all your locations have unique names.

    Image 2-17-2023 at 4.20 PM

  6. After uploading the file, make sure the first row contains column names. Click Yes if so.

    Image 2-17-2023 at 4.41 PM

7. Next Confirm Column Mapping. It is recommended to confirm all mapping or if no updates are happening on a column, to use the Ignore this column option for all fields.

Image 2-17-2023 at 4.36 PM

8. View the data you are going to import prior to clicking Finish at the bottom.

  • Changes can be made from this screen.

  • You can view errors before you click finish to correct any issues from here.

Image 2-17-2023 at 4.37 PM

Fields

Column Header

Example Entry

Acceptable Values/Format/Notes

Location ID

wsIziIM1Br

Used for updating your location. Leave Blank if adding new locations.

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

Main Factory

The Name of the Parent Location

  • Parent needs to exist in UpKeep or be higher on the import sheet then the child

F – Assigned to email

Email assignee is using for UpKeep

G – Team Assigned Name

Night Shift

Name in UpKeep of the desired Team

H – Customer Assigned Name

New Customer

Name in UpKeep of the desired Customer

I – Vendor Assigned Name

HVAC Vendor

Name in UpKeep of the desired Vendor

For questions or concerns please reach out to Support at [email protected] or via chat in your Upkeep account under Contact US.

Did this answer your question?