This article briefly describes all of the bulk upload functions in Measurabl. If you have a batch of data to upload, and you don't want to input it manually, you can fill out one of these templates and our team will upload the data for you.
As a general rule, all headers that are green in the bulk upload templates are required fields to fill out. If it is blue it is optional. If there is a dropdown menu in any of the cells, please use one of the options from the menu.
Here are some common uses of bulk uploads:
- Manual meters and readings
- Occupancy percentages
- Projects/audits
- Custom IDs
- Enrolling Utility Sync accounts
- Property spaces
- Site managers
NOTE: All templates are linked in the section title to download for your convenience.
Sites, Meters, Readings Bulk Upload Template
- FUNCTION: This template should be used if you need to upload multiple manual sites, meters, or readings.
- HOW TO SUBMIT YOUR BULK UPLOAD: Be sure to read the 'Instructions' tab carefully to ensure your upload is processed correctly the first time. Once complete, you may upload the template in Measurabl (only available to portfolio level users), or you can send it to our support team. To upload the template in Measurabl, refer to one of the links in the two bullet points below.
- This guide will bring you through the process of adding manual data into Measurabl, scroll to 'Steps to Bulk Upload Manual Meter Data' section to see the steps to bulk upload manual meters and readings.
- If you want to bulk upload manual sites, you can review this article.
Site Supplement Bulk Upload Template
- FUNCTION: The Site Supplement template has several tabs, which can facilitate the following:
- Update the Basic Attributes of your properties (Bought Date, Tenancy, Custom ID...)
- Add FMV (Fair Market Value) to your properties.
- Add Occupancy percentages for your properties.
- Add Construction/Renovation dates.
- Add site Projects and Audits.
- Add site Ordinances.
- HOW TO SUBMIT YOUR BULK UPLOAD: Be sure to fill out all necessary fields before submitting your bulk upload (All green column headers are required). When finished, you may email your completed template to our support team.
Add Property Spaces Bulk Upload Template
- FUNCTION: The Property Spaces template is useful when you have multiple spaces you would like to add to your property.
- HOW TO SUBMIT YOUR BULK UPLOAD: Please read through the 'Instructions' tab carefully so that your upload is processed correctly. Once you are done, send the completed sheet to our support team.
- To add spaces individually, or read more about spaces, click here.
Utility Sync Accounts Bulk Upload Template
- FUNCTION: If you want to switch your Utility Sync accounts from linked with provider<>manual bill uploads in bulk or if you would like to enroll multiple Utility Sync accounts - please use this template.
- HOW TO SUBMIT YOUR BULK UPLOAD: Fill out the required columns in the spreadsheet, and send your completed template to our support team.
- To understand if you need to switch your accounts from linked with provider<>manual bill uploads, refer to this article.
Add Site Manager Bulk Upload Template
- FUNCTION: This template is helpful if you need to bulk add new site managers or if you would like to change existing site manager's site access.
- HOW TO SUBMIT YOUR BULK UPLOAD: Fill out the required columns in the spreadsheet, and send your completed template to our support team.
- If you would only like to add one or manually add site managers, view this guide.
Feel free to submit a request or email us directly if you have any questions!