The import tool can be used for adding multiple Contacts to your Capsule account at once. You can find it directly on the People & Organisations tab by choosing the Import Contacts button from the top of the screen, which will take you to the Import hub.
From there, click on From a File and then the People & Organisations option to get started.
![showing the main import contacts button](/static/c844bcbafce2a94a2f21bb2740f1018b/44d6a/importing-contacts-button.png)
How to import Contacts from a CSV or Excel file
This is one of the most common ways to get your data into Capsule. If you’ve used a CRM previously, or have your data stored in a different service it is likely you will be able to export that to a CSV or Excel file. The key to importing this successfully into Capsule is first preparing the data, then setting up Capsule to support all of your data fields.
Step 1: Decide where your data is coming from
If you already have a list of contacts (for example, from Google or LinkedIn), we have some dedicated guides for how to export contacts from these popular tools to a CSV file - which you in turn can use to import as per the steps below:
Step 2: Organizing your spreadsheet for import - Creating People vs Organization records
When you import from a CSV or Excel file, Capsule will look at each row and use specific fields to create either a Person or an Organization record. If you’re planning to store details against both People and Organizations, they’ll need to be on seperate rows in your spreadsheet.
- Creating a Person: If the row has a first and/or last name then Capsule will always use that row to create a person. It will also add all the remaining contact details on the same row to that person.
![example of csv spreadsheet containing people, first name and last name columns highlighed](/static/6bce4240d1440b89b66e55f217773d4c/65989/setup-config-people.png)
- Linking the Person to their Organization: Add an Organization column to the Person row to show where they work and link them up in Capsule.
![example of csv spreadsheet containing people, organization column highlighted](/static/a545d6c43ea9152f07f45628a69c7e6b/2c7b4/setup-config-people-with-org.png)
- Adding details to the Organization record: If you do not want to add details to the Organization record, you do not need to do this step. This is because an Organization record (e.g. Bookingly) will be automatically created when importing and all of the people linked to it.
If you want to add details to the Organization record itself, you only need to have the Organization column populated on that row, plus any other columns on that row that you’d like to store on the Organization. Make sure to leave the first name and last name columns blank:
![example of csv spreadsheet with organisation row highlighted](/static/44b9c675a5e456817d427b5ae7272418/49a87/setup-config-organisation-row.png)
Below is an overall example of how the spreadsheet can be set up to create multiple People and their Organizations and store details on both record types.
![example of csv spreadsheet with contact data](/static/b388164334352cda265f29534b7dd2fd/b4759/setup-config-people-and-orgs.png)
Step 3: Getting the fields right for import
Most fields are straight forward but it's good to understand how some fields might need specific formatting.
- First & Last Name/Organization: Find out more in Step 2 - Creating People vs Organizations.
- Address: Capsule uses a single field for the street in the address meaning that your file needs to have a single column for the Street. You can still use multiple lines within the address for things like apartment numbers etc. They just need to be in the same cell, separated with a line break. Remaining fields like city, zip etc should all have their own columns in the file.
- Tags: You can add these to your contacts in two ways, find out more in the importing Tags section.
- Custom Fields: Depending on the type you choose, Custom Fields will be formatted differently. Read more on how to do this in the importing Custom Fields section.
- DataTags: DataTags will need to be added to the Tags column, with extra fields for each Custom Field within. Find out more in our dedicated section on importing DataTags.
- Notes: Notes can be imported but are best formatted in a certain way to ensure that they are separated out and have the correct dates against them. Learn more in our dedicated section on importing history.
See the example below for how all these things can be set up in your spreadsheet. Click here to download the sample file.
![example of csv spreadsheet with contact data](/static/6476cdadeb1870eade3ffeee76443bbf/8d10d/csv-example.png)
Step 4: Importing the file into Capsule
Once you have your files ready to go:
- Go to the People & Organizations tab.
- Click the Import Contacts button at the top-right of the screen.
- Select From a File > People & Organisations.
![screenshot showing the button to start the import tool](/static/0fd36f96b04a89ffeea4e5cd969e1fc9/bdcdb/setup-config-import-from-csv-excel.png)
- Use the Click to upload button (or drag and drop your file), then click Next to get started.
- Now you'll be asked to match up the columns in your file to the corresponding fields in Capsule. Capsule will try to automatically detect the right columns but please double check all columns to make sure it is 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.
![preview of mapped fields](/static/a3fd82e215ba8bd4157aa4ca6f55b288/89ca3/setup-config-import-match-fields.png)
-
When you're done with your selection, click the Next button.
-
If Capsule has found duplicates in your file then you'll be presented with an option to choose how to handle those. You can either import them all as new contacts anyway, ignore the duplicates or choose the option to Import and update duplicates using the data from your file.
![duplicate choices](/static/1adff6547dfd02cc008de2fd2738fd8d/3cf0c/setup-config-import-duplicate-choices.png)
We have more details on this process in our dedicated section on updating contacts with an import.
- Next you'll see a preview of the contacts that are about to be imported. Confirm that it all looks right and check to make sure that the number of contacts about to be created matches up with your expectations.
![Import preview](/static/f2409749c6fcde1bb8952c7024493619/19b31/setup-config-import-preview.png)
- Finally click Import Now. Your import will start and you will be notified via email when it's complete.
Adding Custom Fields via import
Adding Custom Fields to your contacts 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 the single value for that contact in their row.
Custom Fields are usually added in Account SettingsCustom Fields. If you are an Admin User, to make the process quicker, you can set up most Custom Fields when importing instead:
- At the matching fields Stage, click on the No Match Field
- Choose Add New Custom Field
- Fill in all of the details for it including the Type and Description
- 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 contacts.
Gif showing the user creating a Custom Date Field while importing
Adding Tags via import
Adding Tags to your contacts during import helps you to organize your contacts into manageable groups from the get go.
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.
![example of single column of tags](/static/5e1271048d165b638da7b1150df130f6/f5a93/setup-and-configuration-import-tags-single-column.png)
- 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. When you come to the mapping stage in Capsule, you will select the option to Apply as tag.
![Multiple tag columns](/static/499620e8fb99e4e582417ded0159e7bc/7bee3/setup-and-configuration-import-tags-columns.png)
Adding DataTags via import
You will need to make sure the DataTag is set up in Account SettingsTags and DataTags first.
In your spreadsheet, you need to include the DataTag name in the 'Tag' column and then have a separate column for each Custom Field within the DataTag.
Then when importing, you can map to the right fields. For a DataTag called 'Lead' with a Custom Field in it called 'Source' you would map the Custom Fields like this:
A very descriptive description for the image
That will tag the contact with 'Lead' and add the values of Word of Mouth, Ad and Conference to the respective contact in the 'Source' Custom Field.
How to import history
When importing your contacts using the CSV or Excel import process you can also import notes & emails. To import multiple notes for the same contact and to set a date for your history entry there's some specific formatting you need to use:
*** NOTE ***
2020-01-01
First interesting note
*** NOTE ***
2020-03-20
Second interesting note
Emails can be imported with similar formatting - you just replace NOTE with EMAIL like this:
*** EMAIL ***
2020-02-28
First interesting note
- 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.
- For better control over note importing, consider engaging a developer to import the notes via the Capsule API.
Then during the import you map the history column in your file to 'add as note/history to contact' in Capsule.
![Option to map history column to contact](/static/5bc077d796b48b3e2716918608c4bbf7/80f23/setup-config-import-history-2.png)
How to assign users when importing
To assign Contacts to a specific User when importing, you will first need to add a column in your file with the header ‘Owner’. You can then add the username for the Capsule User you would like to assign each Contact to in each respective row.
Administrators on your account can find the username for each User by going to Account Settings > Users and Teams.
How to view last imports
After every import, you will get a confirmation email with a summary of the import and the link to view the imported contacts in Capsule. If you want to see a recent list of contacts that you've previously imported, this can also be done from within Capsule:
- Go to the People & Organizations tab
- Choose the Import Contacts button
- 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 imports listed](/static/56ec51aa249e2184f1305cd69803ba09/74fc9/setup-config-import-view-previous.png)
How to undo the last import
If you want to undo your last import for any reason, Capsule gives you the option to view the new contacts added in your last import which you can then delete in bulk. To do that, you should follow these steps:
- Go to the People & Organizations tab
- Select the import you want to undo from the saved lists at the top of the page
- Click the trash-can button at the top-right of the page to delete all the contacts in the list at once
![Select saved list containing the last import](/static/2667113133215c4bad91d3d97681c908/2c2f3/importing-undo-last-import.png)
CSV or Excel import troubleshooting
Failed Imports or Rows
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. To view the file:
- Go to the People & Organizations tab
- Choose the Import Contacts button
- Scroll down to the File Import History section and click on your chosen import
- In the yellow box, choose the button to download the file
![Select saved list containing the last import](/static/2746be84a6fd271addf57cdcaee1baa4/b07fb/setup-config-import-failed-reasons-file.png)
In that file, you will find a Reason column that gives more detail on why it did not import. We’ve explained the common reasons 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 the contact failed to import:
Failed Reason | Explanation |
---|---|
Invalid Email Address | For example, if any email addresses in the Email column do not include an @ sign. |
Duplicate Person | If you have more than one Person with the same First Name, Last Name and Email address in the same spreadsheet. |
Duplicate Organization | Organization names in Capsule are unique. If you are updating Contacts, see Updating contacts using the Import tool. |
Missing Name Fields | A missing First Name and/or Last Name on a Person row and/or a missing Organization name in the Organization column. See more details in Step 2 - Creating People vs Organizations. |
Duplicate Row | Where you have selected to ignore existing contacts and an existing contact has been found. |
Owner Not In Team | The chosen assigned owner/user isn't in the team. This only applies if you specify the Team in the row for that contact. |
Email Belongs To a User | Email addresses linked to a User cannot be updated by import. Read more about How to view and change the email address linked to your user. |
There are also situations where a Custom Field does not match your settings in Capsule. This includes the following reasons:
Failed Reason | Explanation |
---|---|
Invalid value for list | The entry in your spreadsheet is not part of the List Custom Field. For example, importing a value of C, when the List Custom Field only includes A or B. |
Invalid number for custom field | Custom Number fields have a 12-character limit with optional 3 decimal places. |
Invalid date field/format | You 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. |
CustomFieldOrgOnly | The Custom Field in the spreadsheet is added to a Person, but the field itself is set up for Organisations only. |
CustomFieldPersonOnly | The Custom Field in the spreadsheet is added to an Organisation, but the field itself is set up for People only. |
Deleted after import | The Custom Field has been deleted after the import was completed. |
The following only applies if you are using the Contact ID column to update contacts by import:
Failed Reason | Explanation |
---|---|
PartyDeleted | Capsule is unable to find the contact as it has been deleted. |
PartyNotFound | Capsule isn’t able to find the contact to update it. |
If you need some extra support to find out, you can email support@capsulecrm.com with a copy of the file for more information.
Question marks or strange characters in the import
Capsule assumes that CSV files are in UTF-8 format which allows you to store details about your contacts using characters from most of the world’s languages. However some applications save files in a format specific to your location.
You can usually convert these files to UTF-8 format using a simple text editor. On Windows you can use Notepad, and on Mac OSX you can use TextEdit. Then follow these steps:
- Open the CSV file in your text editor
- Select 'Save As' from the file menu
- Select Unicode (UTF-8) from the text encoding menu in the Save as dialog box