You probably already have a database of contacts stored on your e-commerce platform, in a marketing tool you've used in the past, or even in a simple spreadsheet. Export it and prepare the file according to the instructions below.
Your file needs at least one column with email addresses or phone numbers.
File requirements
Format: .csv (recommended), .xls or .xlsx.
Size: up to 60 MB.
CSV files: separate columns with semicolons or commas (spaces and tabs also work) and save the file in UTF-8 encoding.
XLS and XLSX files: we import only the first sheet. No column or row can be left completely blank – if one is, you'll see an error and the import will fail.
File name: don't use special characters (such as periods).
Columns you can import
When you upload the file, the import wizard asks you to match each column in your file to a field in edrone. Your column names don't have to match the names below, and you can set any column you don't need to Ignore.
Field in edrone | What to enter |
Email address. Email or Phone is required. | |
Phone | Phone number. Spaces and a country code are allowed. |
First name | Text |
Last name | Text |
Full name | Text – use it if your file doesn't have separate first and last name columns |
Gender |
|
Birth date |
|
City | Text |
State | Text |
Country | Text |
Language | Two-letter ISO 639-1 code in lowercase, e.g. |
Email subscription status | See Subscription status values below |
SMS subscription status | See Subscription status values below |
WhatsApp subscription status | See Subscription status values below |
Email subscription confirmation date |
|
Tags | Text. To assign several tags, separate them with commas. |
Subscription status values
If your file has a subscription status column, edrone reads each contact's status from it:
Value in your file | Status after import |
| Subscribers |
| Unsubscribed |
| Customers |
Empty cell | The status you choose in the wizard under Subscription status for contacts with empty cells |
⚠️ 0 does not unsubscribe a contact. A contact with 0 is imported with the Customers status. For people who unsubscribed, enter unsubscribed in the status column.
The same values work for email, SMS and WhatsApp statuses. If your file has no status column, the import wizard lets you set one status for the whole file or leave the statuses unchanged.
Sample file
You can download a sample file in the import wizard (Download sample CSV file).
A correctly prepared CSV file looks like this:
email;first_name;last_name;phone;gender;birth_date;city;country;language;email_status;sms_status;email_confirmation_date;tags anna.smith@example.com;Anna;Smith;+44 20 7946 0958;F;1990-04-12;London;United Kingdom;en;1;1;2025-03-12;vip john.brown@example.com;John;Brown;;M;1985-11-02;Manchester;United Kingdom;en;unsubscribed;unsubscribed;; maria.garcia@example.com;Maria;Garcia;;F;;Madrid;Spain;es;;;;newsletter, spring-sale
In this example Anna is imported as a Subscriber, John as Unsubscribed, and Maria gets the status you choose for empty cells.
Best practices
Put first and last names in separate columns. Then you can address customers by first name only ("Hi, Mary!") instead of the full name ("Hi, Mary Smith!").
Remove columns you won't import into your CRM (e.g. address, social security number).
Remove duplicates. Our system detects duplicate emails in the file and ignores them, but a smaller file is easier to check. If a contact is already in edrone, the import wizard asks whether to Overwrite existing contacts or Ignore duplicates.
Need more help?
If you have any questions about preparing your file for import, contact us at hello@edrone.me.





