You can export person data to an Excel sheet if you have rights to access other people's data using the persons search. For example, supervisors can export their own data and the data of their subordinates to for reporting purposes, storing the addresses and working contract details etc. You can also use the export functionality to edit certain details for many users at once in Excel and then import the updated data into Nepton or an external system.
Export to Excel
- Navigate to employees, persons, persons -page,
- Filter the persons list by search terms and search for the persons whose data you want to export.
- Select Export to Excel to save the results to your computer.
- You can open the saved Excel file on Excel, LibreOffice or another spreadsheet program.
Export to importable Excel
- Navigate to employees, persons, persons -page.
- Filter the persons list by search terms and search for the persons whose data you want to export.
- Select Export to importable Excel to save the results to your computer.
- You can open the saved Excel file on Excel, LibreOffice or another spreadsheet program.
- Edit existing data and/or add new data.
- Navigate to employees, persons, import persons -page.
- Import the modified file into Nepton.
Columns in Excel file
The name of the export file is including the date and time first, followed by "PERSONS" and the name of the working community - in the format: YYYYMMDD_HHMM_PERSONS_COMMUNITY.xlsx. All persons are on the first sheet/tab. The name of the sheet is "Henkilölista".
The columns are displayed in the following order. The column title is displayed on the first row, other rows contain information for one person each.
| Column in default Excel file | Column in importable Excel file | Column title | Description |
| A | A | First name | First name of the person |
| B | B | Last name | Last name of the person |
| C | C | E-mail address of the person | |
| D | D | Phone number | Phone number of the person (as text) |
| E | E | Street address | Street address of the person's address |
| F | F | Postcode | Postal code of the person's address (as text) |
| G | G | Town/city | Town/city of the person's address |
| H | H | IBAN | IBAN code of person's bank account without spaces |
| I | I | BIC | BIC code of person's bank details |
| J | J | Personal identity code | Personal identity code of the person |
| K | K | Tax number | The tax number of the person (as text) |
| L | L | Next of kin | Person's next of kin |
| M | M | Next of kin phone number | The phone number of person's next of kin (as text) |
| N | N | Web page | Person's web page address |
| O | O | Job title | The job title of the person |
| P | P | Classification of occupations | Classification of occupations code (always 5 digits). Defines the code of Income register's classification of occupations (TK10) for the person's occupation. |
| Q | Q | Employment start date | Start date of person's current or latest employment (in format DD.MM.YYYY) |
| R | R | Employment end date | End date of person's latest employment (in format DD.MM.YYYY) |
| S | S | Reason for ending employment | The reason for ending of the latest employment |
| T | T | Trial period end date | The end date of person's trial period (in format DD.MM.YYYY) |
| U | U | Worktime setting group | The code of the setting group person belongs to |
| V | V | Work time percentage | Person's work time percentage (as a decimal number in text field with comma (,) as the decimal separator) |
| W | W | Monthly salary | Working contract monthly salary (numeric string which allows decimal values, but cannot start with zero) |
| X | X | Hourly wage | Hourly wage of the person (as text) |
| Y | Y | Work area | Person's work area |
| Z | Z | Role | Person's assigned Nepton role ("Employee", "Supervisor", "Unit Manager", "Salary Management", "HR Management" or "Administrator") |
| AA | AA | Worktime roles | The names of worktime roles person has, separated by pipe character (|) |
| AB | AB | Short term loan permit | "Kyllä" if the person has the short term loan permit, "Ei" otherwise. |
| AC | AC | Person group | The code of the person group the person is a member of |
| AD | AD | Units | The names of the units the person belongs to (in no particular order), separated by pipe character (|) |
| AE | AE | Default project | The code of person's default project (as text) |
| AF | AF | Default cost group | The person's default cost group |
| AG | AG |
Payment group |
The name of payment group the person belongs to (in no particular order), separated by pipe character (|) |
| AH | AH | Weekly hours MIN | Person's minimum weekly work time as hours (as a decimal number in text field with comma (,) as the decimal separator) |
| AI | AI | Weekly hours MAX | Person's maximum weekly work time as hours (as a decimal number in text field with comma (,) as the decimal separator) |
| AJ | AJ | Primary task | The name of the person's primary task |
| AK | AK | Additional administrative information | Additional administrative information entered for the person |
| AL | AL | Additional information for reports | Additional information for reports entered for the person |
| AM | AM | Service usage language | English name of the language person uses Nepton in "English", "Finnish", "Swedish", "Danish", "Polish", "Estonian", "Norwegian" |
| AN | AN | Microsoft AX hourly cost | The Microsoft AX hourly cost (as a decimal number in text field with comma (,) as the decimal separator) |
| AO | AO | Visma cost centre | Visma cost centre field contents (as text) |
| AP | AP | Nepton Id | An automatically generated identifier by Nepton to identify a person. It can be used to identify users. |
| AQ | AQ | Employee number | The employee number of the person (as text) |
| AR | AR | Username | The Nepton username of the person |
| AS | AS | RFID tag identifier | The RFID tag identifier of the person |
| AT | AT | Aastra | The person's identifier for Aastra (as text) |
| AU | AU | DL Software | The person's identifier for DL Software (as text) |
| AV | AV | Elisa Ring | The person's identifier for Elisa Ring (as text) |
| AW | AW | Emce | The person's identifier for Emce (as text) |
| AX | AX | Fivaldi | The person's identifier for Fivaldi (as text) |
| AY | AY | Heeros | The person's identifier for Heeros (as text) |
| AZ | AZ | Hogia | The person's identifier for Hogia (as text) |
| BA | BA | IFS | The person's identifier for IFS (as text) |
| BB | BB | Kieku | The person's identifier for Kieku (as text) |
| BC | BC | Lessor-5 | The person's identifier for Lessor-5 (as text) |
| BD | BD | Liksa | The person's identifier for Liksa (as text) |
| BE | BE | Mepco | The person's identifier for Mepco (as text) |
| BF | BF | Oscar | The person's identifier for Oscar (as text) |
| BG | BG | Personec F | The person's identifier for Personec F (as text) |
| BH | BH | Personec W | The person's identifier for Personec W (as text) |
| BI | BI | ProCountor | The person's identifier for ProCountor (as text) |
| BJ | BJ | Scala | The person's identifier for Scala (as text) |
| BK | BK | Sedab | The person's identifier for Sedab (as text) |
| BL | BL | Sonet | The person's identifier for Sonet (as text) |
| BM | BM | Tikon | The person's identifier for Tikon (as text) |
| BN | BN | Visma | The person's identifier for Visma (as text) |
| From BO - one column for each | From BO - one column for each | (Name fields of Persons additional fields) | One column for each additional field in the order listed in Employees > Administration > Persons additional fields. Contents is what has been chosen from drop-down menu and is displayed as text. Format depends on field type: |
| For integer fields the number is displayed without any separator characters if the value is between 0 and 2147483647. Negative numbers between -2147483648 and -1 are displayed with a hyphen minus sign (-) prefix. Numbers outside these ranges are not displayed. | |||
| For decimal fields the decimal separator is comma (,) | |||
| For yes/no fields the value is "Kyllä" for yes, "No" for no | |||
| For date and time fields the format is DD.MM.YYYY HH:MM | |||
| For date fields the format is DD.MM.YYYY | |||
| For other fields the value is formatted as displayed on the person form. | |||
| After persons additional fields | Not included in importable Excel | Deputy | The last name and first name of the person's current deputies, separated by comma (,) and space. |
| Full name | The last name and first name of the person, separated by comma (,) and space | ||
| Primary supervisor | The employee numbers of primary supervisors of the person, separated by pipe character (|) | ||
| Secondary supervisors | The employee numbers of secondary supervisors of the person, separated by pipe character (|) | ||
| List of employee numbers of supervisors | (Empty column, see previous columns) | ||
| User account enabled | "Kyllä" if the user account of the person is enabled, "Ei" otherwise. | ||
| Not included in importable Excel | Mobile link | Link to person's old mobile page. | |
| Column is only available for non-importable Excel and only if the old mobile link feature is in use | |||
| Valid from date | (Empty column - for filling in manually information for person import, see Field validities in person imports) | ||
| Not included in importable Excel | PrimarySupervisorFullNames | The last name and first name of the person's primary supervisor, separated by comma (,) and space. If there are multiple persons marked as the primary supervisor, they are all displayed separated by pipe character (|). | |
| Not included in importable Excel | SecondarySupervisorFullNames | The last name and first name of the person's secondary supervisor, separated by comma (,) and space. If there are multiple persons not marked as the primary supervisor, they are all displayed separated by pipe character (|). |