How to Import Meter Readings

Import your past historical readings, allowing you to continue tracking the historical usage of this meter!

Ben On avatar
Written by Ben On
Updated over a week ago

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!

For a video walk through click below!

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


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 SheetsDo not add, change, or remove any Column Headers in Row 1Start adding your data/information in Row 2

  6. Once your data is filled out, save your CSV

  7. Upload the CSV!

NOTE: 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

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 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

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?