Skip to main content
Skip table of contents

Cost Rates Import per role

You can import role rates from a CSV file to populate the table more quickly for many roles at once. To import role rates, first prepare your data file using the format described below, and then click the import icon (

) located at the top right of the role rates table to launch the import wizard.

Role rates import file format

The role rates for import should be stored in a CSV file containing 4 columns:

ColumnDescriptionFormat notes
RoleRole for which the specified rate should apply.A blank value indicates this is a default rate.
Hourly RateHourly Rate that is paid to the role in salary.Required. A positive (≥ 0) number.
CurrencyCurrency in which the hourly rate is specified.Required. A valid ISO 4217 Three letters currency code.
Effective DateDate at which the specified rate becomes effective.A blank value means "since forever". Only one rate per role can have a blank effective date.

The first row of the file must be the column headers. Note that you can use different column names than the ones listed above for headers, since the import wizard will allow you to map columns from the CSV file to the corresponding fields of role rates.

For more details about preparing the CSV file for import, please refer to Importing Data from CSV.

Example Rates per role CSV File

Here is the sample content of a CSV file to import one default rate and rates for two roles developer and designer.

Role,Hourly Rate,Currency,Effective Date
,19.2342,USD,
developer,23.9344,USD,2013/01/01
developer,25.0038,USD,2014/01/01
designer,24.1221,USD,2014/01/01


Importing the rates per role file

Click the import icon (

) located at the top right of the rates per role table to bring up the import wizard.


The first step of the import wizard allows you to select the CSV file to import and the date and number formats to use.

CSV Source FileFile picker letting you select the file to import.
Date FormatDate format to use. Use a format that is compliant with the Java SimpleDateFormat.
Grouping SeparatorThe character used in the CSV file to separate thousands groupings in numbers.
Decimal SeparatorThe character used in the CSV file to separate the decimals portion of numbers.


Click Next when you are done setting up the import. This brings up the Field Mapping dialog where you can choose which CSV file column to associate to each Role cost rate field. Matching names will automatically be used as defaults.


Click Import to proceed with the import. The import process finishes with a dialog showing the results including how many rows were successfully imported and how many were skipped, with related error messages.

Click Close to close the results dialog and return to the rates per role table.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.