For the complete documentation index, see llms.txt. Markdown versions of documentation pages are available by adding .md to their URLs.

Importing members in bulk

Last updated: October, 2026

We’ve enhanced the bulk invite feature to simplify the process of bringing members into your community. You can now upload member details using CSV or Excel files and make changes to those files directly within Circle without switching between tools. Inviting large groups is faster and more seamless than ever. 

This article will guide you through preparing your file and sending bulk invitations with ease.

About bulk imports

The bulk invite feature provides an efficient way to add new members or update access for existing members. 

You can upload a CSV or Excel file containing member information such as names, email addresses, and profile fields (including custom fields), and map the columns in your file to the corresponding fields in Circle.

The system allows you to review and resolve errors directly within the editor, making it faster to import or update your members.

Before you begin, here are some key details to keep in mind:

  • Supported file formats: You can import members using either CSV or Excel files.

  • Adding profile information: You can include profile field information in your import file to add all necessary details in a single step, ensuring your members’ profiles are fully populated.

  • Mapping columns: Easily map your file’s columns to Circle’s CRM fields for a seamless import process.

  • Error handling: Our import tool detects errors in your file and provides instant alerts, allowing you to fix issues before finalizing the import.

  • Updating data within the import file: Before finalizing your import file, you can add new rows, edit information within cells, find and replace values, and even delete rows, all within our powerful import tool.

Bulk import limit

We’ve introduced limits to the number of members that can be bulk-imported into a community to prevent abuse.

All communities on trial have a bulk import limit of 50 members/day.

For communities on a paid Circle subscription plan, there's initially a lower import limit, after which the limit is raised to 1000 members/day:

Professional:

  • 50 members/day for the first seven days of a paid subscription.

  • 1,000 members/day after seven days of paid subscription.

Business and Scale:

  • 5 members/day for the first three days of a paid subscription.

  • 1,000 members/day after three days of paid subscription.

ℹ️ Note: The daily bulk import limit resets 24 hours after the last import in the community.

Updating existing members in bulk

You can use the CSV export file from the community to perform the following actions on your existing community members:

  • Assign member tags.

  • Provide admin privileges.

  • Assign members as moderators of specific spaces or space groups.

  • Provide members with access (free access) to spaces and space groups.

  • Create a paywall trial with a custom trial duration on behalf of members.

With profile fields, the system handles updates differently based on the field type:

  • Text, long-text, link, number and location fields (e.g., headline, bio, and tMRR): The old value is replaced with the new value in the file. If the column is present but the cell is blank, the system will clear the existing value.

  • Dropdown fields: A value in the file replaces the existing selection. If the cell is blank, the existing selection stays unchanged.

  • Checkbox and picklist fields (e.g., tags): New selections will be added to the existing ones. For example, if a member already has the "Pro" tag and you reimport with a "Coach" tag, the member will now have both "Pro" and "Coach" tags assigned. A blank cell is ignored, and existing tags stay unchanged.

❗Important: Include only the columns for fields you want to change, omitting a column leaves that field untouched. For text, long-text, link, number, and location fields, a blank cell in a column you did include will clear the existing value.

When using CSV export from the community, you can modify the data as needed and use the same file to reimport members. We recommend removing columns that are not relevant for your import.

Preparing the import file

To ensure a successful import, it’s important to prepare your file with accurate data, particularly for email addresses. Your import file can contain the following details for each member:

  • Name

  • Email address

  • Tags

  • Profile fields, including headline and other custom profile fields

Here are some helpful tips:

  • A name and email address are required for each member, so ensure these fields are populated for every entry.

  • The header columns don’t need to match the names of profile fields in Circle; you can easily remap them during the import process.

  • When using a CSV file, fields that support multiple values, such as tags or checklist-type fields, enclose the values in double quotes and separate them with commas, without spaces after the commas (e.g., "tag1,tag2").

  • When using an Excel file, for fields that support multiple values, such as tags or checklist-type fields, separate the values with commas, without spaces after the commas (e.g., tag1, tag2).

  • If your file contains errors or if you’d like to change the data in it, you can easily do this when you upload it directly to Circle.

Download a template

If you’re starting from scratch, you can download an Excel template that includes all the necessary columns, including your community’s profile fields. Here’s how to access it:

  1. Click Audience in the left sidebar, then select Audience.

  2. Click Add in the top-right corner and select Invite members.

  3. Under How do you want to invite members? section, select Import CSV.

  4. Click Import CSV.

  5. Click Download Excel template in the bottom left corner.

  6. Exit the import process by closing the upload screen and clicking the X icon in the top-right corner of the screen. Then open the template to add your member information.

Use an existing file

If you already have a file prepared, you can proceed directly to the import process. The tool allows you to map your file’s columns to Circle’s CRM fields and remove any unnecessary columns before finalizing the import, ensuring a seamless integration of your data.

Utilize the bulk import tool

Once your file is ready:

  1. Click Audience in the left sidebar, then select Audience.

  2. Click Add in the top-right corner and select Invite members.

  3. Under How do you want to invite members? section, select Import CSV.

  4. Click Import CSV.

Upload the import file

  1. Click Upload file in the top-left corner. Alternatively, you can drag and drop your file on the screen or click anywhere inside the dotted border to open the file uploader and select your file.

  2. Pick the row in your data that contains the column headers. This helps the import tool understand and map your columns correctly. When using a template, the header row will be automatically selected.

  1. Review uploaded columns with the template columns. See the Map columns section below for more details.❗️Important: Your column mapping will be saved after you move to the next step. You won’t be able to undo these changes without exiting and starting over with a new file upload.

  1. Review and finalize the data. In this step, you can map columns, add more rows, find and replace values, and export the updated version. For more information, see the following sub-sections within this section.

  2. Once you’ve reviewed and made all necessary changes, click Upload file.

Let’s explore the following sub-sections for additional details on what you can accomplish during the Review & finalize step.

Manually update information

You can click cells to manually enter information for a member.

For list, dropdown, or checkbox type fields, double click the cell or start typing to open the list with available values you can choose from.

You can also add new rows to your uploaded files to manually enter new members. To do so, simply click Add a row at the top.

Map columns

Once uploaded, you can match your file’s columns to the appropriate fields in Circle’s CRM. This ensures that member details, such as names, emails, tags, and profile fields, are properly aligned.

There are several ways you will be able to map columns:

  • After uploading a file: When you upload a file, the system will analyze its data and prompt you to map columns in the next step if needed.

  • During the review & finalize step: If you’re already in the Review & finalize step, you can access the mapping interface by clicking the Map columns button at the top of the screen.

ℹ️ Note: If all your fields were correctly mapped and confirmed earlier in the process, this button may not appear.

  • Remapping via column headers: At any point in the Review & finalize step, you can remap a specific column by clicking the dropdown arrow next to the column header and selecting Remap this column.

Here’s how the mapping process works:

  • Mapping feature interface: The screen displays all your uploaded columns, sample data, and template columns, showing mapped CRM fields.

  • Automatic mapping: If a column name in your file matches Circle’s CRM field, it will be mapped automatically in the template columns.

  • Unmapped columns: Columns that the system doesn’t recognize will be labeled as "Unmapped." You can manually map these by selecting a CRM field from the dropdown menu under the template column.

    • ℹ️ Note: If any columns remain unmapped when you finalize the mapping, they will be excluded from the final file. This also includes columns that are completely empty. You will see the “This column is empty and will not be imported” message for the column.

  • Removing unnecessary columns: You can remove unnecessary columns that you don’t want to import. To do so, click the Delete icon next to the column.

  • Mapping suggestions: To help you with mappings, you may see an automated Suggest mappings option at the top when the system has suggestions. If selected, the system will automatically analyze columns and attempt to pair them with the appropriate template columns. We recommend reviewing the suggested mappings for accuracy before proceeding with the upload.

  • Handling picklist values: If the system identifies mapped fields with picklist values (such as dropdowns or checklist-type fields) that are either empty or contain unrecognized values, you will see the Edit values option. You can select "Suggest replacements" to let the system propose valid values for these fields, or manually choose the appropriate values from the provided "Valid values" dropdown menu. Once you’ve reviewed and adjusted the mappings and values, click Done.

Use column actions

During the Review & finalize step, you can manage your data at the column level using the Column actions feature. This allows you to perform bulk actions on a specific column to efficiently clean or adjust your data.

To access the column actions, click the dropdown arrow next to a column header. A dropdown menu will appear with the following options:

  • Fix all formatting errors: If any cell has a formatting error, you will see this option in the menu. This action automatically corrects fixable formatting issues across all rows in the column by applying valid replacements. We recommend reviewing the changes after using this option to ensure accuracy.

  • Delete all invalid values: Clears all invalid entries in the column, leaving those cells blank. This helps remove incorrect data without deleting entire rows. If the column requires a value (e.g., an email field), a new “Suggested transform" section will appear, allowing you to fill the empty cells with values from another column.

  • Fill empty cells with a value: Lets you specify a default value to fill all empty cells in the column, ensuring no cells are left blank.

  • Remap this column: Redirects you to the column mapping, where you can reassign the column to a different CRM field. This is helpful if the column’s data type doesn’t match the current mapping.

  • Delete all rows with errors: Use this option to remove all rows with issues, ensuring only clean data is imported. Use this cautiously, as it deletes the problematic rows. If you need to take a different action, you’ll have to exit the import process and re-upload the file.

Fix issues

During the Review & Finalize step, the system automatically identifies and highlights any issues in your dataset that must be resolved before the import can be completed successfully. This ensures your data is clean and compatible with the CRM.

At the top of the screen, you’ll see tabs displaying the total number of rows, clean rows, and rows with issues. You can switch between these tabs to view your data organized accordingly.

Managing all issues

When errors are detected, a right sidebar will appear, listing All issues. Here’s how you can address them:

  • Automated error fix: If the system can automatically resolve specific errors (e.g., formatting issues), you’ll see a fix error option below the particular issue. Additionally, a Fix all option at the top of the sidebar allows you to correct all fixable errors in one go. We recommend reviewing the changes after using this option to ensure accuracy.

  • Navigate to cells: In the issue listing, click the cell value to jump directly to the affected cell. Then, you can click the cell value again to view the error prompt.

  • Delete all rows with errors: Using this option, you can remove all rows containing issues, ensuring only clean data is imported. Use this cautiously, as it deletes the problematic rows. If you need to take a different action, you’ll have to exit the import process and re-upload the file.

💡 Tip: To collapse the All issues sidebar, click the Collapse icon located at the top right of the sidebar. Once collapsed, a floating error icon will appear at the top right of the screen, which you can click to expand the All issues sidebar again.

Resolving errors

On the main screen, clicking a cell with an issue opens an error prompt with options tailored to the error type. For example:

  • If a URL is invalid, you can manually correct it by entering a valid link.

  • If a value in a picklist field is invalid, you can select a valid option from a dropdown menu to replace it. You can then choose to replace the selected cell (use the Replace cell option) or all cells with identical errors within the column (use the Replace all similar cells option).

Using the different action dropdown

The error prompt includes a Use a different action dropdown menu, offering additional ways to handle issues at the column level:

  • Fix all formatting errors: Automatically corrects fixable formatting issues across all rows in the selected column by applying valid replacements. We recommend reviewing the changes after using this option to ensure accuracy.

  • Delete all invalid values: Clears all invalid entries in the column, leaving those cells blank. This helps remove incorrect data without deleting entire rows. If the column requires a value (e.g., an email field), a new “Suggested transform" section will appear, allowing you to fill the empty cells with values from another column in the same row.

  • Fill empty cells with a value: Lets you specify a default value to fill all empty cells in the column, ensuring no cells are left blank.

  • Remap this column: Takes you back to the column-mapping step, where you can reassign it to a different CRM field. This can resolve errors caused by data type mismatches.

  • Delete rows with errors: Removes all rows with errors in the selected column, ensuring only clean data is imported. Use this option with caution, as it deletes the affected rows from the uploaded file. If you need to take a different action, you’ll need to exit the import process and re-upload the file.

Find and replace data

The find and replace feature allows you to search for specific values in your imported data and replace them with new values across selected columns.

Here’s how you can use this feature:

  1. Access the feature: In the Review & finalize step, click Find and replace at the top.

  2. Select the scope: You can choose which columns to apply the find and replace action to by selecting from the dropdown menu labeled "All columns." This allows you to target specific columns (e.g., name, headline) or apply changes across all columns.

  3. Define the find criteria:

    • Enter a value: Input a specific value you want to search for in the Enter a value field. Alternatively, you can select the All empty cells option to target all cells within your defined scope that are blank.

    • Case sensitivity: You can refine your search by checking the Case-sensitive box to differentiate between uppercase and lowercase letters.

    • Exact match: Check the Exactly match the entire cell box to ensure the search only matches cells with the exact value you entered, not partial matches.

    • See the number of matches: You will see if there are any matches found based on your criteria.

  4. Define the replace action: In the Replace with section, enter the new value with which you want to replace the found values. For example, you could replace all instances of blank text-type field cells with “N/A” or a standardized value like "Not Provided."

  5. Execute the replacement: Once you’ve set your criteria, click Replace all to apply changes across the selected columns.

Export reviewed data

You can save your imported data after reviewing or editing it. To do so, click Export and choose from three export options:

  • Export all rows to Excel: Downloads the entire dataset, including all rows, as an Excel file.

  • Export error rows to Excel: Downloads only the rows with issues (if any) as an Excel file, helping you focus on problematic data.

  • Export all rows to CSV: Downloads the entire dataset, including all rows, as a CSV file.

Complete and send the import

Once you’ve finalized and uploaded your file, you’ll be directed back to the details tab of the invite member page to continue setting up the import. This includes setting up tags, access, permissions, invitation email, and paywall trial.

Please note that the rest of the invite setup will apply to all members included in the import file.

📚 For a detailed guide on inviting members and filling out all the information, please refer to Invite members to your community.