Sheets24

Need to import contacts or deals in an Excel file into Bitrix24, export the CRM to Excel, or keep a Google spreadsheet in sync with your CRM? Sheets24 does all three: import with a preview and duplicate check, export with readable values, and live or two-way Google Sheets sync.

What you can do with it

• import contacts, companies, leads, deals or products with an Excel (.xlsx) or CSV file;
  
• check for duplicates by email, phone, ID or a custom field before anything is written;
  
• bulk edit CRM items in a spreadsheet and bring the changes back by ID;
  
• export leads, deals, contacts, companies and SPAs to Excel with readable values;
  
• keep a Google spreadsheet in sync with the CRM in real time (Pro);
  
• run two-way Google Sheets sync with a conflict rule (Pro);
  
• build reports in Google Sheets or Looker Studio on live CRM data;
  
• move data into Bitrix24 out of another system through a spreadsheet.
  

Excel import with preview

• Upload .xlsx or .csv (any separator and encoding). Columns are mapped to CRM fields automatically; adjust if needed.
  
• See before you write: which rows will be created, changed, skipped as duplicates, and which have errors — with the exact reason ("Responsible person: no active employee 'Max Mustermann'", "not an email", "not in the list").
  
• Find duplicates by ID, email, phone or a custom field (PO number, SKU, external ID). Bulk writing, report in .xlsx.
  
• Existing phone numbers and emails are kept — new ones are added.
  

Excel export

• Export to .xlsx or CSV with the fields you choose, including custom fields and a filter by pipeline, stage, responsible person and dates.
  
• Readable values, not codes: stage and pipeline names, employee names, list values, multiple values, dates as real dates, money with currency in a separate column.
  

Google Sheets sync

• Create a Google spreadsheet of any CRM list in one click.
  
• Real-time sync (Pro): when a deal or contact changes in the CRM, its row follows within seconds; new items are added, deleted ones are removed from the sheet.
  
• Import of a sheet: rows create and change CRM items by ID, email, phone or any field you choose.
  
• Two-way sync (Pro) on a schedule with a conflict rule: "latest change wins", "CRM wins" or "sheet wins". New rows in the sheet become CRM items and get their ID.
  
• Sheets24 can open only the spreadsheets it creates or that you pick — not the rest of your Google Drive.
  

Every field type: lists, multiple fields, dates, money with currency, employees by name, stages by name, yes/no, links to companies and contacts. Built for volume: 50,000 items in one export using bulk requests; Google quotas are respected automatically.

Interface in English, German and Polish. Hosted in the EU (Germany), GDPR data processing terms are part of our Privacy Policy.

Why Sheets24

• Three tools in one. Excel and CSV export, Excel import with a preview and live Google Sheets sync.
  
• See before you write. Created, changed, skipped and error rows with the exact reason.
  
• Every field type, readable values. Not codes.
  
• Not your whole Google Drive. Only the spreadsheets it creates or that you pick.