How do I format my spreadsheet for importing members?

⚠️ Just a heads up: 

The key to a successful import is formatting your spreadsheet properly! If you have our regular Flocknote subscription, please be sure to check out the first part of this guide -- we promise it's super simple. If you also have Flocknote People (our optional add-on subscription) enabled, make sure to look through the second half of this guide for added info on importing those custom fields you've set up (address, birthday, gender, etc.). 

To import members with Flocknote: 

You'll need either a .csv or .xls file, and the only columns that should be on the spreadsheet include: 

  • Name (you can either have a separate column for first and last name, or you can keep full names in one column)
  • Email address...
  •  ...and/or phone number. 

Easy peasy!

Please note: Each member can only be imported with one unique phone number and/or one unique email address. This means that two members cannot be added with the same phone number/email address. Also, there cannot be several columns for "Phone Number 1" and "Phone Number 2". If you need to add members that have multiple phone numbers, for instance, you'll want to enter them as two separate line items as if they are two separate members -- this will count as 2 additions to your total member count. 

If you do not have any contact info for the member, you can still import them and they will still count as a member with just their name. 

To import members with Flocknote People:

First, you'll want to be sure that you've set up custom profile fields for your groups. Click HERE to learn how to set those up. Then, you'll need either a .csv or .xls file, and the only columns that should be on the spreadsheet include: 

  • Name (you can either have a separate column for first and last name, or you can keep full names in one column)
  • Email address...
  • ...and/or phone number
  • Plus any additional information (like birthday, date of baptism, occupation, t-shirt size, coffee order, mailing address...the sky is the limit!) you'd like to track using custom profile fields, each in a separate column

As always, you can email your friendly Happiness Engineers at help@flocknote.com if you'd like us to take a peek at your spreadsheet and make sure everything looks A-OK before importing. 

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us