Payments are experiencing issues due to temporary restrictions in Russia. If your payment does not go through, please submit a support request.Our support team is available 24/7 — we are always here to help with hosting and server issues.We are now accepting requests for dedicated server rental and colocation services in our data center.Reminder: we recommend enabling backups for additional data protection.A new VPS/VDS lineup with NVMe storage and improved performance is now available.Maintenance work on some servers has been completed. All services are operating normally.
Export/Import of Products to Excel

MODULE FOR 1C-BITRIX

esolutions.su

Export/Import of Products to Excel

The module enables export and import of products, trade offers, information block sections, and Highload block data in spreadsheet format. Export operations support CSV, XLS, XLSX, DBF, and PDF file formats. Import operations support CSV, XLS, XLSX, XLSM, HTML, and DBF formats. This solution combines the functionality of separate import and export modules.

5.00/5 · 39 ratings

1C-Bitrix Marketplace: 5/5 · 39 ratings

Technical details

Published
31 January 2018
Updated
5 October 2026
Version
3.3.5
Installed
More than 1000 times
Responsive design
Yes
Composite support
Yes
Compatible with Sites24
No
Developer
esolutions.su

What this solution does

The module enables export and import of products, trade offers, information block sections, and Highload block data in spreadsheet format. Export operations support CSV, XLS, XLSX, DBF, and PDF file formats. Import operations support CSV, XLS, XLSX, XLSM, HTML, and DBF formats.

This solution combines the functionality of separate import and export modules. It processes all standard information block element fields, including names, descriptions, images, and others. All property types are supported: multiple properties, images, lists, dictionaries, and bindings to information block elements and sections.

Catalog fields are fully supported, including available quantities, warehouse stock levels, and all price types. The system also handles SEO fields, discounts (percentage or fixed with start and end dates), sets and kits, all trade offer fields, and their section bindings.

The module supports export and import of InfoBlock section data, including all standard attributes (title, description, images), SEO parameters, and custom fields. Users can selectively choose specific product, offer, or section fields for export or import.

Features include scheduling operations via cron, creating and saving export/import profiles to store configurations, and supporting multiple sheets within a single Excel file. When generating price lists in xlsx format, the tool allows arbitrary fields, custom headers, style adjustments, image insertion, and formula usage. Data can be filtered before export.

The module supports importing arbitrary supplier files, searching and updating existing records based on selected fields, and bulk image uploads. File sources include local computers, server directories, remote sites (with authentication), FTP servers, and email addresses. It also allows applying discounts or markups to imported prices automatically.

The module supports complex data transformation during import, including merging values from multiple cells, removing substrings, replacing characters, and rounding numbers. Import settings allow handling missing products by deactivating them, resetting stock levels to zero, or assigning arbitrary property values. Empty sections are automatically deactivated after import. Bulk property creation is available before data upload. The system maintains a history of import profile runs and provides detailed statistics on updated elements and sections. Export files can be automatically sent to external resources such as Yandex Disk, Google Sheets, Bitrix24, FTP servers, or delivered via email to arbitrary addresses.

The module supports inserting custom headers via template files and allows the use of Excel formulas directly within price lists. Video tutorials cover core import capabilities. Guides detail importing categories with the ability to link items to multiple sections, processing files where categories are listed in separate rows, and importing empty categories without items. The tool also enables uploading trade offers and adding extra fields that are not present in the source file.

The module supports importing price lists from various suppliers with automatic deactivation of products not present in the new file. It enables the upload of current prices and stock levels. The system allows importing multiple product properties along with their descriptions. Automatic image upload is supported. The module handles importing properties listed in a single cell separated by a delimiter. Data can be automatically loaded on a schedule (cron) from email or via FTP. Bulk property creation is implemented. Import statistics are recorded to control data quality, allowing changes to be rolled back if necessary. Import files can be uploaded via an authorized secure link.

The module supports loading files from external cloud storage services, including Yandex.Disk, Google Drive, Mail.ru Cloud, and Dropbox. It enables calculation of prices and stock levels based on data from multiple suppliers. An advanced mode for price import with detailed parameter control is available. The system supports importing product sets and kits.

Additional capabilities include configuring automatic execution of export and import processes via the cron scheduler. The tool allows creating backups and restoring the product catalog using export files. It also supports transferring section structures between information blocks or to another website.

If importing products changes the URLs of elements or sections, use a separate solution to automatically create HTTP redirects.

General iT can handle the implementation of “Export/Import of Products to Excel”, from installation to configuration and compatibility checks.

UPDATE HISTORY

What’s new

11 releases
3.3.5 (01.10.2026)Latest update

Import.

1) File loading via external links has been improved.

2) An error in generating the symbolic code with translation via external services has been fixed.

3.3.4 (25.09.2026)

Export.

1) Module compatibility with older PHP versions has been improved.

2) Errors in the transformation functionality have been fixed.

3) A sorting error for elements by a List-type property has been corrected.

4) The filter on step 2 has been improved.

5) An "Apply formula" transformation has been added, allowing simple mathematical operations within a single field.

Import.

1) Module compatibility with older PHP versions has been improved.

2) An error causing import file loss when multiple users work simultaneously with the same profile has been fixed.

3) The import statistics page has been improved.

4) File loading via external links has been improved.

3.3.3 (26.06.2026)

Export.

1) Enhanced protection for POST data.

2) Improved user permission segregation.

3) Added an option to include the module in the proactive filter exceptions.

4) Improved file export to Google Drive.

Import.

1) Enhanced protection for POST data.

2) Improved user permission segregation.

3) Added an option to include the module in the proactive filter exceptions.

4) Updated the filter display for elements missing in the file during import into high-load blocks.

5) Improved cron job settings.

6) Improved reading of XLSX files.

7) Fixed errors in recording the execution history of profiles.

8) Improved loading of images from links in the site folder.

9) Improved quick search for fields in dropdown lists.

3.3.1 (31.05.2026)

Export.

1) Data export to Google Sheets has been improved.

2) Automatic header modification in the file upon changes to property names and other fields has been implemented using the {FIELD_NAME} notation.

3) Module security enhancements have been made.

4) The library for generating Excel files has been improved.

Import.

1) Handling of actions for elements missing in the file has been improved.

2) Loading of hidden rows in the file during import has been disabled.

3) Image loading during import of highload blocks has been improved.

4) Errors in the field settings binding functionality to file headers have been fixed.

5) Errors in the module database structure validation have been fixed.

6) File loading via external links has been improved.

7) Errors in sending email notifications to suppliers when no new import file is available have been fixed.

8) Module security enhancements have been made.

3.3.0 (20.04.2026)

Export.

1) Added the ability to set a password for the archive containing the export file.

2) Improved the functionality of PHP transformations.

3) Fixed errors during section export via cron.

4) Added the ability to export product reviews.

Import.

1) Improved user permission separation.

2) Optimized the import statistics page for large database volumes.

3) Implemented export of import statistics to Excel without pagination.

4) Improved error display when loading images via external links.

5) Fixed an error in image processing during import when resizing to uniform dimensions and filling fields with a white background.

6) Fixed an error in Highload Block import functionality.

7) Improved RAR archive extraction.

8) Improved the functionality for loading HTML format files.

9) Added property definition on step 2 for previously configured fields when modifying an information block for a specific file sheet.

10) Fixed an error in the "Send email notification if no new email with file" option when importing a file from an email address.

11) Optimized file loading from Yandex.Disk.

12) Improved file loading via external links.

13) Fixed errors in sending email notifications about product arrival when subscribed to a product.

14) When loading from an email address, added the ability to specify a filename mask for a specific file in the archive using the # symbol.

15) Improved XLSX file reading.

USER EXPERIENCE

Solution reviews

How does this solution work in a real project? Share your experience and help others choose.

Be the first to share your experience

There are no reviews of this solution on git.ru yet. Tell us what worked well and what could be improved.

Verified purchaseAdd a key if you wish. A verified review gets a badge, priority placement and more rating weight.

Open to every clientJust sign in to your account. A key is optional; all reviews are moderated.

YOUR EXPERIENCE MATTERS

Your review

YOUR PROJECT INFRASTRUCTURE

A home for your website

BEFORE YOU ORDER

Let’s go through the details.

What does the price cover?
The displayed price covers the solution itself. Platform licensing, installation and customisation are checked separately. If the page offers bundles, select the required option before submitting a request.
How do I check compatibility?
Compare the supported editions and solution version in the technical details with your project. Before installing on a live website, we recommend making a backup and checking the solution in a test environment.
Is there a trial?
The developer lists a trial of 14 days. The trial button opens the installer in your website control panel. Check the required features and compatibility before purchasing.
How much does this solution’s renewal cost?
The current renewal price is 5,000 ₽. Before you order, a manager will confirm the renewal period and whether it applies to your licence.
Can you help with implementation?
We can help install the module, check its settings and verify how it works in your project. Compatibility with other customisations and the scope of work are assessed before we begin.

GENERAL iT

Let’s discuss your project

Получатель: ООО «Дженерал Ай Ти Рус»

1C-BITRIX

Install solution

Enter a domain with or without https://. The installer will open in your website control panel in a new tab.

Solution screenshots

Solution screenshot