How do I register many meters at once from a file?
If you have a list of meters — from a BMS point list, an M-Bus scan, a spreadsheet from your metering contractor — you can register them all in one pass instead of adding them one by one.
This creates meters. It does not import readings. Registering a meter list gives you the meter records; consumption still has to arrive afterwards through one of the import methods, or through the "Energy Data" mode of the same upload card.
Step by step
- Go to Analytics → Data Import and choose the Manual File Upload card.
- Under "What are you uploading?", switch from "Energy Data" to "Meter List".
- Pick the building these meters belong to. It has to be a building that already exists — the "other / type a name" option cannot receive meters, so create the building first if it isn't there. Every meter in the file is created in that one building, so a file mixing several buildings has to be split first.
- Drop the file (CSV is the safest format; up to 10 MB). One row per meter.
- The file is analysed and a review table appears: "We found N meters in your file".
What the file should contain
- A name or identifier column — required. Every row must have something to name the meter by. If there is also a dedicated ID column (meter id, device id, serial number), that is used as the meter's identifier and the readable column becomes the name.
- A dedicated type column — optional but worth adding. Headers like "Type", "Meter Type", "Category", "Medium", "Typ" are recognised, and their values set the meter type. Without such a column the type is left blank on purpose — the type is never guessed from the meter's name, because "Electricity meter, floor 3" in a name column is not evidence of anything. You then set the types in the review table.
- A unit column — optional. Otherwise the default unit for the type you pick is filled in for you.
- Location or description columns are read if present.
The review table before anything is created
- Edit each meter's name and set its type. Choosing a type fills in that type's default unit.
- "Set all types to:" applies one type to every selected row — the fastest path when the whole file is, say, electricity sub-meters.
- Rows that match a meter already in the building (same number or same name) are flagged as duplicates, unticked, and skipped. They are reported as "skipped" in the result, not as errors.
- Every ticked row needs a type before the create button will run.
- Untick anything you don't want. Nothing is created until you confirm.
After creation
- The meters are created at building level. Reassign them to a local, tenant or common area afterwards from Analytics → Meters or the building's Meters tab.
- The meter number is set from the name unless the file had a separate identifier column. If you bill from utility invoices, check the meter numbers afterwards — invoice-to-meter matching works on the meter number, not the display name.
- Connect the meters to a data source next, or upload readings with the "Energy Data" mode.