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
Convert Sheets into a Base view

Convert Sheets into a Base view

1 min read
I. Intro
🔖
Platform requirement: These steps can only be performed on the desktop app.
You can convert Sheets into a Base view to better organize your data, perform analysis from different perspectives, add tags, and manage processes and tasks.
Use cases
  • Categorize data: The R&D team can convert its spreadsheet for user feedback into a base to group data into different categories, such as Bugs, Requests, and Improvements, to dive deeper into the different aspects of the project.
  • Manage projects: The project manager can convert a task management spreadsheet and use the kanban view in Base. Tasks can then be grouped by status, such as To be started, In progress, and Done, which can be updated through drag and drop.
  • Standardize formats: The marketing team can convert their customer management spreadsheet and use grid view in Base. Every column has a standard format, which means only the right data type, such as numbers, dates, options, and person, can be entered in the respective columns, keeping data organized.
Note: Only users with edit permission for the spreadsheet can convert the spreadsheet into a base.
II. Steps
  1. Open the spreadsheet. Select the area in the sheet you'd like to convert to a base view and click Menu in the upper-left corner, then Data > Convert to a base.
  1. Select a Base view you want to convert to.
Note: The base view is added as a new tab in the spreadsheet.
250px|700px|reset
III. FAQs
How many rows and columns can I transfer at a time?
2,000 rows and 40 columns.
Can data be synced between different spreadsheets?
Yes, you can sync data across spreadsheets by using data references.
What data types will keep their original format after converting to base?
Text, images in cells, attachments, checkboxes, dates, single options, multiple options, hyperlinks, @mentions, documents, and numbers in number format. Other data types will be converted to text (Example: Rich text with underline will become plain text in the base).
Written by: Lark Help Center
Updated on 2025-03-03
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom
rangeDom
rangeDom
rangeDom