How to Import Meter Readings

With our Meters feature, we can keep track of the usage of our Assets. This way you can track historical usage over time and even set-up Work Order Triggers!

Once your meters have been created in your UpKeep account, you can import your past historical readings, allowing you to continue tracking the historical usage of this meter. This article explains how to import your previous meter readings!

[tip] NOTE: Your meters have to first be created in UpKeep in order to import your meter readings! [/tip]

Check out our video tutorial on importing meter readings for more information!


How to Import Meter Readings

  1. Start by navigating to your Meters section
  2. Click or open any existing meter
  3. Then, click on History
  4. Download the sample template for Importing Meter Readings
  5. Open the CSV in Excel or Google Sheets
    • Do not add, change, or remove any Column Headers in Row 1
    • Start adding your data/information in Row 2
  6. Once your data is filled out, save your CSV
  7. Upload the CSV!

[tip] The maximum number of meter readings you can import at one time is 200! [/tip]

Here is a quick GIF on where to find the right place to download the sample template and upload the meter readings:


Guide

[tip] 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! [/tip]

Column Header

Example Entry

Acceptable Value/Format/Notes

A- Meter ID

PysI8zCdAd

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

B – Meter Reading

125.50

Number

C – Reading Date

07/15/2021 23:58:35

Add your date and time

NOTE – The format must be: MM/DD/YYYY hh:mm:ss