Loading......

Import contacts and product data

Updated on 20 Oct 2021

Import customer data into SuperOffice CRM in one go.

An empty CRM database won't help you manage your contacts. By importing your customer data all in one go using our import feature, you can quickly start managing your customer relationships in SuperOffice CRM. In this guide you’ll learn how to import data from an Excel file.

Create an import file using the Excel template

To make it easier for you to import contacts, we have created an import template you can download and use to import. In this Excel spreadsheet, we've set up the basic data fields in columns, and all you have to do is copy your contact details into the right cells.

Download the import template for companies and contacts [Excel spreadsheet]

Download the import template for products [Excel spreadsheet]

  • Import from Excel

Here is a preview of an import template for companies and contacts (Excel):

Preview of an import template mae in Excel, for companies and contactsUsing an import file is the best way to import all your contacts into SuperOffice CRM

Three tips to create the import file:

  1. Some of the fields in SuperOffice CRM are mandatory. When you import companies and contacts, make sure to include the columns Category, Business, and Contact/company number in your import file. When you import product information, add Product Code, List price and Name.
  2. If you want to import several contacts from a company, you need to add one row for each contact person and add the same company name to all the rows.
  3. Keep in mind that the quality of the data you import determines the quality of your CRM data. We recommend that you go through your data and clean the import file before you start. Imports with huge amounts of data can be quite an exercise to clean up if things go wrong.

Choosing settings for your import

Adjusting the import settings will save you time and make it easier to import your data correctly. Here are two examples of what you should consider before you import your contact or product information:

  • You can define what the system should do if you import contacts that already exist in SuperOffice CRM. The system can overwrite or skip updating – it’s your choice.
  • You can choose to have the system create new categories automatically, if you use a category that doesn’t exist in SuperOffice CRM in your import file.
  • Configure import settings

Tip: For larger and complex imports, we always recommend using of one of our skilled consultants to ensure that the quality of the data you import into SuperOffice CRM is at its best.

How-to guides: 

In this article