Easily convert data to dropdown chips in Google Sheets

What’s changing

In March, we introduced the ability to insert preset dropdown chips that are configured for common use cases like priority or review statuses in Google Sheets. Today, we’re adding a new feature that helps you quickly convert ranges of data into dropdown chips in bulk. 

If you have a column of data that includes a variety of data values (e.g., different project statuses like on track, paused, completed), Sheets will show a “Convert to dropdown chips” suggestion when you click into your data range. By hovering over that indicator, you can preview the suggestion and then convert to dropdown chips in one click. 
Easily convert data to dropdown chips in Google Sheets


Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: 
    • To insert dropdown chips on your own, type “@” followed by “dropdown
    • To turn off this feature, go to Tools > Suggestion controls > (deselect) Enable dropdown chip suggestions. 
    • Visit the Help Center to learn more about inserting smart chips in your Google Sheets.

Rollout pace 

  • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 7, 2024, with expected completion by May 30, 2024
  • Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 30, 2024 

Availability 

  • Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts 

Resources