Admin | Efficiently collect data with Sheets

Collect data is very common. Traditional methods are sending emails, taking statistics in social apps groups, using Excel, etc. It isn't only time-and-labor consuming but also prone to errors. Lark Sheets help you collect and process data efficiently.

💐 Let's use T-shirt size collection as an example to demonstrate Sheets data-processing functions.

1. Create a Sheet and fill in headers

Before collecting sizes, you need to create a Sheet and fill in headers (e.g., Department, Name, Employee ID and Size).

2. Send a link to collect data

You can send the Sheet link to the group chat and change Sheet permissions from Can read to Can edit. Members in the chat can open the Sheet to easily fill in their information.

3. Members fill in the Sheet themselves

The Sheet will display each member's editing status in real-time. Members can see others' input positions and contents without worrying about "conflicting" with each other.

When all the members have filled in their information, the data will be collected automatically, easily completing data collection of T-shirt sizes.

💡Advantages of collecting data with Sheets

•Efficiently collaborate with many people to save time.

•Modify data at any time and save Sheets in real-time.

•@mention someone in Sheets to remind relevant people to fill in or edit data.

•Avoid email notifications, inefficient communication, and manually copying and pasting.

Related Articles