---
title: "Importing Rates into a Quantify Rate Profile"
slug: "importing-rates-into-a-quantify-rate-profile"
updated: 2025-03-06T14:30:40Z
published: 2025-08-01T11:00:27Z
canonical: "docs.avontus.com/importing-rates-into-a-quantify-rate-profile"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.avontus.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Importing Rates into a Quantify Rate Profile

Use a tab-delimited text file to import rates into a Rate Profile in Quantify. Start with an Excel file, with the following column headers:

- Part number
- Rent
- Sell
- Job Cost
- Replacement Cost

After you populate the columns with information, save the file as a tab-delimited text file to use for importing.

To import rates into a Rate Profile:

1. Click **Rate Profiles**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/fcee5267-3210-4b99-8f0a-374ff4ada3b4.png) The *Rate Profiles* dialog appears.
2. Click the **Add Profile** button. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/63fc5937-d09b-4342-b609-b3b953858ce0.png) The *Rate Profile* dialog appears.
3. Click in the **Name** text field and enter the name of the new Rate Profile.
4. As necessary, click in the **Rental Days** text field and enter the appropriate number of rental days (28 days is the default).. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/d414d45d-72d1-48ad-af6e-345a829d0bb4.png)
5. Click the **Change** dropdown and select **Import Rates from File**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/d653a45f-102e-4c22-8d01-b217a8a58295.png) The *Import Rates from File* dialog appears.
6. Click the **File to Import** button ( ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/1a4f4933-9b0d-4f0c-965c-9359a350819b.png)). ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/49aacf66-c5c2-4ed8-a248-e306cbb5f912.png) The *Import from TXT File* dialog appears. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/691a3949-4c5d-47cd-8fdb-2e6312a2dc6b.png)
7. Navigate to and select the text document to import and click **Open**. The *Import Products* dialog returns.
8. Click the appropriate radio button: **Ignore** or **Overwrite Existing Rate with Value from the File**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/7141ddfa-38d3-46da-95f0-ad2453790763.png)
9. Click **Import**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/27e57a83-feee-40ce-a934-15e4b5ecbc11.png)