Go to section

Importing Opportunities

The import tool can be used for adding multiple Opportunities to your Capsule account in one go. You can find it directly by going to the Sales Pipeline tab and choosing the Import Opportunities button from the top of the screen, which will take you to the Import hub.

From there, click on From a File and choose the Opportunities option to get started.

Showing the main import opportunities button

How to import Opportunities from a CSV or Excel file

If you’ve used a CRM in the past (or have your sales data stored in other systems or spreadsheets) and you have the option to export them to a CSV or Excel file, you should be able to import them to Capsule. The key to importing successfully into Capsule is getting the preparation step right in your spreadsheet and then making sure Capsule is set up to support any extra fields that you want to add.

Step 1: Organizing your spreadsheet for an import - Required fields

There are a few required fields for a basic Opportunity import. We have described each one below:

FieldDetails
Opportunity NameThe name of your Opportunity.
Contact Name / IDThe primary contact for your Opportunity.

If the primary contact is an Organisation, you can simply use the Organisation name or its Contact ID in this field.

If the primary contact is a Person, you will need to add their first and last name in this field e.g. Jennifer Kim (along with their email, see Contact Email field details below)
or their Contact ID.

As Capsule assumes a B2B relationship - if the person is linked to an Organisation, Capsule will automatically set the primary contact as their linked Organisation. The Person will automatically be added as an additional contact.
Contact EmailThe first listed email for your primary Contact.

If you added a Person's name in the Contact Name / ID field above, you must include this field too.

You do not need this field if:
- You've used a Contact ID in the Contact Name / ID field above
- The primary contact is an Organisation
PipelineAn Administrator can find the Pipelines available in Account Settings > Sales Pipelines. The Pipeline name must match Capsule exactly.
MilestoneYou can find a Pipeline’s existing available Milestones on the Sales Pipeline tab. An Administrator can edit these by following the steps in this article. The Milestone name in your spreadsheet must match Capsule exactly.

Below is an example of how to set up your spreadsheet with just the required fields. Click here to download the sample spreadsheet.

spreadsheet example with all required fields

Step 2: Organizing your spreadsheet for an import - Optional Fields

As well as the above information, there are also many optional fields that you can add to your Opportunities:

FieldDetails
DescriptionAdd any extra details about your Opportunity.
TagsYou can add these to your Opportunities in two ways, find out more in the importing Tags section.
Custom FieldsDepending on the type you choose, Custom Fields will be formatted differently and you can also create most types during the import itself. Read more about this in the importing Custom Fields section.
Expected Close Date The date the Opportunity is expected to close. Choose one of the supported date formats for all dates in the spreadsheet out of dd/mm/yyyy, dd-mm-yyyy, mm/dd/yyyy, mm-dd-yyyy, yyyy/mm/dd or yyyy-mm-dd.
ValueThe Expected Value of your Opportunity. This will need to be a single number field, without any commas or symbols.

If it has fixed payment terms, put the total value in this field.

If it is equal payments across a set period, add the instalment value instead, as Capsule will calculate the total value for you. See the field explanations for Payment Terms & Payment Duration below for more details.
CurrencyThe currency of the Value field above. You will need to use the currency code in this field e.g. GBP, EUR or CAD. If you do not include this field, Capsule will automatically import the Opportunity in your default currency.
Payment Terms The Payment Terms field must be either fixed, hour, day, week ,month or quarter.If you don’t include this field in your spreadsheet it will default to fixed.
Payment DurationIf you choose to include the Payment Terms field above, you will need to specify the Payment Duration in numbers. For an Opportunity with 5 equal payments per day, the Payment Duration field would be: 5
TrackYou can choose to add a single Track when importing Opportunities. Find out more in the importing Tracks section.
Owner/TeamYou can assign your Opportunities to an Owner and/or Team when importing Opportunities. Find out more in the assigning users to Opportunities section.
ProbabilityOnly for open Opportunities. The probability of winning an Opportunity is linked to the Milestone, you can find out more about this in this article.

Only include this field if you want to override the Probability for the Opportunity - it will need to be a single value between 1 - 100.

If you don’t include this field in your spreadsheet, it will be set automatically to match the settings in Capsule.

Below is an example of how to set up your spreadsheet that includes optional fields too. Click here to download the sample spreadsheet.

spreadsheet example with all required and some optional fields

Step 3: Organizing your spreadsheet for an import - Won vs Lost Opportunities

As well as Open opportunities, you can also import Opportunities that are Closed. This means that the Opportunity is either Won or Lost. Find out more about closed Opportunities here.

The key to setting an Opportunity as Won or Lost is the Milestone field.

  • For Won Opportunities: The Milestone will need to be Won.
  • For Lost Opportunities: The Milestone will need to be Lost.

The following optional fields only apply to closed Opportunities:

FieldDetails
Actual Close DateThe date the Opportunity was Won or Lost. Choose one of the supported date formats for all dates in the spreadsheet out of dd/mm/yyyy, dd-mm-yyyy, mm/dd/yyyy, mm-dd-yyyy, yyyy/mm/dd or yyyy-mm-dd.

If you don’t include this field, Capsule will set it to the date the import was processed.
Lost ReasonFor Lost Opportunities. An Administrator will need to add these to the Account Settings > Sales Pipelines > Lost Reasons tab first. The Lost Reason in your spreadsheet will need to match Capsule exactly.

Below is an example of how to set up your spreadsheet for Won and Lost Opportunities. Click here to download the sample spreadsheet.

spreadsheet example of importing won and lost opportunities with all required and some optional fields

Step 4: Importing the file into Capsule

Once you have your file ready to go, you can follow the steps below to import it into Capsule:

  1. Select Import Opportunities on the Sales Pipeline tab
  2. Click From a File > Opportunities* from the screen. Click to upload or drag and drop your file into the box, then select Next to get started.
screenshot showing the button to upload/drag and drop file
  1. Now you can match up the columns in your file to the Capsule fields. The Import tool will try to automatically detect the right columns but please double-check to make sure they are correct. The 'Uploaded Sample Data' section shows what values from your file will be put into each field. At this point, you can also create your Custom Fields.
Showing mapping step of Opportunity Import
  1. When you're done with your selection, click the Next button.

  2. You'll then be presented with an option to choose how to handle any possible duplicates that Capsule may find in your file. You can either import them all as new Opportunities anyway, ignore the duplicates or choose the option to Import and update duplicates using the data from your file.

duplicate choices for opportunity import

We have more details on this process in our dedicated section on updating Opportunities with an import.

  1. Next you'll see a preview of the Opportunities that are about to be imported. Confirm that it all looks right and check to make sure that the number of Opportunities about to be created matches up with your expectations.
Showing preview step of Opportunity Import
  1. Finally, click Import Now. Your import will start and you will be notified via email when it's complete.

Adding Tags to Opportunities via import

Adding Tags to Opportunities during import helps you to organise them into manageable groups from the outset. There are two ways to do this:

  • The first is to add a single column called ‘Tags’ and then add your Tags to each relevant contact as a comma-separated list:
Showing spreadsheet with Tags in a single column
  • The second option is to add a separate column for each Tag and just add the Tag in each row where you would like it to be applied:
Showing spreadsheet with Tags in multiple columns

When you come to the mapping stage in Capsule, select the option to Apply as tag.

Adding Custom Fields to Opportunities via import

Adding Custom Fields to your Opportunities is a quick and easy way to store unique information right from the start. Depending on the data type you want to add, there are some important details to note:

  • Text: Text fields have a 250-character limit.
  • Date: Choose one of the supported date formats for all dates in the spreadsheet out of dd/mm/yyyy, dd-mm-yyyy, mm/dd/yyyy, mm-dd-yyyy, yyyy/mm/dd or yyyy-mm-dd.
  • Check Box: For checked, use Y or TRUE. For not checked, use N or FALSE.
  • Number: Number fields have a 12-character limit with optional 3 decimal places.
  • List: List fields will need to be set up in Account Settings first. It is a single select field, so you will need to add a single value for that opportunity in their row.

Custom Fields for Opportunities are added in Account SettingsCustom FieldsOpportunities tab. If you are an Administrator User, to make the process quicker, you can set up most Custom Fields when importing instead:

  1. At the matching fields Stage, click on the No Match Field
  2. Choose Add New Custom Field
  3. Fill in all of the details for it including the Type and Description
  4. Click Save

The field will then be created and once the import has finished, the information in the column for that field will be stored against your Opportunities.

Gif showing the user creating a Custom Text Field while importing

Adding a Track to Opportunities via import

Adding a Track to your Opportunity means that you will have the first bulk of tasks applied and ready to be worked on as soon as the import is done. An Administrator will need to make sure the Track is set up in Account SettingsTracksOpportunities tab first.

In your spreadsheet, you need to include the Track Name or ID in a column called ‘Apply as Track’. Then when importing, you can map to the right fields. For example, to apply a Track called ‘VIP Track’ to the Opportunities, you would map it like this:

example of applying a track during the import

That will apply the Track to any Opportunities with that column populated.

How to assign users to Opportunities via import

To assign Opportunities to a specific User when importing, you will need to first know the display name or username of the Capsule user. Any Administrator on your account can find the Display name of each user by going to Account Settings > Users and Teams.

showing display names and user names for assigning opportunities

In your spreadsheet, you will need to add a column in your file with the header ‘Owner’. You can then add the Display name or Username for the Capsule User you would like to assign each Opportunity to in each respective row.

showing spreadsheet with owner column

If you are on the Growth, Advanced or Ultimate Plans, you can also assign an Opportunity to a Team. To do this, add a seperate column called 'Team', then add the Team name to the right Opportunity rows. Teams can also be found in Account Settings.

How to import Opportunity history

When importing your Opportunities using the CSV or Excel import process you can also import notes & emails. To import multiple notes for the same Opportunity and to set a date for your history entry you will need to use this format:

*** NOTE ***
2024-01-01
First interesting note

*** NOTE ***
2024-03-20
Second interesting note

Emails can be imported with similar formatting - you just replace NOTE with EMAIL like this:

*** EMAIL ***
2024-02-28
First interesting email

  • The note separator field must be formatted exactly as in the example without any extra or removed spaces.
  • The date element is optional.
  • Excel truncates fields to a relatively short limit of 32,000 characters. As a result, Excel is unsuitable if you're generating CSV or Excel files with long note histories.

Then during the import, you map the history column in your file to 'Add as History/Note' in Capsule.

showing mapping a column to history during import

How to view the last imports

After every import, you will get a confirmation email with a summary of the import and the link to view the imported Opportunities in Capsule. If you want to see a recent list of Opportunities that you've previously imported, this can also be done from within Capsule:

  1. Go to the Sales Pipeline tab
  2. Choose the Import Opportunities button
  3. Scroll down to the File Import History section and click on your chosen import for more details
showing the file import history section with 3 example opportunity imports listed

How to delete a list of Opportunities added by Import

Capsule has the option for Administrators to delete Opportunities in bulk. They will then go to the Trash area, where they will be held for 30 days and can be restored by your Super Administrator if needed. We cover both ways of deleting Opportunities in the sections below.

How to undo the last Opportunity Import

If you want to undo your last import for any reason, you have the option to view any new opportunities added in your last import which an Administrator can then delete in bulk. To do that, you should follow these steps:

  1. Go to the Sales Pipeline tab
  2. Select Last Import from the Saved Lists at the top of the page
Select saved list containing the last import
  1. To delete some Opportunities in your results, select them by clicking the checkbox next to their names before clicking the Trash icon in the top right of the page. Or click the Trash button straight away to select all of the Opportunities to delete.

How to undo previous Opportunity Imports

If you want to undo any previous imports, you have the option to view any new opportunities added in from them, which an Administrator can then delete in bulk. To do that, you should follow these steps:

  1. Go to the Sales Pipeline tab
  2. Choose the Import Opportunities button
  3. Scroll down to the File Import History section and click on your chosen import
  4. In the window, click to View the Opportunities added in that import
  5. To delete some Opportunities in your results, select them by clicking the checkbox next to their names before clicking the Trash icon in the top right of the page. Or click the Trash button straight away to select all of the Opportunities to delete.

Opportunity Import CSV or Excel Troubleshooting

Whether it’s your full import or a specific row, there are a few reasons that can cause them to have trouble importing into Capsule. After every Import, Capsule will generate a file of any rows that have failed or been ignored.

How to find out which rows have been ignored or failed

To view the file containing failed or ignored rows:

  1. Go to the Sales Pipeline tab
  2. Choose the Import Opportunities button in the top right
  3. Scroll down to the File Import History section and click on your chosen import
  4. In the yellow box, choose the button to download the file
Select saved list containing the last import

In that file, you will find a Reason column that gives more detail on why it did not import. We have explained all reasons in the section below.

What does each reason mean?

As mentioned in the section above, once you have downloaded your unhandled file, you will find a reason column for that row, explaining why it was failed or ignored.

ReasonRelates To (Capsule Field)Details
Opportunity missing nameOpportunity NameThe Opportunity Name is a required field and must be mapped for the import to work. Read more about this in the Required Fields section.
Contact not found with provided idContact Name / ID and Contact EmailThe ID in the spreadsheet does not match a contact in Capsule. Check the ID is an exact match.
Contact not found with name & email addressContact Name / ID and Contact EmailThe Contact Name / ID and Contact Email in the spreadsheet cannot be found in Capsule. Check the name and email of the contact are an exact match to Capsule.
Multiple contacts found with name & email addressContact Name / ID and Contact EmailCapsule cannot add the Opportunity as more than one contact has been found in Capsule with the same name and email address.
No id or name & email provided for primary contactContact Name / ID and Contact EmailThe Contact Name / ID and Contact Email are both required fields and must be mapped for the import to work. Read more about this in the Required Fields section.
Pipeline requiredPipelineThe Pipeline is a required field and must be mapped for the import to work. Read more about this in the Required Fields section.
Pipeline not foundPipelineThe Pipeline found in the spreadsheet cannot be found in Capsule. Check the Pipeline name is an exact match to Capsule.
Pipeline archivedPipelineThe Pipeline used in the spreadsheet has already been archived. You cannot import Opportunities to Archived Pipelines.
Opportunity milestone requiredMilestoneThe Milestone is a required field and must be mapped for the import to work. Read more about this in the Required Fields section.
Opportunity milestone not foundMilestoneThe Milestone in the spreadsheet cannot be found in Capsule. Check the Milestone name is an exact match to Capsule.
Opportunity milestone not on PipelineMilestoneThe Milestone found is not on the Pipeline used in the spreadsheet. Check the Milestones available in the Pipeline.
Opportunity milestone archivedMilestoneThe Milestone used in the spreadsheet has already been removed. You cannot import Opportunities to Archives Milestones.
Expected close on date invalidExpected Close DateThe Date field is not in a valid format. Make sure that you have chosen one of the supported date formats for all dates in the spreadsheet out of: dd/mm/yyyy, dd-mm-yyyy, mm/dd/yyyy, mm-dd-yyyy, yyyy/mm/dd or yyyy-mm-dd
Actual close on date invalidActual Close DateThe Date field is not in a valid format. Make sure that you have chosen one of the supported date formats for all dates in the spreadsheet out of: dd/mm/yyyy, dd-mm-yyyy, mm/dd/yyyy, mm-dd-yyyy, yyyy/mm/dd or yyyy-mm-dd
Attempting to set actual date on open opportunityActual Close DateAttempting to set actual date on open opportunity - Where an actual close date is found for an open opportunity. Read more about this in the Importing Won and Lost Opportunities section.
Opportunity Value invalidValueThe Value field will need to be a single number field, without any commas or symbols.
Currency invalidCurrencyThe currency field needs to be just the code, without any symbols e.g.GBP or EUR.
Invalid value for payment termsPayment TermsThe Payment Terms field must be either fixed, hour, day, week ,month or quarter.
Invalid number/value for payment durationPayment DurationThe Payment Duration field is a single number value e.g 5
Payment duration set with fixed payment termsPayment Terms & Payment DurationWhere the Payment Terms field has been set to fixed, but there is a Payment duration field in that same row e.g. Payment Terms = Fixed and Payment Duration = 5
Payment duration not set with non-fixed payment termsPayment Terms & Payment DurationWhere the Payment Terms field has been set to a time period but there is no Payment Duration field in that same row, so Capsule does not have the full information e.g Payment Terms = Day and there is nothing in the Payment Duration field.
Owner specified but not foundOwnerWhere an owner has been included in the spreadsheet but has not been found in Capsule. Read more on assigning Opportunities via import here.
Multiple users found with display nameTeamWhere an Owner has been included in the spreadsheet but Capsule has found more than one user with the same display name. Read more on assigning Opportunities via import here.
Team specified but not foundTeamWhere a Team has been included in the spreadsheet but this has not been found in Capsule. Read more on assigning Opportunities via import here.
Track not foundTrackThe Track in the spreadsheet cannot be found. Check the Track name (or ID if used instead) is an exact match to Capsule.
Multiple tracks found with same nameTrackThere are multiple Tracks with the same name in Capsule, so Capsule cannot tell which one to add. In this case, you can use the Track ID as a match instead. Find out more in the importing Tracks section.
Track wrong type (not Opportunity)TrackThe Track in the spreadsheet is not set up for Opportunities. Check Account Settings > Tracks > Opportunities tab.
Probability invalidProbabilityThe probability field will need to be a single value between 1 - 100.
Probability invalid (unparsable)ProbabilityA probability has been found but Capsule cannot get a number from the given value.
Unsupported currencyCurrencyThe Currency in the spreadsheet is not supported in Capsule.You will need to use the currency code in this field e.g. GBP, EUR or CAD.
Lost reason not foundLost ReasonThe Lost Reason in the spreadsheet has not been found. Check that the Lost Reason is an exact match in Capsule.
Lost reason set on non-lost milestoneLost Reason and MilestoneThere is a Lost Reason set for an open Opportunity. Read more about this in the Importing Won and Lost Opportunities section.
Opportunity with id not foundOpportunity IDWhere the Opportunity ID for the Opportunity cannot be found. Read more about this in Updating Opportunities through an import.
Can't specify opportunity id and import all as newOpportunity IDA field has been mapped to the Opportunity ID but the import as new option has been selected in Step 3 of the import tool. If you want to import the opportunity as new, remove the Opportunity ID field or map it to ignore when importing.

There are also situations where a Custom Field does not match your settings in Capsule, you can read more about the different types in the importing Custom Fields section. The following reasons apply:

ReasonDetails
Invalid value for listThe entry in your spreadsheet is not part of the List Custom Field or does not exactly match Capsule. For example, importing a value of C or D when the List Custom Field only includes A, B or C+.
Invalid number for custom fieldCustom Number fields have a 12-character limit with optional 3 decimal places.
Invalid date field/formatYou must choose one of the supported date formats for all dates in the spreadsheet out of dd/mm/yyyy, dd-mm-yyyy, mm/dd/yyyy, mm-dd-yyyy, yyyy/mm/dd or yyyy-mm-dd.
Deleted after importThe Custom Field was deleted after the import was completed.

If you need some extra support, you can email support@capsulecrm.com with a copy of the file for more information.