TeamLab: Import and Export of Your CRM Data

The import and export operations represent an integral part of work with any data system making our life much easier. TeamLab is no exception. Within the CRM module you can import and export contacts, opportunities, tasks and cases – in a word the whole module content.

Importing Data

If you only start working with TeamLab CRM, you will surely appreciate the import option. Using it you can import the whole contacts list, tasks, opportunities, or cases into the CRM module.

To import contacts please proceed through the following steps:

1. Prepare your CSV file for importing.

Note: CSV (comma-separated values) represents a simple file format that is widely supported by various applications, e.g. text editors. Such files store tabular data in the plain-text form. The CSV format is frequently used to transfer information from a database program to a spreadsheet. Despite the format name, not only the comma can separate fields in such a file, other delimiters can also be used for this purpose.

If you already have a CSV file containing the contact information make sure that it meets the following requirements for a correct data import:

  • The first row is a header record containing column/field names. The required fields are: ‘First Name’ and ‘Last Name’ for importing persons, ‘Company Name’ for companies.
  • There is one contact record per row.
  • There are no unnecessary commas in your file.
  • The selected file contains less than 10 000 rows, otherwise it should be divided into smaller parts.

2. Open the CRM module.

3. Click the ‘Import contacts’ link above the contact list. Click the ‘Select a CSV file’ link on the ‘Import Contacts’ page. Browse your computer hard disk drive for the necessary file. Once the file is located, click the ‘Open’ button to load it into the system. The file will be loaded and displayed instead of the link. To replace it, use the ‘Update’ link next to the file name.

4. Set your CSV file settings for proper importing:

  • Delimiter – select the character used to separate values in your CSV file: comma, semicolon, colon, tabulation, space.
  • Encoding – specify the encoding type used while saving your CSV file. The default type is UTF-8.
  • Text delimiter – specify the character used to enclose the fields in your CSV file.

5. After that select the action which will be performed with the duplicate records in case there are some. Check the ‘Skip’ option to import contacts keeping the existing contacts, use the ‘Overwrite’ option if you wish to import them overwriting the existing ones or leave the default ‘Duplicate’ option checked if you need to duplicate the coinciding contacts.

6. If your CSV file has a header row with the column titles make sure that the ‘Ignore the first row when importing’ box is checked.

7. By default, the access to the imported contacts will be granted to all portal users. If you wish to restrict the access, check the ‘Restrict access to the contact’ box. To make the contact available to a certain person, click the ‘Add user’ link and select a person from the list.

8. Before importing your customer data, you need to verify the available information. You will see the table with three columns:

  • File column – the first row of your CSV file containing the column/field names.
  • Corresponding TeamLab CRM field – the TeamLab CRM field corresponding to the field/column name from your file if there is one.
    If the system does not find any corresponding CRM field automatically, open the dropdown list and select the necessary one manually.
  • Value – the available file column value. To verify all the file information, use the ‘Next record’/ ‘Previous record’ links at the top.

To be able to import persons you need to match at least one column from your file with the ‘First Name’ and another with the ‘Last Name’ fields of the TeamLab CRM. The same is for the company import, you will need to match the ‘Company Name’ field to be able to import a company.

9. After you check the customer data, click the ‘Start importing contacts’ button below the contact list to launch the process.

That’s all. All the selected contacts will be imported and displayed in the ‘Contacts’ tab.

In the same way you can import tasks, opportunities, and cases stored in a .csv file as well.

Exporting Data

Leading a business, it’s vital to be always on the safe side and regularly backup your CRM data with important information on your customers, opportunities, tasks, cases as well as contact history. TeamLab gives you the possibility to export your data into CSV files and download in a ZIP archive with just one mouse click! You can export all your CRM data or just contacts, tasks, opportunities, or cases. Please bear in mind that this feature is available to administrators only.

To export all your CRM data, proceed through the following steps:
1. Open the CRM module.
2. Switch to the ‘Settings’ tab and you will see the common CRM settings.
3. Click the ‘Download all data in one ZIP archive’ button within the ‘Export of All Data’ section.

You will have to wait several minutes depending on the amount of your data till a ZIP archive is generated. After that a link to the created ZIP archive will be displayed under the progress bar. You will also receive an email notification containing a link for you to download the created ZIP archive.

Note: during the export operation, the CRM data are transferred into CSV files. The data from each section (e.g. opportunities, contacts, tasks, etc.) are saved to a separate CSV file. After that all the created CSV files are packed into a ZIP archive to compress them. After downloading and unpacking the archive using unzip software, you'll get five CSV files - cases.csv, tasks.csv, deals.csv, history.csv, contacts.csv.

To export contacts, tasks, opportunities, or cases separately, please follow the steps below:
1. Open the CRM module.
2. Switch to the tab you need – ‘Contacts’, ‘Tasks’, ‘Opportunities’, or ‘Cases’.
3. Click the ‘Export current list to a CSV file’ link under the page title.
4. Select one of the options – ‘Download as one file’ or ‘Open in editor’.

If you select the first option, the data will be downloaded to your computer hard disk drive. If you select the other option, the data will be opened in TeamLab Spreadsheet Editor.

That’s all for today. If you have questions and need assistance, please visit our Help Center or write an email to our Support Team. In case you have a great idea concerning TeamLab improvement or just want to express your opinion, you can leave your feedback that will surely be checked out and taken into consideration.


View Comments

  • It would be nice if you could select on date as well. I want to export the added contacts of last month only. Currently that does not seem possible. Or as another solution, add the entry date to the CSV file so I can take it from there.

    • Hello Joost,
      It's a good idea! Please add it to our special feedback page for other TeamLab users to vote for your suggestion. If it becomes popular, it'll be implemented in one of the next versions.

  • Hi,

    I did not find the Link "Export current list to a CSV file" in version 7. If I make a List with 5 persons, I can't export to csv. Furthemore it would be nice, to define the columns to export.


    • Hello Michael,
      Please follow these steps:
      1. Open the CRM module.
      2. Switch to the section you need in the left-side panel: contacts, tasks, opportunities, cases.
      3. Click the button with three dots and an arrow in the left upper corner and select the “Export current list to a CSV file” from the list.

  • I am new to teamlab and I see an issue with file imprt for CRM. Please help.

    When I select the file it does not show the table but it shows a link so I cannot verify info. as discussed in item #8 above. Instead I see that when I click on 'start importing contacts" it goes in a Scanning Mode in the bar and gets hung up. I have sent files today via feedback and support.

    • Hello Narain,
      Sorry for the delay!
      After you selected a file, you can process to the next step clicking the 'Continue' button. At step 2 you will see the table where you can verify your data.
      Please specify the TeamLab version you use. The procedure described in this post is valid for TeamLab SaaS version 6.5.

      • I have tried that many times during last three days but it just gets stuck while scanning. Once I left it and went to bathroom and when I came back it was still scanning. My file is only 10 rows and 10 columns as I am using it as a test file. I am using your server for my portal so I don't know what its version is, it must be the latest. How do I check it. Here is the image of the page where my file is stuck in scanning. Can I email you my file? It is important for me to resolve this issue as it is delaying my deliverables schedule.

        Import contacts

        Select a CSV file and set access rights before you import contacts
        Note: the file size cannot exceed 10 MB

        A properly formed CSV file should be selected on your computer HDD. It must contain the fields or columns separated by a delimiter which will be used to import persons or companies - 'First Name' and 'Last Name' for persons, 'Company Name' for companies. The files containing more than 10000 rows should be divided into smaller parts for proper importing. Make sure you selected the portal users who need to be granted access to the contact details, otherwise the data from the CSV file will be available to all portal users.

        Selected CSV file: Testrecords_MA_List (3).csvEdit

        CSV File Settings:


        Unicode (UTF-8)

        Text Delimiter:
        Double quote

        Duplicate Records:
        Check for duplicates will be performed based on the Email field.


        Ignore the first row when importing

        Access rights
        The access is granted to all the portal users by default. To restrict the access check the box below.

        Restrict access to the contact
        Scanning the file...

          • Hi guys,

            I am doing an import with a .csv created with teamlab docs.

            Fields match works, import works BUT contacts are "messed up": first contact has last one contact adresse and all other contacts do not have any adress.... It is really strange.

            Please, help :-)


          • Hello Nicolas,
            Sorry for the late reply!
            Please specify the TeamLab version you use. Is it an open-source, server, or SaaS version? 5.5, 6.0, 6.5, or 7.0 beta?

Recent Posts

  • Success story

How ONLYOFFICE helps organize research workflow in the Institute of Biology of Lille

The Institute of Biology of Lille has implemented ONLYOFFICE within its research units to facilitate workflow. This use case was…

1 day ago
  • Open source
  • Partnership

FOSDEM 2020: ONLYOFFICE highlights

Shortly after CS3, we visited another event meaningful for European open-source community: FOSDEM 2020 in Brussels. Read more in this…

1 week ago
  • Events
  • Events

ONLYOFFICE at CS3 Workshop 2020: our summary

Last week, the ONLYOFFICE team went to a notable event for the global scientific community: Workshop on Cloud Services for…

2 weeks ago

Meet ONLYOFFICE at MWC Barcelona 2020

Hi everybody! We are going to wrap up our series of winter business trips with attending MWC Barcelona this February.…

2 weeks ago
  • What's new
  • What's new

ONLYOFFICE partners with CEO-Vision: the symbiosis of online editors and the digital workplace GoFast

ONLYOFFICE is proud to announce its official partnership with CEO-Vision. The agreement was signed on the margins of the Paris…

3 weeks ago
  • Integration
  • ONLYOFFICE Tips and Tricks

How to configure reverse proxy for Nextcloud and ONLYOFFICE editors

Hi everyone! Most of the ways to integrate ONLYOFFICE with Nextcloud are described in our API documentation, but some cases…

3 weeks ago

This website uses cookies. By continuing to browse the website you agree to our privacy policy.

our privacy policy