background Layer 1

Forgot password

Incorrect email format
Please complete reCAPTCHA
mail inbox

Check your email

Reset instructions have been sent to your email. Don’t forget to check your spam folder.

Create account

Change password


Nicely done!

Your password has been changed successfully.

Moving between CRM and spreadsheet is crucial for many businesses, so we wanted to make it as painless as possible. We’ve simplified the process with easy field mapping and template creation, so after you import once, the next time is a breeze.


    Linked data makes it easy

    First, a little background. In Kommo, your database is made up of 4 types of entries: contacts, leads, companies and customers. Each type gets its own personal profile, but they’re also linked. This gives you the freedom to work with each separately, but also navigate to the others in one click.

    Ultra Easy Data Import


    The great thing about Kommo’s linked profiles is that you can import from any of the sections (leads, contacts, companies or customers) and cards will be created in each. That means when you import the contact Charles Dickens, the system can also create a company card for his business Two Cities Inc., and a lead card for the project, Design a Book Cover. And they’ll all be linked.

    Just go to any of the sections and press the ··· button and select import.

    Kommo data import

    Formatting data

    Kommo accepts the most popular file formats:

    • Excel pre-2007 (.xls)
    • Excel post-2007 (.xlsx)
    • OpenDocument spreadsheet (.ods)
    • Comma separated file (.csv)
    Note that if your file includes any dates, you should convert the file to a .csv in order for the system to correctly work with it. To do so in Excel, just click “save as” and select file type CSV.

    Field mapping

    Next, you want to make sure that the data from your spreadsheet ends up in the right fields in Kommo. All you have to do is select the Kommo field that matches each of your columns. You can also leave out individual columns if you don’t need that data in Kommo.

    Another cool thing—you can assign tags. This would be great if you, for example, wanted to get a sample of all the leads that were imported in July or from a certain campaign. The most awesome part is that after all that hard work, you can save it as a template to make import seamless next time.

    Filling fields import data

    What's next

    Importing is only one way to get leads into the system. Kommo comes with a whole host of automations and features that grab new leads instantly from your lead generation sources to eliminate manual entry.

    Make a personal sale with Kommo

    Kommo is a pioneering Messenger Based Sales CRM software that helps businesses achieve more sales and create long-lasting relationships with their customers. It is a tool that enables companies to reach better results and increase their profits.

    CRM Basics All
    Jacqueline Phillips is head of marketing at Kommo
    Jacqueline Phillips

    Marketing Specialist, Kommo

    I’m on a mission to help small teams
    win more sales!


      // More posts

      CRM Basics

      4 CRM Workflow Secrets That Will Save You Time and Money

      CRM Basics

      Three Steps to Implementing a CRM User Training Plan

      Ready to test drive Kommo for yourself?