How to Import Meters
Learn to bulk import meters and create multiple meters at once!
Ben On avatar
Written by Ben On
Updated over a week ago

When your team is looking to keep track of the usage of your Assets, you can go to our Meters section. This way you can track historical usage over time. You also have the ability to use Meters to set-up Work Order Triggers.

If you already have your list of Meters that you want to set-up, you can import these into UpKeep quickly!

For a video walk through click the button below

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


How to Import Meters

  1. Download the โ€œMeters Data Importโ€ Sheet (or check out the GIF below)

  2. Open the CSV file in Excel/Google Sheets

  3. Do not add, remove or change any headers in Row 1

  4. Add in your data beginning with Row 2

  5. Below are instructions for filling out each column.

  6. Save the CSV file

  7. Upload new CSV under the Meters tab > Import > Upload CSV.

NOTE: You can only import 1000 meters in a CSV file at a time, but there is no limit to the total number of meters in your UpKeep account!


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 Value/Format/Notes

A- Meter Name

Truck #1 - Mileage

Name of this meter

B - Unit

Miles

The unit of measurement for this meter

  • NOTE: No special characters

C - Frequency

14

Number value only

  • NOTE: This is already in days so do not type in days/months

D - Location Assigned ID

BD9nFKP0pi

This is the 10-character unique ID of the location that this meter is assigned to

E - Asset ID

PM0VMSNWkL

This is the 10-character unique ID of the asset that this meter is assigned to

  • TIP: You can assign multiple meters to an asset but you can only create each meter for one asset at a time.

F - User Assigned ID

RGtkbMqJrl

This is the 10-character unique ID of the user that will be assigned to the meter

G - Category ID

Mileage

This is the 10-character unique ID of the meter category that you will add this reading to

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?