How to import a contact file?

Overview: manual import
Import a contacts file
What is the correct format for my import file?
What is the maximum file size for an import?
My import encountered an error: what can I do?

1. Overview: manual import

Arenametrix provides a simplified data import tool available on the Import page. This feature allows you to add contacts and/or BtoB contacts to your database in bulk. As long as your Excel file contains data related to contacts, it can be imported.

Please note: the only requirement is that each column must represent a specific type of information, and each row must represent one contact. In addition, the first row must contain the column headers so that the information can be correctly identified (see the screenshot below).

2. Import a contacts file

To do this, go to the Contacts tab, then click Import (1). Next, select your Excel file (2), give it a name (3), then Submit the import (4).

Next comes the field mapping page. This page allows Arenametrix to place the correct information in the appropriate fields of the contact records. You will need to match the fields from your file with those in Arenametrix, as shown in the example below. By clicking the dropdown menu, you will find the information from your file.

Then select the column from your file that corresponds to the First name field in Arenametrix.

Once you have matched all the available information, validate by clicking Import.
Your contacts are then imported.

3. What is the correct format for my import file?

You can import a spreadsheet file, with 2 possible formats:

.xlsx
.csv

4. What is the maximum size of a file to import?

Your file must not exceed 10 MB, for technical load reasons.

If your file is larger, you have several options:

split your file into multiple parts
reduce the size of your file by removing unnecessary columns that will not be imported

5. My import encountered an error: what can I do?

Here is a list of the main problems you may encounter:

Problem	Solution
I want to import BtoB contacts only.	Please refer to this article: Import a BtoB contacts file
Following an import of Contacts + BtoB contacts, my import displays an error message.	Separate your file in two: first import the contacts without a structure, then the contacts with an associated structure. If the problem persists on the second import, contact your support manager by sending him an email with your file.
Following an import of Contacts, my import displays an error message.	Check the cells in your import file: the column headers must not contain spaces, the following special characters [ " ( can cause an error.
An error occurs while loading my file.	Check the format of your file. Some types of .csv files are problematic. Convert your file to .xlsx for better technical support.