AI Assistant
Help Center AI Assistant is now available
Got questions about Lark? Use our AI chat to find the answers.
00:00
Click and hold to drag
Got It
Try Now
Copy and paste from spreadsheets to add members in bulk

Copy and paste from spreadsheets to add members in bulk

2 min read
I. Intro
🔖
Version requirement: Lark version 6.4 or above.
When you create a group, event, or compose an email, you can copy multiple member names or email addresses from Lark or Excel spreadsheets and paste them into the search box. Lark will then add these members to your group, event, or email.
II. Steps
In a group chat
When creating or after creating a group chat, you can efficiently add multiple members in batches by copying their information from a spreadsheet or manually entering the information.
  1. Copy the names or email addresses of multiple members from a spreadsheet (make sure to copy the full email address with the suffix).
  • Note: When copying names or email addresses from a spreadsheet, ensure that each cell contains only one name or email address. Multiple entries in a single cell will lead to recognition errors.
  1. Paste the copied content into the group chat member search box. You can also manually enter member information, separating each entry with a semicolon (;). The system will automatically identify the members for quick selection.
  • When creating a group chat: On the Lark desktop app, click the + icon below or on the right side of your profile photo, select New Group, and paste or enter member information in the group chat member search box.
  • After creating a group chat: Click the Add members icon in the upper-right corner of the chat, and paste or enter member information in the group chat member search box.
  • Note:
  • The minimum version required to batch add members by manually entering information is Lark V7.39 or above.
  • If the copied content includes members with identical names within the organization, you will need to manually select the correct individuals to add. Members who are already part of the group chat will not be selectable.
  1. After selection, click Create or Confirm.
250px|700px|reset
250px|700px|reset
When creating an event
When creating an event, click Batch add. Copy members' names or email addresses (make sure to copy the full email address with the suffix) from a spreadsheet and paste them into the search bar.
250px|700px|reset
When sending an email
Click Compose and then copy email addresses from a spreadsheet and paste them into the search bar.
250px|700px|reset
III. FAQs
Is this feature available on the mobile app?
No.
If I copy and paste external contacts, will Lark recognize and select those names?
No, it will not.
If I manually enter multiple members, will Lark recognize and select them?
Yes. You can manually enter multiple member names or email addresses, separating each entry with a semicolon (;).
How many members can I copy and paste at a time?
You can paste up to 200 members at a time.
Written by: Lark Help Center
Updated on 2025-04-01
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom