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

Was sich ändert

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.

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

Erste Schritte

Admins: There is no admin control for this feature.
Endverbraucher:

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.
Besuchen Sie das Hilfezentrum und erfahren Sie mehr über Einfügen von Smart Chips in Ihre Google Sheets.

Tempo der Einführung

People Chip Formats:

Rapid-Release-Bereiche: Jetzt verfügbar.
Geplante Freigabedomänen: Gradual rollout (up to 15 days for feature visibility) starting on February 18, 2025

People Chip Suggestions:

Rapid-Release-Bereiche: Gradual rollout (up to 15 days for feature visibility) starting on February 6, 2025
Geplante Freigabedomänen: Gradual rollout (up to 15 days for feature visibility) starting on March 3, 2025