You are here:
Define Import Formats
Create an import format record that provides the configuration for the importing process. (Salesforce CPQ Managed Package)
Required Editions
| Available in: Salesforce CPQ Winter ’15 and later |
| User Permissions Needed | |
|---|---|
| To create import formats | The import format object must be set to Default On for administrators |
- Add the Import Lines button to the quote page layout.
- Add the Import Column related list to the import format page layout.
-
Create your import format.
- From the Import Formats object, click New.
- Enter a name for your import format.
- Select the Active field.
- Click Save.
-
Add import columns to your import format.
- From your import format, click New Import Column.
-
Enter a name for your import column.
The column header row on the CSV file you’re importing must match the column name on the equivalent import column. Create user-friendly names so your sales reps can save time during the import process.
- Enter a column index number. This number determines the order of this import column relative to the import format’s other columns.
-
Choose a value for the field name picklist.
The Field Name field can contain the API name of any field on the line editor. For ease of reference, we recommend that your column name and field name have the same value.
-
If this column contains your import format’s unique key value, select the Key
field.
- Your key import column can’t be related to formula fields, rules-driven fields, discount fields, quantity, or price.
- If your import format contains several columns with a selected Key field, Salesforce CPQ uses the last key column that you made.
Did this article solve your issue?
Let us know so we can improve!

