Skip to main content

How to prepare a file to import?

Written by Klaudia Lewandowska

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

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

M (male), F (female), OTHER, UNKNOWN, REFUSED

Birth date

YYYY-MM-DD

City

Text

State

Text

Country

Text

Language

Two-letter ISO 639-1 code in lowercase, e.g. en

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

YYYY-MM-DD

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

1, yes, true, subscribed

Subscribers

unsubscribed, opt-out

Unsubscribed

0, no, false or any other value

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.

Did this answer your question?