How to Import Meters
Need to set up multiple meters at once? Instead of creating them one by one, you can bulk import meters into UpKeep using a spreadsheet. This is the fastest way to get your meters configured and start tracking equipment usage right away.
What You'll Need
A spreadsheet file in CSV, XLS, XLSX, TSV, or XML format. We recommend downloading the meter template. Follow the steps below:
Navigate to the Import & Export page
Select Meters from the data set dropdown
Select Download Template
Your meter data organized with the column headers listed in the Field Reference section below
Step-by-Step: Import Your Meters
Navigate to the Meters section in UpKeep
Click the Option Dots (⋯) next to the + Meter button
Select Import Meter — you'll be taken to the import page
Or navigate to the Import & Export page directly
Select Meters from the data set
Select Start Meter Import Process
Upload your spreadsheet file, or manually enter items directly in the import table
Map your columns to the appropriate UpKeep fields
Review your data and click Finish to import
Field Reference
Use the following column headers in your import file:
Column Header | Example | Details |
A — Meter ID | G0JI96bHjs | The UpKeep ID of the meter. Only used when updating an existing meter — leave blank for new meters. |
B — Meter Title | Truck #1 - Mileage | The name of this meter. |
C — Unit of Measurement | Miles | The unit for this meter. No special characters allowed. |
D — Update Frequency | 30 | Number of days between expected readings. Enter a number only — do not type "days" or "months". |
E — Category | Mileage | Categorize your meters for easier filtering and organization. |
F — Assigned to Email | The UpKeep email address of the person assigned to this meter. | |
G — Location Name | WHQ | The location where the meter is being read. |
H — Asset Name | Truck #1 | The name of the asset associated with this meter. |
Best Practices
Double-check your column headers: they must match the field names above for the import to map correctly
Use existing asset and location names: the names in your file should match what's already in UpKeep so records link properly
Start with a small test file: import a few rows first to verify everything maps correctly before uploading your full list
Leave Meter ID blank for new meters: only include it if you're updating meters that already exist in UpKeep
FAQ
What file formats are supported?
CSV, XLS, XLSX, TSV, and XML.
Can I update existing meters with an import?
Yes — include the Meter ID column with the existing meter's UpKeep ID, and the import will update those records instead of creating new ones.
Can I add data manually instead of uploading a file?
Yes. On the import page, you can enter items directly into the table without uploading a file.
What happens if my asset or location name doesn't match?
If the name in your file doesn't match an existing record in UpKeep, that record will fail. Make sure names match exactly.