Dimensions can be imported into Merit Palk from a CSV file.
If the source data is prepared in Excel (XLS/XLSX) format, it can be easily saved as a CSV file.
This import functionality is available only for users of the PRO package of Merit Palk.
To import dimensions, open the menu: Settings → Data import from file → Dimensions import
CSV file requirements
General settings
Encoding: UTF-8
Field separator: semicolon (;)
Decimal separator in numbers: comma (,)
File structure
Column | Description | Example | Notes |
Column 1 (A) | Dimension type code | 0 - department 1 - cost center 2 - project | Additional type codes may be added over time |
Column 2 (B) | Dimension code | TRTFIN |
|
Column 3 (C) | Dimension name | Tartu Finance Department |
|
Column 4 (D) | Dimension end date | 31.12.2025 | * |
*- The end date is currently not displayed in Merit Palk and does not affect whether a dimension is active.
💡 The CSV file must always be generated from an Excel (XLS or XLSX) file. If changes are required in the import data file, they must be made in the original Excel file, not in the CSV file.
After making the changes, save the Excel file again in CSV format and use the new CSV file for import.
Additional instructions
There are no restrictions on the content of the remaining columns.
Column names in the first row of the file should only be included if not all data columns are imported at once. If all columns are filled, column headers are not needed.
The file may contain empty rows at the end, which the program will ignore.
All columns starting from column 5 will be ignored.
📁 Sample file
You can download a sample file here