Help Center · Data Import

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

  1. Go to Analytics → Data Import and choose the Manual File Upload card.
  2. Under "What are you uploading?", switch from "Energy Data" to "Meter List".
  3. 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.
  4. Drop the file (CSV is the safest format; up to 10 MB). One row per meter.
  5. 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.

← Back to Help CenterOpen this page in inbilit →

How do I register many meters at once from a file? | inbilit Help