The mapping wizard imports activity data from your own spreadsheet or CSV. You map it once, save the mapping and reuse it next month with no manual steps. It is a plan feature: check Settings → Plan & usage.
The five steps
- Upload: choose the Asset and the Spreadsheet or CSV, then click Read file. If you saved a mapping before, choose it under Saved mapping and click Import with this mapping.
- Sheet & header: pick the Sheet and confirm the Header row, then click Apply.
- Layout: Months in columns (one row per meter, one column per month) or Dates in rows (one row per month, one column per meter), and the column that holds the row names or dates. For Dates in rows, set the Date format when the file writes dates as numbers such as 03/04/2026. For a CSV file, set the Decimal mark and tick Numbers use a thousands separator if the file writes 1,234 for one thousand two hundred and thirty-four.
- Map streams: for each row or column choose the Data stream and Unit, or tick Ignore (for example for total rows). Unmapped rows are ignored.
- Save & import: give a Mapping name, click Save mapping, then Import this file.
The import then goes through the same validation and commit as an Excel import. See Excel import.
Mapping findings
| Code | Meaning |
|---|---|
| E050 | The mapping no longer fits the file, for example the header row moved. Open the wizard and save the mapping again for this file. |
| E010 | A CSV number cannot be read without guessing: for example 1,234 could be thousands or decimals. Set the Decimal mark and the thousands option of the mapping, or write the number without a thousands separator. |
| E051 | A row has values but its date cannot be read, or every date could be day-first or month-first. Use a real date or YYYY-MM, or set the Date format of the mapping. |
| W050 | A row or column is in the file but not in the mapping; its data is ignored. |
| W051 | A mapped row or column is missing from the file; nothing is imported for it. |
| I050 | Several rows of the same month were added together (daily or weekly data). |
Tips
- The asset needs monthly data streams before you can map. Add them in asset setup.
- New warnings still have to be acknowledged, even with a saved mapping.
- If your file is close to the generated template, use Use the Excel template instead.