Contact import. Before you upload the file.

The same guide as the one beside the Import / export screen of Mailing & SMS: the file format, the recognised column headers, size, consent and privacy, checking the result. The texts and the header list are generated from the product itself.

This page is generated at build time from apps/api/locales/en/messaging.json, packages/contracts/src/messaging/import-headers.ts in the repository.

How to prepare an import file

Format

Upload CSV (UTF-8, separated by semicolons or commas) or Excel .xlsx; .xls, PDF and Word are not supported.

You can also paste addresses: one contact per line, or CSV text.

Columns

The header row is searched in the first 15 rows; headers are recognised whatever their case and Turkish letters («E-posta», «Email», «Mail»…).

After the upload you see where each column goes and can correct it; unrecognised columns are left out.

Several e-mails in one cell separated by «/» become separate contacts; landlines are kept apart, SMS goes to mobile numbers only.

Size

There is no row limit: large files are processed in the background with the progress on screen.

If you split a file, the list name comes from the file name without chunk suffixes («-1of5», «(2)»).

The default consent is «No consent». Without a consent column, the consent you choose is your own statement; a contact's refusal is never undone by an import.

Names, e-mails, phone numbers and addresses of contacts are stored encrypted.

Check

Uploading the same e-mail or phone again updates the contact, no duplicate is made; empty cells never clear a value.

The result shows read, added, updated, skipped and invalid rows; skipped rows can be downloaded with their reason.

Recognised columns

A column whose header matches one of the headers below goes to that field by itself; case, Turkish letters and punctuation do not matter. A header that is not listed can be linked to a field in the mapping step after the upload; a column left unlinked is not imported.

Field	Recognised headers	Description
Full name	ad soyad, adı soyadı, adi soyadi, ad-soyad, isim soyisim, isim, ad, adı, kişi, kişi adı, yetkili, yetkili adı, müşteri adı, avukat, contact, contact name, full name, fullname, name	The contact's full name (stored encrypted).
First name	first name, firstname, given name, ilk ad, ön ad	Joined with the last name into the full name.
Last name	soyad, soyadı, soyisim, surname, last name, lastname, family name	Joined with the first name into the full name.
E-mail	e-posta, eposta, e posta, e-posta adresi, eposta adresi, mail, mail adresi, e-mail, email, email address, e-mail address, mail address, elektronik posta, iletişim e-posta	Several addresses separated by «/» become separate contacts.
Phone	telefon, tel, tel no, telefon no, telefon numarası, phone, phone number, telephone, numara	Stored as mobile or landline by its number.
Mobile	cep, cep telefonu, cep tel, cep no, cep telefon, gsm, gsm no, mobil, mobil telefon, mobile, mobile phone, cell, cell phone, cellphone	SMS goes to this number.
Landline	sabit, sabit telefon, sabit tel, iş telefonu, iş tel, ofis telefonu, ofis tel, büro telefonu, landline, office phone, work phone, fax	No SMS; shown on the contact card.
Company	firma, firma adı, şirket, şirket adı, büro, büro adı, kurum, kurum adı, işletme, kuruluş, company, company name, organization, organisation, business	Company, office or organisation.
Title	unvan, ünvan, görev, görevi, pozisyon, meslek, title, job title, position, role	Job title.
City	şehir, il, sehir, city, province	Without the column, the form's city is used.
District	ilçe, ilce, semt, district, county	District or neighbourhood.
Address	adres, açık adres, posta adresi, address, street, street address	Postal address (stored encrypted).
Website	web, web sitesi, web adresi, site, internet sitesi, website, web site, url, homepage	The contact's or company's site (stored encrypted).
Notes	not, notlar, açıklama, açıklamalar, yorum, notes, note, comment, comments, remarks	Free text (stored encrypted).
Tags	etiket, etiketler, tags, tag, labels, segment	Comma-separated tags.
User id	kullanıcı id, kullanici id, kullanıcı kimliği, kullanici kimligi, user id, userid, user_id, uye no, üye no	The app's own user id: links the contact to the analytics person.
E-mail consent	e-posta izni, eposta izni, e-posta onayı, email izni, email consent, e-mail consent, email opt-in, e-posta ileti izni, mail izni	Opted in, merchant, no consent or refused.
SMS consent	sms izni, sms onayı, sms consent, sms opt-in, sms ileti izni, mesaj izni	Opted in, merchant, no consent or refused.

The declaration confirmed on upload

An import does not start until this declaration about consent is confirmed:

I declare that the consents I chose are true and that these contacts agreed to receive messages on these channels (or are merchants / tradesmen); registered consents may also be checked in İYS.