All Collections
Admin Panel
Units & Rounds
Import units/rounds from Excel
Import units/rounds from Excel
Marcus Edlund avatar
Written by Marcus Edlund
Updated over a week ago

With the help of an excel import, you can quickly and easily get your units/rounds imported and do not have to manually enter them separately. You can import up to 1000 pcs at a time.

Start by going to Units or Rounds in the left menu, click the Import button at the top right and then select "Download sample file".

We will start from the unit import as it contains all the columns that rounds have, but also some more. Open the file and it will look like the image at the bottom of this page. Remember that it is important not to touch anything on line 1 and some of the columns require you to write in English, see options below in parentheses.

  • ID - Enter the unit ID number.

  • Brand - Enter the unit brand.

  • Model - Enter the unit model.

  • Workplace - Specify the workplace to which the unit is connected.

  • Department - Specify which department the unit should be linked to, optional.

  • Type of units - Vehicle or other. (vehicle or other)

  • Fueling - Record refueling, yes or no. (yes or no)

  • Reports average fuel - Fuel consumption, yes or no. (yes or no)

  • Meter reading - Specify the type of meter reading; none, km. hours or otherwise. (none, distance, time or other)

  • Suffix - Suffix on meter reading, specified only if you have selected other on meter reading. For example. tonne, kWh or m. (tonne, kWh or m)

  • AdBlue - Register AdBlue refills, yes or no. (yes or no)

  • Checklist - Enter the ID number of the checklist. If you go to Checklists in the left menu, it appears on the left of the checklist name. Leave blank if you do not want to link a checklist.

  • In use - Whether the unit is in operation or not. (yes or no)

  • Type - Enter the type of unit. Remember that the type must already be entered in the admin interface. (Edit a unit, select edit template at the bottom left and then at the top right you have types).

  • Responsible user / group for deviations / checks. - Here you add those responsible for deviations and checks. It is the ID number that should be entered and not the name of the user/group. In groups, you will find the ID number printed, while in a user you need to click on it and look in the URL. There are the numbers after users / that you must enter in excel. Example:

Did this answer your question?