XLS Import

XLS Import Manual · Chapter 5

How to use XLS Import in Vtiger CRM

Vtiger 7.x / 8.x
Product page

After successful installation of XLS Import you are able to access module and start using it.

To access the XLS Import extension, navigate via the menu to the XLS Import module: TOOLS — XLS Import:

XLS Import for Vtiger CRM
XLS Import – How to enter module

5.1 Create new XLS Import

We will show you how you can easily import any records for any module you need, we will use module Contacts as an example in next steps.

First, you will be needed to prepare .xls file with your records, second part is to load file via XLS Import extension, so let’s divide it into two parts:

  • XLS (.xls) file preparation for Import
  • Importing the .xls file via XLS Import extension

5.1.1 XLS (.xls) file preparation for Import

The .xls file should contain:

  • (A) Vtiger fields –default or custom fields created in Vtiger
  • (B) Record values –details for specific field in the record

Below you can see a simple example where we want import 4 records for Contacts module:

  • (A) Vtiger fields will be filled with the (B) Record values

(Click on the image to enlarge)

XLS Import for Vtiger 7
XLS Import – xls file overview

5.1.2 Importing the .xls file via XLS Import extension

When you have already .xls file ready, we can proceed with Importing.

In order to start import please provide following steps:

    1. Go to the XLS Import module (Menu – Tools – XLS Import).
    2. Click on the button XLS import create XLS import button – Importing the .xls file via XLS Import extension
    3. A new window will appear, select the module (we will be doing Contacts module) and load the .xls file by clicking on “Drop file here or click to upload”.
      XLS Import how to import file
      XLS Import – How to import file
    4. When the .xlsx file is loaded, new features, options are available:
      • File Type – the type of file you loaded
        (mostly this is selected automatically based on the file type you loaded).
      • Duplicates handling – you can choose the duplicates handling methods like Skip, Overwrite, Merge based on selected fields.
      • Additional settings – Trigger workflow (counts as record create/update)
        Create picklist values (create a picklist if there are more values,
        for example: First name: Martin, Peter).
        XLS Import how to import file
        XLS Import – How to import file, features

        Proceed via Next button – Importing the .xls file via XLS Import extension button.

    5. The next step is mainly about field mapping, you can change the field mapping or save custom mapping.
      You have the option to change the name of the Import (A).
      Change the mapping for specific fields (B).
      Set Default value (C).
      Create own custom mapping (D1) and use it for future imports (D2).

      (Click on the image to enlarge)

      XLS Import how to import file
      XLS Import – How to import file, mapping step overview

      Proceed via Import button – Importing the .xls file via XLS Import extension button.

    6. The last step is where you can see the results of the import, you can see how many records were imported/created in total and if any of records failed to import.

      In our case, you see all 4 Contacts (records) were imported properly.

      XLS Import gow to import file
      XLS Import – Results of import

      You can finish the importing via Finish button – Importing the .xls file via XLS Import extension button or perform additional steps like:

      • XLS import import more button – Importing the .xls file via XLS Import extension – start new import process
        (current import will be finished and records will be imported),
      • Importing the .xls file via XLS Import extension – shows the list of imported records,
      • Importing the .xls file via XLS Import extension – cancels the current import
        (records will be removed from the system).

Our Contacts were Imported successfully

XLS Import how to import file
XLS Import – Successfully imported records

Need help with XLS Import?

Our support team answers questions about installation, templates and settings.