Skip to main content

Easily convert data to people chips and update chip format in Google Sheets

By Alfonso Martinez 2 min read

What’s changing

Similar to the functionality in Google Sheets that helps you easily convert data to dropdown chips, you can now use bulk chip conversion for people chips. If you have a column of data that includes a variety of emails, Sheets will show a “Convert to people chips” suggestion when you click into your data range. By hovering over that indicator, you can preview the suggestion and then convert your data to people chips in one click. 

Convert to people chips” suggestion


In addition to the default format of display name, within the Format menu, you will now be able to update the format of your people chips to one of the following: 
  • Last name, First name 
  • Email address 
update the format of your people chips


Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: 
    • To insert people chips on your own, type “@” followed by a name or email address. To change the format of the people chips, select a cell or cells with people chips, go to Format > Smart chips > select the desired format. 
    • 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 

People Chip Formats: 

People Chip Suggestions: 

Availability 

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

Resources 

Share: LinkedIn X Email

About the author

Alfonso Martinez

Alfonso is a Google Professional Cloud Architect and Workspace Administrator at Suitebriar with over 10 years of experience in the Google ecosystem.

Talk to a Google expert about your project

Tell us what you run on today, how many people it affects and what you want to change.

  • Google Cloud Premier Partner, working only on Google Cloud and Workspace for more than a decade
  • U.S.-based support team

Free AI starter kit

From your data to your first AI agents, in four steps

Google's AI starter kit for lean teams: your four-step guide from data to agents.

  • Four steps, from a first no-code win to a multi-step agent workflow
  • Use cases with sample prompts, plus the ABCD prompting technique
  • Best practices for data quality, governance and human oversight