All Articles

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!

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

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!
The maximum number of meter readings you can import at one time is 200!

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


Guide

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