The first 100: €99/month (US$99) excl. VAT, half price for as long as you stay.Build free

The first 100: €99/month, half price

People

Import contacts from a CSV

Bring in a list you already have with a CSV file: which columns are read, what happens to duplicates and how to read the result.

Updated November 2026

If your list is in a spreadsheet, in Mailchimp, in Kit or in Kajabi, you bring it in with a CSV file. You don’t have to match up any fields, Idun Blue reads the column headers.

To move purchases or course progress from another platform, use Settings → Move here instead. See Move over from another platform.

The columns that are read

Only the email column is required:

ColumnRequiredWhat it does
emailYesThe key. Rows without a valid address are skipped.
nameNoFull name.
first_name + last_nameNoUsed when name is missing, and joined into one name.
tagsNoSeveral tags in one cell, separated by commas or semicolons.

The email column is recognised under several names, such as Email, Mailchimp’s Email Address and the Swedish E-post. Headers are read regardless of capitals, and first name and firstname work as well as first_name. Names and tags are only read from columns called name and tags, so rename them if your file calls them something else.

If the file has a subscription-status column, as exports from Kajabi and Mailchimp do, that’s read too. Anyone who opted out of email stays unsubscribed.

The file can be up to 10 MB and 10,000 rows. If you have more, split it.

Semicolon or comma?

Both work. Excel in many European languages saves with semicolons, and Idun Blue works out from the header row which one you used.

Example

email,name,tags
[email protected],Anna Svensson,"vip, yoga"
[email protected],Erik Johansson,newsletter
[email protected],Maria Nilsson,

Save it as UTF-8, or accented letters turn into question marks. In Excel the format is called “CSV UTF-8”.

Run the import

  1. Go to People and click Import at the top right. If the list is empty, the button says Import contacts.
  2. Drag the file in, or click to choose it.
  3. You’ll see the first rows and three markers: email, name and tags. Green means the column was found. If no email column is found you’re told straight away, and you need to fix the header row.
  4. Add a tag in Extra tag (optional) if you like. Everyone in the file gets it on top of their own tags. A tag like import-2026-11 or from-mailchimp lets you find the group again.
  5. Answer Do these people get your emails? The default is No, or I am not sure: they’re added to People but get no newsletters until they sign up themselves. Choose Yes, everyone has agreed to my emails only if you can show their consent, for example for a list from your previous newsletter tool. Anyone who has unsubscribed, in the file or before, never gets your emails.
  6. Click Import.

What happens to duplicates

The email address is the key. If it already exists, no new contact is created and the existing one is updated:

  • The name is overwritten if the file has a name on that row.
  • Tags are merged. Old tags stay.
  • Subscription status only moves one way. An import can unsubscribe someone but never re-subscribe a person who opted out, so nobody who said no ends up back on your list because you uploaded an old file.

Read the result

When the import finishes you see four numbers:

  • Imported: new contacts.
  • Updated: addresses that already existed.
  • Skipped: empty or invalid addresses.
  • Errors: rows that couldn’t be read, with row numbers so you can find them in the file.

It also tells you how many of them get your emails.

Afterwards

Filter on the import tag in People and check that the names look right. Question marks in place of accented letters mean the file isn’t saved as UTF-8. Save it again and re-import. That doesn’t create duplicates.

To let the imported people know they’re here now, send a broadcast to the import tag. It only reaches people who get your emails, so only if you answered yes at import. See Send broadcasts.

If something goes wrong

  • “The file has no email column”: the header row isn’t the first row in the file, or the column has a name Idun doesn’t recognise. Rename it to email.
  • Odd characters: the file isn’t saved as UTF-8.
  • Lots skipped: look for spaces inside addresses, or rows without an @.

Tips

  • Try ten rows first. If it looks right, run the whole file.
  • Remove addresses that have bounced for a long time before you import. Email to addresses that don’t exist can send more of your email to spam.
Was this guide helpful?

Next guide

Where form responses land