Preparing your file

  • Use a .csv or .xlsx file of no more than 15 MB. If your file is larger, split it into multiple files and import them one after another.
  • Put the column names in the first row, with one contact per row below that.
  • A column with email addresses is required. Rows without a valid email address will be skipped.
  • You don't need to remove duplicate addresses yourself: if an address appears more than once in your file, the last row wins.
  • Use the format YYYY-MM-DD or DD-MM-YYYY for dates (optionally followed by a time). Other formats, such as 11/16/2026, won't be recognized in filter rules.
  • Remove unsubscribed, bounced, and spam-reported addresses from your file and import them separately as blocked contacts (see Unsubscribes and consent).

Importing a file

  1. Go to All contacts in the left menu. If you want to add the contacts to a static segment right away, open that segment first.
  2. Click Add contacts in the top right and choose Upload contacts.
  3. Drag your file into the window, or click to select a file.
  4. If your Excel file has multiple tabs, select the correct sheet under Worksheet.
  5. Map the columns to fields (see below) and uncheck any columns you don't want to import.
  6. Click Import [number] contacts.

You'll see the message The import has started. The import runs in the background: you can track progress in the sidebar, and the contacts list refreshes automatically. When it's done, the sidebar shows how many contacts were imported. You can keep working in the meantime.

Mapping columns to fields

For each column in your file, you'll see a sample value (Example value) and a dropdown under Map to.

  • For common column names, Xendy will already suggest a field, such as Email, First name, and Last name, or a column with the same name as an existing field. It's worth double-checking these.
  • Map the column containing email addresses to your email field. If that mapping is missing, you'll see a warning — without an email address, Xendy can't import a row.
  • Under Available fields, you'll find your existing contact fields. If a field isn't listed, choose Add field, enter a Field name (at least 3 characters: letters, numbers, - and _), and click Create. Xendy stores the name in lowercase; characters other than letters, numbers, and underscores — such as a hyphen — will be removed.
  • Columns without a mapped field are skipped. Use the checkbox at the top of the list to enable or disable all columns at once.

New fields get the type Text (default). If you want to filter by a date or number, change the type under Settings > Manage database. See Managing the contact database.

Existing contacts and duplicate addresses

Xendy identifies a contact by their email address; capitalization and leading or trailing spaces don't matter.

  • Is the address already in Xendy? Then the import updates that contact: values from mapped columns overwrite the existing values. An empty cell leaves an existing value unchanged.
  • Does the address appear more than once in your file? Then the last row wins.
  • Status doesn't change. A contact who is already unsubscribed or blocked stays that way after an import. An import never re-subscribes anyone.

Importing into a static segment

If you start the import from a static segment, all contacts in the file will be added to that segment — including contacts that were already in Xendy. This is a great way to bring over lists from your old tool: create a segment for each list (Segments > New segment > Manual) and import the file into it.

Note: if the segment has an active email automation that sends immediately, every active contact newly added to the segment will receive that email right away. Contacts who were already in the segment won't receive it again.

You can't import into a dynamic segment — those are populated through filter rules.

Contact limit

Only active contacts count toward your contact limit; blocked contacts do not.

  • If you're already over your limit and we don't automatically upgrade your subscription, you won't be able to import contacts. You'll see Contact limit reached: you have two ways to block contacts (by pasting email addresses or by uploading a file), or you can upgrade your subscription. Blocking contacts is always possible, even if you're over your limit.
  • When uploading a file to block contacts, you'll see the message: "Choose the column containing email addresses. Addresses not yet in Xendy will be set to blocked immediately; they don't count toward your limit."
  • With a Pro subscription, the import window shows a warning if you're likely to exceed your limit after the import. If Automatic scaling is enabled, we'll upgrade your subscription automatically. If it's disabled, sending of campaigns and automations will pause until you upgrade your subscription.

You can read more about this in Subscription, trial period and payment.

Where can you find the imported data?

  • In the All contacts list, and in the segment if you imported into one. The list shows fixed columns; your custom fields are visible per contact.
  • Click a contact: the side panel shows their email and name, and the button showing the number of additional fields (for example 3 more) reveals the Extra fields.
  • Under Settings > Manage database > Contact fields, you'll find all your fields, including new ones.
  • In the filter rules of a dynamic segment (under Contact data) and as personalization in your emails: type @ in the email editor.

Frequently asked questions

A .csv or .xlsx file of no more than 15 MB. If the upload fails, you'll see File upload failed. Split a large file into smaller files and import them one after another.

Rows without a valid email address are skipped, duplicate addresses count once, and contacts already in Xendy are updated rather than added again. The number on the Import [number] contacts button reflects the number of rows in your file; the sidebar shows how many contacts were actually imported (new and updated combined) once it's done.

Yes. Under Add contacts, choose Paste a list of email addresses. Paste your addresses, one per line or separated by commas, semicolons, or tabs (a column from Excel works too), and click Add. You can paste up to 50,000 addresses at a time. You'll immediately see how many addresses will be imported and how many lines were skipped due to an invalid email address.

No, unless you're importing into a static segment with an active email automation that sends immediately. In that case, every new contact added to that segment will receive that email.

Yes. Create a file with the email addresses and a column with the value, import it via All contacts, and map that column to the field. The existing contacts will be updated; their status won't change. For a smaller group, you can also use Set field; see Managing contacts.

There's no button to undo an import. If you want to remove the new contacts, go to All contacts, filter by Created on (for example Today), and verify that only the imported contacts appear in the list. Select them (if they span more than one page, use the Select all … found contacts link) and click Delete [number] contact(s). If you've selected all found contacts, you'll need to type the number to confirm. Values that the import overwrote on existing contacts can't be restored this way.

Follow the migration guide for your old tool: ActiveCampaign, Brevo, Klaviyo, Mailblue, or Mailchimp. Prefer to do it together? Schedule a free appointment and we'll migrate your contacts with you.

Joeri Ras

Written by

Joeri Ras

Founder & co-owner @ Xendy

Prefer to talk directly?

Related articles