---
sourceDocument: Australia Strategic Portfolio Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/it-business-management

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Strategic Portfolio Management

ft:clusterId :

    - itbm

bundleId :

    - itbm

workflow :

    - Technology


---

# Import rate lines into a rate model

# Import rate lines into a rate model {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Use the import rate lines function to quickly add multiple rate lines from an export
file into a rate model.

## Before you begin

Set the glide.import_set_row.dynamically_add_fields system property to true. For more information about the property, see [Import sets properties](https://www.servicenow.com/docs/access?context=r_ImportSetsProperties&version=australia&pubname=australia-integrate-applications&ft:locale=en-US#section_d4y_pcf_1jb)
Role required: pps_admin or it_rate_model_admin

## About this task

After adding or updating rate lines in a file created using the [export function](https://servicenow-prod.fluidtopics.net/iHE~LSi79vfSFOyTRox8pQ "Export rate lines to a Microsoft Excel or CSV file to quickly update or add new rate lines and import them back into the rate model."), you can import the rate lines from the file into the rate model.  
Note:  
Rate lines fail to import in the following circumstances:

* Overlapping effective dates for the same set of criteria values.
* Criteria values with no matching data in the system. For example, a rate line might have Business Analyst as the Role criteria but that role does not exist in the system.
* Rates in non-functional (non-default) currency but no corresponding [budget reference rates](https://servicenow-prod.fluidtopics.net/ChM86RmiCjrvzZ2aTK6m6w "The support for use of multiple currencies provides conversions for budget items in different currencies.") for the required period exist in the system.
{#import-rate-lines__ul_wnj_1yh_hfb}

## Procedure

1. Import rate lines from an import file into the rate model in one of the following ways:
   * Navigate to AllProject AdministrationRate ModelImport Rate Line.
   * Navigate to AllTime SheetsRate ModelImport Rate Line.
   * Navigate to AllTime SheetsRate ModelAll, open a rate model record, and select the Import Rate Line related link.
   {#import-rate-lines__choices_dp3_bd3_kfb}
2. Select Choose File to select the import file.
3. **Optional:** If you're importing from an Excel file containing multiple sheets, enter the sheet number that contains the data to import in the Sheet number field.  
   Note:  
   If you're importing from a CSV file, then the data from the last saved CSV file is considered for import irrespective of the specified sheet number.
4. **Optional:** If the import file has a header row, enter the row number that has the header information in the Header row field.
5. Select Submit.
6. Select Run Transform to import the data.  
   For more information, see [Run an import](https://www.servicenow.com/docs/access?context=t_RunImport&version=australia&pubname=australia-integrate-applications&ft:locale=en-US).

## Result

* New rate lines are appended to the rate lines list in the rate model.
* Existing rate lines in the rate model are updated with the latest values.
{#import-rate-lines__ul_bcc_xxh_1gb}

*[\>]: and then