You can use Excel import to add devices, known as Spots, or update existing Spots in the browser. You can import data into one folder or update Spots that use the same device card across different folders.

Before you begin, check the destination folder, device card and your permissions. Keep a copy of the original data, try the change with a small number of rows first, and check the saved results before importing more data.

Choose the appropriate import method

  • By folder: add new Spots or update existing Spots in the selected folder. This import method requires permission to create Spots even when you are updating existing Spots. Select a folder that has no subfolders. The folder's device card determines the attributes, or data fields, in the import table. Spots being updated will also move to the selected folder if they are currently elsewhere.
  • By device card: update existing Spots that use the same device card. The Spots can be in different folders and will remain in their current folders. This import method does not create new Spots. You need permission to update Spots, access to the selected device card and permission to update every Spot included in the import.

If a folder import changes a Spot's device card, attributes that are not part of the new card are removed, and any missing fields from the new card are added. The destination folder's operating hours recording setting may also be applied to the Spot. Moving a Spot linked to a contract may fail if the destination folder has a different customer. Check these effects before importing. To move a Spot between folders without other changes, see Moving a Spot to a folder.

Prepare a file for updating Spots

Open Assets, devices, tools from the browser menu. On the Datatables tab, select List by device card. Select a device card using the Choose device card first selector above the list and wait for the data to load.

Select Export view for Excel import from the list toolbar. In the menu that opens, select Only spot attributes or Show also fields for current value. Both exports also include the ID and basic information. The adjacent standard Excel export button exports the columns in the view and is a different function: the export intended for importing arranges the columns for import and includes the identifiers needed for updates.

Keep the identifiers of the Spots you want to update in the file's ID column, and preserve the header row and column order. Include only the rows you want to change. The import identifies a Spot by its ID, not by its name or tag.

In a By folder import, an ID that is missing, invalid or refers to a Spot that does not exist may result in a new Spot being created instead of an existing one being updated. In a By device card import, every row being updated must contain the ID of an existing Spot. Updates to Spots using different device cards must be imported separately.

Prepare a file for new Spots

Open Import from Excel in the page's top toolbar and select By folder. Select the destination folder and the required current value options. Select OK to see the columns for this specific import.

Create an Excel table with the data columns in the order shown: Name, Tag, Description, Latitude and Longitude, followed by any current value fields and finally the device card's attributes. Row numbering and the trash column are not part of the Excel data. New Spots do not need an ID. If you use a previous export as a template, remove the old ID values from rows intended to create new Spots.

Give every new Spot a name. In a folder import, rows without a name are excluded both when loading the file and when saving, even if they contain other data or an ID. Use values appropriate to each attribute field, such as a number, a date in dd.mm.yyyy format or an option allowed by the device card.

What happens to empty and omitted data?

An empty cell does not automatically mean that the old value is preserved. Keep the current values in any included fields that you do not want to clear.

  • In a folder import, the name, description, latitude and longitude are replaced by the imported data. An empty description or coordinate clears that value. The purchase date, invest price and depreciation years are also replaced: even omitting them may clear the previous data.
  • In a device card import, an empty name preserves the current name. Included description and coordinate fields that are empty clear those values. If current value fields are not selected for inclusion, their data is preserved; included purchase date, invest price and depreciation years fields that are empty clear the corresponding data.
  • Attributes: the value in an included attribute column replaces the previous value, and an empty value clears the field. The option to show only current value fields excludes attribute columns, but the basic information columns are still included. Therefore, also check the name, description and coordinates.
  • Tag: enter the surface number of a tag in the register. An empty value preserves the current tag link. An unknown surface number neither creates a tag nor links one. A tag already linked to another asset cannot be linked to this Spot. This produces an error in the log, but the other data in the row may still be saved.

Removing a row using the trash button on the right side of the import table removes only that import row. It does not delete an existing Spot. Leaving a Spot out of the file does not delete it either.

Current value fields contain purchase and depreciation information

Show also fields for current value adds purchase and depreciation information alongside the attributes. Show only fields for current value displays that information without attributes and takes precedence over the other option. Basic information remains visible.

The current value fields are Purchase date, Invest price, Depreciation type and Depreciation years. They provide the starting information for the device's financial value, rather than operating hours meter readings, other measurements or product inventory values. Excel import does not import a calculated current value.

Enter the purchase date in dd.mm.yyyy format, for example 04.10.2026, the invest price as a number and the depreciation period in years. If you enter the purchase date, invest price or depreciation years, fill in all three: file validation requires the other values if any one of them is provided. Enter the invest price as a number without a currency symbol.

The depreciation type options are Amortization and Residual expenditure. When loading a file or pasting from Excel, an empty or unrecognized type appears as Amortization. However, importing the depreciation type has a limitation: the selection shown in the table does not guarantee that the type changes in the saved data. Check the type separately after the import; do not rely on Excel import to change it.

Import and check the rows before saving

  1. Select Import from Excel from the top toolbar on the Assets, devices, tools page.
  2. Select By folder or By device card. Select the destination in the Select the spots folder or Select the device card field.
  3. Select the required current value fields and continue by selecting OK.
  4. Check Selected folder: or Selected device card: above the table. Make sure the Excel columns match the import table in the same order. Column headers alone do not map data to the correct fields.
  5. Select Select Excel-file above the table. Alternatively, copy the data rows from Excel without the header row, select the Name cell in the first row of the import table and paste the rows. When pasting rows to update, also copy the first ID column, even though the identifier is not visible in the import table.
  6. Check the values, empty fields and error indicators in every column. You can correct a cell by double-clicking it or exclude a row using its trash button. Invalid values may be cleared during file processing, so a row appearing in the table does not mean its data is correct.
  7. Select Save above the table. Read the confirmation and accept it only once the mapping and data are correct.

A device card import is blocked before it starts if an ID is missing, a Spot cannot be found, update permission is missing, the device card is incorrect or an imported attribute does not belong to the card. Use the message to check the IDs, permissions and card. The table closing does not by itself indicate a successful import.

Verify the saved results

The import is processed in the background, and Spots are saved row by row. An import can succeed partially: a failed row does not undo rows that have already been saved.

Open History → Import logs from the browser menu and find the correct import by its time, user and data type. Check that it has completed, and review the details and error messages for new, updated and failed rows. For more detailed instructions, see Checking Excel import results and errors.

Also refresh the Spot list and open the imported Spots by clicking their names. Check the saved basic information, attributes, folder and tag link. Check the purchase and depreciation information in the Datatables → By current value list as well, especially the depreciation type. A successful row in the log does not by itself guarantee that every field contains the value you intended.

If some rows failed, investigate the errors and check the rows that have already succeeded before importing again. Correct and import only the necessary rows. If the original data did not contain IDs, importing it again by folder may create the same devices again. Export successfully created Spots with their identifiers before updating them.