How to import members from a CSV file

Import your association's whole member list into Unioo from a CSV file in a few minutes.

Written by Oliver K
Last updated 2025-12-11
On this page

If you keep your members in a spreadsheet, you can move them to Unioo in one go. Save the list as a CSV file, upload it, and tell Unioo which columns are name, email and so on. The members are created without receiving an email, so you decide when they should be invited.

Animation showing a member import from upload to review

What the file must contain

The file must have at least one column with the name and one with the email. You can also have columns with:

  • Member no., first name and last name
  • Date of birth, address, postal code and city
  • Phone no., note and your own custom fields

Tip: In Excel and Google Sheets, choose Save as or Download, and choose the CSV format.

Import members step by step

Step 1: Choose Import from a file

Go to Members, click + Create member, and choose Import from a file.

The How do you want to add members dialog with Import from a file highlighted

Step 2: Upload the CSV file

Drag the file into the field, or click the field and choose the file.

The Upload CSV file step with the file field highlighted

Step 3: Check the format and choose columns

Under File format you choose the separator and encoding. If names with æ, ø and å look wrong, change the Encoding, for example from Latin1 to UTF-8. Then choose which field each column should be saved in. Email must always be chosen.

The Fill in the header row step with separator, encoding and a field for each column

Step 4: Review the members

Unioo shows the rows with errors in red. If it is the header row or an empty row, you can ignore it. If it is a real member, correct the file and upload it again. Click Create valid members.

The Review the members step with errors highlighted and the Create valid members button

Step 5: Resolve conflicts

If a member already exists with the same email, you can choose what should happen in the last step.

When the members have been imported

The new members have the status Internal and have not received any email. Select them in the list, click Actions, and choose Add membership. Only then are they invited.

The member list with two selected members and the Actions menu open