--- title: "Import or export data" slug: "import-data-into-kommo" description: "Learn how to import and export leads, contacts and companies. " updated: 2026-06-11T17:59:49Z published: 2026-06-11T17:59:49Z canonical: "support.kommo.com/import-data-into-kommo" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.kommo.com/llms.txt > Use this file to discover all available pages before exploring further. # Import or export data > [!NOTE] > **What you’ll need:** > > - Any Kommo plan (Base, Advanced, Pro, Enterprise, or 14-day trial) > > **Keep in mind:** > > - File size must not exceed **2 MB** and should contain no more than **10,000 rows** > - The spreadsheet must not include empty rows > - Only single-sheet (one-page) spreadsheets can be imported > - The spreadsheet must include names for the records > - Each Kommo plan includes a limited number of leads, contacts, and companies. You can view the exact limits [here](/v1/docs/plans-limits) In Kommo, your client database consists of leads, contacts, and companies. You can add records manually one by one, or save time by importing them in bulk from a file or a spreadsheet. You can also export your records at any time — for example, to analyze your data or use it in other tools. This article walks you through the import and export process step by step. ## Import leads, contacts and companies Supported formats: - [File uploads: .xls, .xlsx, .ods, .csv](/v1/docs/leads-contacts-companies-hub-spokes-4#import-from-a-file) - [Google Sheets: import directly from your spreadsheet](/v1/docs/leads-contacts-companies-hub-spokes-4#import-from-a-google-sheet) You can import records in two ways: - **Single spreadsheet** — if one spreadsheet contains information about leads, contacts, and companies, Kommo can create and link all records during a single import. - **Multiple spreadsheets** — if your leads, contacts, and companies are stored in separate spreadsheets, import each file separately and link the records later if needed. Learn how in [this article](/v1/docs/handle-incoming-leads). > [!WARNING] > **Important:** Before importing, check that the column names in your file or Google Sheet match the field names in Kommo exactly, including capitalization. ## Import from a file 1. Go to **Pipelines → All leads**, click **…**, and select **Import**. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-mxsmy3wl.png) 2. Click **Load file** and select a file from your computer. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-8kytkrvo.png) 3. Choose the delimiter. 4. Match the fields to import. 5. Optionally, add a tag to make it easier to find the imported records later. 6. Optionally, save the field order as a template if you want to reuse it in the future — enter a name in the **Save template** field. 7. Optionally, check **Update existing data** to update records that already exist in Kommo. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-2jjmghnd.png) 8. Click **Next**, then **Continue with CRM** to complete the import. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-rw1ib57r.png) ## Import from a Google Sheet 1. Go to **Pipelines → All leads**, click **…**, and select **Import**. 2. Click **Authorize** and log in with your Google account. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-h7yqmwo6.png) 3. After returning to Kommo, click **+ Choose spreadsheet**. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-5z8yg45l.png) 4. Search for your spreadsheet, click it, and click **Select**. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-lhie5jvp.png) 5. Match the fields to import. 6. Optionally, add a tag to make it easier to find the imported records later. 7. Optionally, check **Update existing data** to update records that already exist in Kommo. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-b8rh9r23.png) 8. Click **Next**, then **Continue with CRM** to complete the import. If your spreadsheet includes contact and company details, Kommo will automatically create and link those records to the imported leads. To import contacts and companies separately, go to **Lists → Contacts** or **Companies** and follow the same steps. To learn how to add custom fields, check out [this article](/v1/docs/customize-fields-in-lead-profiles). ## Export leads, contacts and companies You can export your data from Kommo in the following formats: - [Files: .xlsx, .csv, .vcf](/v1/docs/leads-contacts-companies-hub-spokes-4#export-to-a-file) - [Google Sheets: export directly to a spreadsheet](/v1/docs/leads-contacts-companies-hub-spokes-4#export-to-a-google-sheet) ## Export to a file 1. Go to **Pipelines → All leads**, click **…**, and select **Export**. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-1ub9h8z8.png) 2. Choose a file format and select which records to export — all records or only those on the current page. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-26oojdsj.png) 3. Click **Export** and download the file. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-sjd80fl1.png) ## Export to a Google Sheet 1. Go to **Pipelines → All leads**, click **…**, and select **Export**. 2. Select **Google Sheet** as the format and choose which records to export – all records or only those on the current page. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-o4hc8huw.png) 3. Click **Authorize** and log in with your Google account. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-7hvqbykg.png) 4. Once logged in, click **Choose folder**. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-jcxbsa79.png) 5. Search for and select a destination folder, then click **Select**. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-1qqdtba9.png) 6. Confirm the selected folder in the export window and click **Export**. ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/leads-contacts--companies-hub--spokes-4-image-17qwsi9m.png) 7. When the export is done, a confirmation message will appear with a link to the exported sheet. You can also export contacts and companies — go to **Lists → Contacts** or **Companies** and follow the same steps. ## Related - [Export your data](/data-export.md) - [Create your first lead](/create-lead.md)