Skip to main content
import1

​
Overview

Learn how to import .CSV data into Relate. Basic importing instructions can be found in the guide you are currently viewing. For List/Process and Linkedin import instructions, please navigate to the cards below.

List/Process Import

LinkedIn Import

If you have a large amount of data, then you might want to try importing some of your customer data as a test first.
  • If it all goes in successfully, then import the rest of your data in the same way.
  • If any data fails to import, then check the reason why, fix the remaining customer data, and try importing again.
Deal will be integrated with Process in the first half of the year, so the import guide doesn’t mention how to import Deal separately. The basic method is the same as Process.

​
What you need to know before importing customer data

​
1. Import data types

There are four types of import type in Relate. Relate Data When categorizing customer information within Relate, Organization is the default, with People falling within Organization. Process and List are a series of deal closing processes and customer lists that you create using Organization and Contact.

​
2. Data Field

Organization, People, Process, and List have data fields that are specific to their nature by default. They have default fields that are required to be filled in.
  1. Organization: Organization name must be entered.
  2. People: You must enter either Contact name or Contact Email.
  3. Process / List: Check the Entry type (Organization, Contact) of the process and list and follow 1 or 2.
Below you’ll find a quick overview of what other default fields are available.
  • Organization name (Required)
  • Domain (Website): If you have a Contact that belongs to an Organization, it will automatically populate with their email domain if you don’t create a separate domain for them.
  • Description
  • Manager
  • Contact name
  • Email
  • Title
  • Phone number
By default, processes have different default fields depending on whether the Entry type is Organization or Contact.Therefore, we introduce the default fields that the process itself has.
  • Value
  • Status
  • Assignee
  • Contact
Other than the default fields for Organization and Contact, which are data types for lists, lists do not have their own default fields.

​
3. Set up your custom fields

import-custom The first thing you need to do before you start importing is to set up and verify your custom fields. By default, if you have information that you want to import other than the default fields provided by Relate, you must create custom fields before importing. If information comes in without a field, Relate will not create the field and import the information. Therefore, if you try to import without creating a custom field, the import of the file will fail. You can follow the instructions in the Custom Fields Guide to create your custom fields first, then launch the Import menu.

​
How to import

Go to the Admin page, select Import from the left menu bar, and then click type of Import (Organizations, Lists and Processes) you want to import. Relate Data If you want to register a contact, you can choose one of the two methods below.
  1. Import Organizations: This is mainly used when you register an Organization and a Contact together (Organization name required)
  2. Import Lists: This is mainly used when you want to register Contacts as a list. However, you need to create the contact list you want to import in Relate beforehand. (Organization name not required)

​
Step 1. Create a .CSV file

You can download a sample .CSV file with default fields via Download example and use it to prepare your file for import. If you already have a .CSV file ready to import, you can proceed directly to Step 2.
Note that sample custom fields in the sample .CSV file are just samples! You’ll need to create your own set of custom fields if you’re planning to import additional fields. Custom fields guide

​
Creating a file to co-create Contacts with Import Organizations

Here’s how to import Organizations and also import Contacts that belong to those organizations. import
  1. First, create a header with the data fields you want to include in the Organization.
  2. Also, fill in the fields for Contact that you want to include, which must be either name or email.
  3. Enter all of the information for the Organization and the information for the Contact that you want to include in the first line, excluding the header.
  4. Next, for the Contact that will be in that organization, complete only the Organization name and then fill in the Contact information.
  5. Continue to create Organization name-Contact, and repeat steps 2-3 if you want to add another Organization and the Contacts that belong to it. (See line 6 in the photo.)
The most important thing to remember in this process is that you only need to fill out all of the information for the Organization you want to import the first time. And, from the second Contact you create in the Organization, you only need to fill out the Organization name. This is because even if you create multiple copies of the same Organization, only the first Organization data will be imported.

​
Step 2. Upload file

Drag and drop a .CSV file or click to choose a file from your local computer. import2 Once the files have been added successfully, press Next Step at the bottom right corner to proceed.
Note that by default, first row is a header. If you want to treat the first row as data value, turn this mode off by switching the top left toggle button.

​
Step 3. Match columns

In this step, you can match the columns in your .CSV file with the data fields in Relate. import1 Note that you can also skip any fields you do not wish to import.

​
Smart fuzzy matching

Input CSV file and destination columns are automatically mapped using smart fuzzy text matching.

​
Fix validation issues seamlessly

If any fields need fixing, you can edit them as if you’re editing a spreadsheet directly from the import page. No need to go back to your local Excel file. If anything goes wrong during this process, error will be displayed in red. Relate Data Import error Proceed to next step once you have matched all of the columns.

​
Step 4: Import data

Once you click the Import Data button you should see a confirmation. Confirm the import and you should be able to see the screen below. successful Relate Data

​
Import Lists

list import 1 For Contact list, you can import a CSV file directly from a contact list you’ve already created without going through the Admin page.

​
Frequently Asked Questions

You can open the file, save it as XLSX instead of CSV, and reimport it as follows.
  1. In Microsoft Excel, on the Data tab, click Get Data (Power Query) export1
  2. click Text/CSV and select the file with the broken Korean characters export2
  3. select UTF8 and click Load export3
When an import fails, you can see the following message: Download .csv with rows that were not imported. rejected-row 1This sentence will give you a reject file, which will also contain the reason for the reject. You can see this in the column called error in that file. rejected-row 2
There are two main reasons why imports fail.First, duplicate fields with unique values. In Relate, Organization name, Contact email, and Domain cannot have duplicate values in any case.For example, if two different organizations, Relate (@example.so) and Pixelic (@example.so), have the same domain, the import will fail due to a duplicate import violation. This is especially true for domains, which are automatically generated based on emails without you having to enter them.Second, if you imported an invalid email - for example, if the email contains special characters other than @, or is from an invalid email account.
⌘I