Importing files into our system is straightforward if you follow the guidelines and steps outlined below. This document will help you ensure a smooth and successful import process.

Sample File for importing or updating opportunities: Sample file

In This Article

Prepare Your Data

Supported File Types

  1. Ensure your file is in .csv format.

File Preparation Requirements

  1. Sheet: Only one
  2. Size: Smaller than 30 MB
  3. Headers: Include a header row with at least one column corresponding to a field in the system
Please note that Opportunity import is not a reversible action

Mandatory Fields

1. For Creating Opportunities: Contact ID, Opportunity name and Pipeline ID. 

  • Default values:
    • If the Stage ID is absent, it defaults to the first stage under that pipeline. 
    • If the Opportunity Value is absent, it defaults to 0. 
    • If the Opportunity status is absent, it defaults to “Open”.
    • If the Opportunity lost reason is added and is valid, the Opportunity Status will be updated to "Lost"
Opportunity ID, Pipeline ID and Stage ID can be fetched by exporting opportunities
Contact ID can be fetched by exporting contacts

2. For Updating Opportunities: Opportunity ID (can be fetched by exporting opportunities)

Understanding Import Options

When importing objects, you have three options to choose from:

  1. Create Opportunities: Use this option to upload only new records into the system.
  2. Update Opportunities: Select this option to update information for existing records.
  3. Create and Update OpportunitiesChoose this option for a combination of adding new records and updating existing ones.

Structuring Your File

Field Formatting

  • Date Picker:
    • Acceptable formats: mm/dd/yyyy (e.g., 10/28/2020), yyyy/mm/dd (e.g., 2020/10/28), mm-dd-yyyy (e.g., 10-28-2020), yyyy-mm-dd (e.g., 2020-10-28).
  • Multiple Options, Checkbox, Textbox List:
    • Acceptable formats: Value 1, Value 2, Value 3 (e.g., Blue, Yellow, Green). You can also use ; or . as separators.
  • Radio, Single Option:
    • Acceptable formats: Value 1 (e.g., Blue).
  • Opportunity Owner:
    • Format: FirstName LastName (e.g., Logan Paul).
  • Tags:
    • Acceptable formats: Value 1, Value 2, Value 3 (e.g., Blue, Yellow, Green). You can also use ; or . as separators.
  • Phone Number:
    • Format in E.164 (e.g., +1 1234567890). For US numbers, formats like 123-456-7890 or (123) 456-7890 are also acceptable.
  • Numerical:
    • Acceptable formats: 1.23, 1234, .123.
  • Monetary:
    • Acceptable formats: 1234, 1,234,234.33.
  • Opportunity Followers:
    • Acceptable format: FirstName LastName, FirstName2 LastName2 (e.g. Adam Smith, David Lee)

Importing Your File

Steps to Import:

  1. Turn on Opportunities Import under "Labs" > Subaccounts
  2. Go to Opportunities
  3. On the top right under 3 dots, click on "Import Opportunities"

  4. Upload Your File: Click the 'Import' button and upload your file. Also select whether you would like to "Create", "Update" or "Create and Update"

  5. Map Your Fields: Ensure each column in your file is correctly mapped to the corresponding field in the system. Adjust the mappings if necessary.
    A few things to note:
    1. Checking the "Don't update Empty Values" checkbox will not update any field if the imported file has empty values and the field does have some value for the opportunity
    2. If you decide to not import certain field, you can choose to keep it unmapped and check the box on the bottom to proceed. -"Please ensure all mandatory fields are mapped. To proceed, either map all fields or choose Don't import data for unmapped columns"

6. Review and Confirm: Review the data preview to ensure everything looks correct. Confirm the import to proceed. Note that it is mandatory to check the box on the bottom and accept the disclaimer to start importing.
You can also add tags to the corresponding contacts for these opportunities on this screen.

7. Monitor the Import: Check the import progress under Opportunities > Bulk Actions. If any errors occur, refer to the error messages provided for guidance on fixing them.

8. Monitor stats, errors and warnings by clicking on the "Show Stats" button for any import.

Troubleshooting Common Errors

  • Error: Invalid option selected for multiselect or dropdown field
    Solution: Check your import file for incorrect values in multiselect or dropdown fields by comparing them with the options in the system. Update the value in your file to match an existing option or add it as a custom option in the system. Then re-import the file.
  • Error: Invalid Contact ID
    Solution: Verify that the Contact ID exists in the system or remove the ID if not updating an existing contact.
  • Error: Could Not Parse Date
    Solution: Ensure date fields are in one of the acceptable formats: mm/dd/yyyy, yyyy/mm/dd, mm-dd-yyyy, yyyy-mm-dd.
  • Error: Duplicate Unique Property Value
    Solution: Ensure there are no duplicate values in fields marked as unique, such as emails or IDs.
  • Error: File Not Found
    Solution: Verify that your file is the correct type and format. Re-upload the file.
  • Error: Required Fields Missing
    Solution: Ensure all mandatory fields (e.g., Opportunity Name for opportunities, Email/Phone/Name for contacts) are included and correctly formatted.

Additional Tips

  • Double-check your file before importing to avoid errors.
  • If you encounter any issues during the import process, refer back to this guide or reach out to our support team for assistance.