Importing members
Upload a spreadsheet to add your whole member list at once. It’s the quickest way to move over from another tool, a shared spreadsheet or a paper list. Somiti shows you a preview first, so nothing is added until you’ve checked it.
To add one person at a time, see Members.
Get your file ready
Click Members in the sidebar, then Import at the top of the page. The top of the import page shows the columns Somiti reads, with an example, and a Download template CSV link. The upload form is below it.
- Click to pick your file, or drag it here.
- Choose whether to email each new member a portal invitation.
- Preview Import checks the file before anything is added.
- Click Download template CSV to get a file named
somiti-import-template.csvwith the right headers. - Open it in Excel, Google Sheets or Numbers and add one member per row.
- Save it as a CSV file. In Excel, choose File > Save As and pick CSV UTF-8.
The first row must be the column headers. Somiti reads these columns:
| Column | Required | What to put in it | If you leave it blank |
|---|---|---|---|
name |
Yes | Their full name | “Imported User” |
email |
Yes | Their email address | The row is skipped |
phone |
No | Any format | Left empty |
role |
No | member, manager, admin or guest |
member |
status |
No | active, inactive or suspended |
inactive |
bio |
No | A short note about them | Left empty |
Anything Somiti doesn’t recognize in role becomes member, and anything it doesn’t recognize in status becomes inactive. Emails are saved in lowercase. The file has to be UTF-8 encoded and no bigger than 10MB.
Import your file
- On the import page, click Click to browse and pick your CSV, or drag the file onto the box.
- Check Send portal invitation if you want each new member to get an email with a link to set up their account. Leave it unchecked to add them quietly and invite them later.
- Click Preview Import.
- Check the preview (see below).
- Click Import with the number of members, for example Import 48 Members.
You’ll come back to the import page with a message like “Successfully imported 48 members.” If some rows didn’t make it, the message says how many were imported, how many had errors and how many were skipped.
Note: Imported members start as Inactive unless the file says otherwise, so put
activein thestatuscolumn for anyone who’s current. The Activate imported members immediately checkbox doesn’t carry through the preview step yet, so don’t rely on it. You can also activate people afterwards: search for them on the member list, check the boxes and click Activate. See Members.
Importing adds people to your member list but doesn’t give them a tier. To put them on a tier, give each one a membership. See Memberships.
Read the preview
The preview page has three counts across the top:
- Ready: rows that will be added.
- Duplicates: rows that will be skipped because the email is already in your community, or appears twice in the file.
- Errors: rows that will be skipped because they have no email.
Below the counts, Somiti lists each problem by row number, so you can find it in your spreadsheet. It also warns you about rows with no name; those people are added as “Imported User” and you can rename them later.
If the preview isn’t right, click ← Back, fix your file and upload it again. Nothing has been added yet.
Import a large file
Files over 1MB skip the preview and import in the background, so you can keep working. You’ll go straight back to the member list, where a yellow banner says “Import in progress”. When it finishes, the banner shows how many members were imported, and Somiti sends you a notification with the results.
Handle duplicates
Somiti matches people by email address. If an email is already in your community, that row is skipped and the existing member isn’t changed. That means you can fix a file and import it again without creating doubles: the rows that already went in are skipped the second time.
To update someone who’s already on your list, open their profile and click Edit. See Members.
Fix import errors
| Message | What to do |
|---|---|
| “Missing email” in the preview | Add an email address to that row |
| An error page right after Preview Import | The file isn’t a valid CSV. Open it in a text editor and look for stray quote marks or broken lines, then save it as CSV UTF-8, not as an Excel workbook |
| “Invalid CSV format” or “Invalid file encoding” in the import notification | Same fix, for files over 1MB that imported in the background |
| “File is too large (max 10MB)” | Split the file into smaller ones and import them one at a time |
| “File is empty” | The file has no rows. Check you saved the right file |
| “Upload session expired” | Somiti no longer has the file from your preview. Upload it again |
Related docs
- Members: Find, edit and update the people you’ve imported.
- Memberships: Put members on a tier after importing them.
- Getting started: The rest of the setup checklist.