Alexander Ruin

AI Systems Design Consultant

Alexander Ruin — systems design consultant. I help design architecture, assess risks, and establish transparent processes — from technology selection to support. AI executors handle routine tasks. Areas: automation, integrations, AI products.

1C Export Formats (CSV/JSON/XML) 2026: How to Choose for Reports, API and EDI

Manually selecting an export format from 1C for each task leads to confusion, integration errors, and problems loading data into bank clients or marketplaces. In 2026, the correct export format is configured in 15 minutes, and data exchange runs automatically.

Key Facts

  • 1C supports 5 main export formats: CSV, JSON, XML, TXT, Excel (XLSX)
  • CSV is suitable for simple tables and reports, JSON for API integrations, XML for EDI and transfer documents
  • Format choice depends on the task: where you're exporting (Excel, bank, marketplace, web service)
  • Standard 1C configurations support all formats, setup takes 5-15 minutes
  • Automatic scheduled exports are possible via scheduled jobs or Telegram bot

Format Comparison: When to Use Each?

Format Best For Pros Cons Example Use
CSV Tables, Excel reports Simple, readable in any editor No hierarchy, text only Inventory export
JSON APIs, web services, integrations Compact, supports nested structures Needs parser to read CRM, marketplace exchange
XML Transfer documents, invoices, EDI Standard for electronic documents Large file size EDI document export
TXT Bank client, simple lists Universal, minimal size No standard structure Payment orders to bank
Excel (XLSX) Management reports Ready visualization, charts Large file size Financial reports, analytics

How to Set Up Export in the Right Format in 3 Steps?

Export in any format is configured through standard 1C functionality or automatically via the Synchron1C Telegram bot.

Step 1. Select Export Object and Format

Open the required directory, document, or report in 1C → File → Save As → select format (CSV, XML, TXT, Excel). Specify the export period to limit data by date.

Step 2. Configure Data Structure (for JSON, XML)

For JSON and XML, specify which fields to export, element names, and whether hierarchy is needed. Standard configurations have ready templates for transfer documents (XML), bank statements (TXT), and reports (XLSX).

Step 3. Automate Export

Manually saving files each time is inconvenient. The Synchron1C Telegram bot automatically exports data from 1C in the required format on schedule (hourly, daily, weekly) and sends it to the target system (bank, marketplace, EDI).

Setting up automatic export from 1C in different formats

Synchron1C Telegram bot — automatic export to CSV, JSON, XML

When to Use Each Format: Examples for Different Tasks

Task Format Why
Export inventory to Excel CSV Opens in any editor, simple table
Send transfer document to partner XML Tax authority standard for electronic documents
Marketplace integration (Ozon, WB) JSON Marketplace APIs work with JSON
Payment orders to bank TXT Bank-client format, all banks understand
Report for director Excel (XLSX) Ready charts, pivot tables
CRM synchronization JSON Compact format for REST API
Invoice export to EDI XML EDI standard, automatic digital signature

See Also

Frequently Asked Questions

Which format to choose for Excel export?

CSV is a simple and universal format that opens in any Excel version. If you need charts and formatting, use XLSX.

Can I export transfer documents from 1C in JSON format?

No, transfer documents are exported only in XML format according to tax authority standards. JSON is not suitable for transfer documents.

How to automatically export data from 1C in the required format?

Set up a scheduled job in 1C or use Synchron1C — the bot automatically exports data on schedule and sends it to the target system.

Which format is better for 1C-to-website integration?

JSON is a compact and fast format, all modern web services work with JSON via REST API.

Stop manually selecting formats and saving files each time.

Synchron1C automates export from 1C in any format (CSV, JSON, XML, TXT, Excel) — setup in 15 minutes, no programmer needed.

What we automate: - Data export to CSV, JSON, XML, TXT, Excel on schedule - File delivery to bank client, marketplaces, EDI, CRM - Format conversion (CSV → JSON, XML → Excel) - Telegram notifications when export completes - Automatic data structure validation before sending

Two payment options: - 5 000 ₽/month — subscription, free setup + all updates - 30 000 ₽ — one-time payment, setup + updates for a year

Connect Integration →

Learn more about features on the Synchron1C page.

Article prepared by Synchron1C Team. Updated: February 2026.

Sources: - https://infostart.ru/marketplace/2519349/ - https://42clouds.com/ru-ru/manuals/kak-zagruzit-ili-vygruzit-dannye-iz-1s-v-formate-xml/ - https://bi.denvic.ru/blog/oldovye-formaty-vygruzki-dannykh-iz-1s-operativnaya-svodka-prodazh-s-pomoshchyu-ekstraktora-1s/ - https://is1c.ru/about/pc/article/vygruzka-iz-1s-v-format-xml-i-prostoy-primer-xdto/ - https://www.koderline.ru/expert/narabotki/article-vygruzka-dannykh-iz-1s-v-formate-json/

About the service "Sync1C - 1C Automation Without a Programmer"

A universal solution for automating export, import, integrations, and monitoring of 1C through a simple dialog in Telegram. Set up in 15 minutes without involving a 1C programmer.

Key Benefits:

  • 💰 Savings on analysts and 1C programmers (from1,000 USDT/month)
  • ⚡ Automated Reporting – from 4 hours down to 5 minutes
  • 🧠 AI detects anomalies and trends that a human might miss.
  • 📊 Dashboards are available in real-time via Telegram or web
  • 🔄 Universal integration - set it up once, works with all systems.
  • 📱 Control from anywhere in the world via Telegram
  • 🎯 This is a custom development tailored to your needs.
  • 📞 Free consultation on integration

Target Audience:

Director of Digital Development Chief Financial Officers (CFOs) Heads of IT departments Heads of Analytics Departments Business owners (small/medium-sized businesses) 1C integrators and implementers

Use Cases:

💡 Daily automatic export of sales to Excel
💡 Real-time stock synchronization with Ozon and Wildberries
💡 Auto-upload of bank statements from Sberbank/VTB into 1C
💡 Receiving notifications about 1C errors and failures in Telegram
💡 Import orders from marketplaces into 1C automatically
💡 Exchange of UPD (Universal Transfer Document) via Sbis/Diadoc without manual work
💡 Fiscalization of receipts through Atol/Evotor from 1C
💡 AI Analysis of Sales and Inventory with Anomaly Detection
💡 Real-time sales/financial dashboards in Telegram
💡 Accounts Receivable Control via Telegram Bot
💡 Importing supplier price lists from Excel into 1C