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.

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.

Step 2: Upload the CSV file
Drag the file into the field, or click the field and choose the file.

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.

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.

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.
