---
title: Easily convert data to people chips and update chip format in Google Sheets
description: Easily convert data to people chips and update chip format in Google Sheets
---

[Suitebriar Blog ](https://blog.suitebriar.com)

# [Easily convert data to people chips and update chip format in Google Sheets](https://blog.suitebriar.com/http/workspaceupdates.googleblog.com/feeds/306193245647973203/comments/default)

 Written by [Alfonso Martinez](https://blog.suitebriar.com/author/alfonso-martinez) | Feb 6, 2025 11:10:17 PM

### What’s changing

Similar to the functionality in Google Sheets that helps you easily [convert data to dropdown chips](https://workspaceupdates.googleblog.com/2024/05/easily-convert-data-to-dropdown-chips-google-sheets.html), 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. 

<https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiQNQP_ZfplV9tPBHktaU8UF-yenitkVAMw6LqIorxv7bVBm2CdoqnIqUlSFw1ay-23ak7NpTT6jDX7rxxebBx1ZseNZ8lWjHY2QVY8Cf7z1HWcyMBDftPAytV_U_pzsEMBEmrCShU-NHJRov_S7jy7QjdJlqW2M8ACqD2WgLr4Za3HQRYSfLYINoGcq4/s1600/use%20the%20Convert%20to%20people%20chips%E2%80%9D%20suggestion.png>

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 

<https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGL-KA4tsYAv6_NzXC6Qco7ShbHsU1bVymhoAuH25OErBe2kfvIiKPQ9-xdeKaEqhVyywLrcPZJ6J9o18hB8a70DX5e-nZGjxuZi1fvWR8yMQeGwQljM92-SiEu3aVmQlKDnU-Il_o9nyea_PaJiXdckT7AK12Lk5YRHY93xqn36q0vM8idtdWF5nYQyc/s1600/update%20the%20format%20of%20your%20people%20chip.png>

### Getting started 

- **Admins:** There is no admin control for this feature. 
- **End users: **

### Rollout pace 

**People Chip Formats:** 

- [Rapid Release domains](https://support.google.com/a/answer/172177): Available now. 
- [Scheduled Release domains](https://support.google.com/a/answer/172177): Gradual rollout (up to 15 days for feature visibility) starting on February 18, 2025 

**People Chip Suggestions: **

- [Rapid Release domains](https://support.google.com/a/answer/172177): Gradual rollout (up to 15 days for feature visibility) starting on February 6, 2025 
- [Scheduled Release domains](https://support.google.com/a/answer/172177): Gradual rollout (up to 15 days for feature visibility) starting on March 3, 2025 

### Availability 

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

### Resources 

- [Google Help: Insert smart chips in your Google Sheets ](https://support.google.com/docs/answer/12319513?hl=en)
- [Google Workspace Updates Blog: Easily convert data to dropdown chips in Google Sheets](https://workspaceupdates.googleblog.com/2024/05/easily-convert-data-to-dropdown-chips-google-sheets.html)

[View full post](https://blog.suitebriar.com/http/workspaceupdates.googleblog.com/feeds/306193245647973203/comments/default)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Alfonso Martinez"
  },
  "dateModified" : "2025-02-06T23:10:17.546Z",
  "datePublished" : "2025-02-06T23:10:17Z",
  "headline" : "Easily convert data to people chips and update chip format in Google Sheets",
  "image" : {
    "@type" : "ImageObject",
    "height" : 470,
    "url" : "https://storage.googleapis.com/suitebriar-resources/workspaceupdates.png",
    "width" : 815
  },
  "mainEntityOfPage" : "https://blog.suitebriar.com/http/workspaceupdates.googleblog.com/feeds/306193245647973203/comments/default",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Suitebriar Blog"
  }
}
```