Insert smart chips in your Google Sheets

Insert smart chips in your Google Sheets to include information about: 

  • Users with Gmail or Google Workspace email addresses
  • Other Google Docs, Sheets, or Slides files

With a smart chip in your spreadsheet, you can hover on or click a chip for more information.

Add smart chips for people & files

Important: When you @mention a user in a smart chip, they don't automatically get access to your document. To let another user get access, share your document.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Enter "@".
  3. To narrow your options, select from the pop-up list or enter:
    • Letters
    • Numbers
    • Symbols
  4. To add: 
    • People smart chip: Enter a name or email.
    • File smart chip: Enter the file name or related keywords.
    • Event smart chip: Enter the calendar event name or related keywords.
  5. To view information, hover your mouse over the chip.

Convert emails to people chips in Google Sheets

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a range of cells with email addresses. 
  3. At the top, click Insert And then Smart chip And then People
  4. You can also convert an email address to a people chip:
    1. Right-click on a cell.
    2. Click Convert to people chip.

Tips:

  1. Cells don’t convert if:
    • They’re not formatted as email addresses.
    • They have invalid email addresses.
  2. You can make format changes to people chips, such as:
    • Color
    • Size
    • Font style
  3. To remove format changes, click Clear formatting.
  4. To remove a people chip and revert the cell to an email address, right-click on a cell, click View more cell actions And then Remove smart chip.

Convert links to file chips in Google Sheets

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a range of cells with links.
  3. Point to the preview.
  4. At the bottom of the file preview, click Convert to file chip.

Tips:

  • You can make format changes to file chips such as: 
    • Color
    • Size 
    • Font style
  • To remove formatting, click Clear formatting.
  • To convert links to File Chips, select an option:
    • Right-click a cell or group of cells , then click Convert to chip
    • Click  Insert And then Smart chips.
Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
true
true
35
false
false