Bitrix24 CRM ⇆ MS Excel

Description:

The application allows you to export CRM data from Bitrix24 to MS Excel for further editing, adding, and bulk deleting records, with the ability to import all modified data from the MS Excel file back into Bitrix24. Over 40 CRM entities are supported: Leads, Deals, Contacts, Companies, Estimates, Invoices, Activities, Addresses, Currencies, VAT Rates, Units of Measure, Products, Product Catalogs, Product Sections, Products (Properties), Product Rows, Requisites, Bank Details, Requisite Links, Requisite Templates, Requisite Template Fields, Directories, Payment Systems, Payer Types, Call Lists, Documents (Generator), Document Templates, Document Numerators, Recurring Deals, Recurring Invoices, Invoice Statuses, Payments, Deliveries, Digital Workplaces, Duplicate Settings, Activity Icons, Activity Bindings, Activity Types, Timeline Comments, Timeline Log Entries, Custom Fields (Leads, Deals, Contacts, Companies, Invoices, Estimates, Requisites).

Features:

1. To create a new record, the ID field must be empty; otherwise, the record with the specified ID will be upd ated.
   
2. To delete a record, se t the _DELETE column value to 1.
   
3. Available operations (add, update, delete) depend on the entity — restrictions are indicated by colored labels.
   
4. During export, reference sheets (Fields, Users, Stages, etc.) are automatically added to help decode identifiers.
   
5. Export filters are supported: by stage, assigned person, date, pipeline, and other parameters.
   

Instructions: A complete user guide is available in the "Help" section. To access it, install the application and click the menu button (⚙) in the top right corner of the application, then select "Help".

Application capabilities/limitations/features:

1. Supports MS Excel files with the .xlsx extension.
   
2. Two-way conversion Bitrix24 CRM ⇆ MS Excel.
   
3. Supports over 40 CRM entities (Leads, Deals, Contacts, Companies, etc.).
   
4. To create a new record, the ID field must be empty; to delete — set _DELETE column to 1.
   
5. Available operations depend on the entity and are indicated by colored labels.
   
6. Maximum upload file size — 30 MB.