Import members from a spreadsheet

Get the file

In your community, open Settings, then Import. Beside A list of members (spreadsheet), press Choose a file.

Pick where your members are now: Kajabi, Mighty Networks, Circle, Skool or Facebook group. Each one shows the steps to download your members there, what comes along, and what stays behind.

Then drop the file in the box, or press Choose a file. A CSV works, and so does an Excel .xlsx file, like the one Mighty Networks sends. Starting from scratch? When nothing else is found on your site, Import offers Download our sample.

Match the columns

Add members from a spreadsheet shows each column in your file, its first row, and what it becomes. Import guesses from the column names; change anything that’s wrong. A column can become:

• Email (needed)
• First name, Last name or Full name
• Joined date
• Membership, to match a plan to a membership here
• Bio, Location, and Photo (a web address)
• Don’t bring, for anything you want left out

When every guess looks right, it says Columns matched for you. Press Check first.

Check and add

Before anyone is added is a dry run: nothing has changed yet. It shows who’s new, who’s already here, emails that are in the file twice, and rows that can’t come. If you matched a membership column, choose a membership for each plan in your file, or No membership.

Under Letting them know, choose one:

Then press Add members (the button shows how many). Members can use the community while it runs.

Questions