Importing employees

Import / Export company level

Please note: Updates and imports cannot be undone! Use the Sandbox for testing.

Please note: An update/import can only take place within the current period.

Please note: The import file may contain formulas or macros; only 'clean' text can be imported. In addition, the format must remain the same (no modifications in rows 1 and 2).

Please note:If you carry out an update, then all the data in the Excel sheet will be updated. That means we also overwrite the existing (correct) data. Hiding fields in the Excel file does not change this. If you want to make an update, you will only have to enter (retain) the data in Excel that you actually want to change.

1. Go to company level

2. Click the 'Menu' button in the top right of the screen, then click 'Import/Export Company Level' under 'General'.

561.png
 

Employees

562.png
 
1. Set the 'Batch Operation' to 'Employees'.
 
2. Import: Import new information into Nmbrs via an Excel spreadsheet. The personnel numbers to be imported must be different than those already recorded for the employees in Nmbrs.
 
3. Update: Update/replace existing information using an Excel spreadsheet. The cannot be undone once the update has been carried out. If you update information, you must only include the changes in the import file. This way, you do not have to delete the information in the import file that has not changed.

If you want to replace contract and employment relationship information, we recommend doing this manually. It is not possible to import a new contract to an existing employee.

4. Export: Make an export of the employees from Nmbrs®.

5. Download template: Use this button to download a template of the Excel spreadsheet to fill in your information.

Excel Spreadsheet

563.png

Fill in the 'Employees' tab. This is the only tab that will be imported, so the other tabs do not have to be filled in.

Please note: 

  • the employee number must contain no more than 10 digits;
  • the information after an empty row or column will not be copied over during the import or update (see the example below):

564.png

Upload

Select the file you want to upload and click 'Upload':

566.png

 

Import

Click 'Import':

567.png

 

Info, Warnings & Errors

568.png

1. Info: Shows which information has been correctly imported.

2. Warnings: This information is not correct (invalid) and has therefore not been imported, but the other information about the employee has been imported.

3. Errors: This information is incorrect and has therefore not been imported.

4. Click 'Close'.

After the import

After the import, you can download the Excel spreadsheet that you have imported:

569.png

 

Follow

Comments