Excel/CSV Parsing: Automatic Import into 1C-Bitrix

When importing products from Excel into 1C-Bitrix, content managers spend up to 80% of their time manually adapting files to CSV format. Bitrix's standard import requires a strict structure: fixed column headers (NAME, PRICE, QUANTITY, XML_ID), a specific encoding, and delimiter. Real data from suppliers, marketers, or 1C often has arbitrary headers (e.g., 'Name', 'Price without VAT'), merged cells, dates as numbers, and multi-line headers.

Our engineers have developed a parsing system that automatically converts any Excel or CSV to a structure suitable for catalog import. We use the PhpSpreadsheet library—it reads xlsx twice as fast as SimpleXLSX, making it up to 3 times better for large files, and correctly handles complex files with formatting.

Limitations of Standard Bitrix Import

Bitrix's built-in import mechanism is designed for perfectly prepared files. In practice, supplier files contain merged cells, hidden rows, different encodings, dates as numbers, and formulas. Our parser automatically detects these features and transforms data without loss.

How We Configure Parsing for Your File

The process involves three stages:

1. File structure analysis. Scan the first 10–20 rows, determine the header row, and identify data types in each column. Ignore hidden rows and sheets.
2. Mapping configuration creation. Based on the analysis, generate a file that maps headers from the file to infoblock fields. The configuration can be modified without rewriting code.
3. Transformation and loading. Apply necessary transformations (cleaning, conversion, normalization) and write data to the infoblock via Bitrix API.

Typical data transformations:

Step-by-Step Import Setup Instructions

1. Prepare your Excel/CSV file with data.
2. We analyze the file and create a mapping configuration.
3. You review a test import on a small file.
4. After approval, we run the full import.
5. We perform a final check and hand over documentation.

What's Included in the Work

• Analysis of source files (up to 10 different formats)
• Design of a flexible mapping configuration
• Implementation of a parser on PHP 8.1+ using PhpSpreadsheet and D7 ORM
• Testing on real data (minimum 10 files)
• Integration with Bitrix via CIBlockElement::Add() for new products or CIBlockElement::Update() for updates by XML_ID
• Documentation and staff training
• Guarantee on correct operation for 3 months

Return on Investment Speed

Manual processing of one file takes 2 to 8 hours. After implementing parsing, import takes minutes. The typical investment for a configurable importer is $1,200, but clients recoup it within one month through reduced manual labor. Automated parsing processes files 10 times faster than manual preparation.

Case Study: Electronics Online Store

Recently, our client, an electronics online store with a catalog of 15,000 products, reached out to us. The supplier sent Excel files with arbitrary structure: merged cells, dates as numbers, headers in English. Manual import took two days. We developed a parser with flexible mapping that processes the file in 10 minutes. Errors were reduced by 95%.

Official documentation CIBlockElement::Add() confirms that the method allows creating elements with uniqueness check.

Development Timelines

Cost is calculated individually after analyzing the technical specifications. Contact us for a preliminary estimate. Time savings reach 80%, significantly reducing operational expenses.

Our specialists have 1C-Bitrix certification and 10+ years of experience in corporate solutions development. Development cost starts at $300, and typical savings exceed $1,000 per month. Order a consultation — our engineers will help find the optimal solution.

Get a preliminary project estimate: simply contact us and describe your task.