Insert smart chips into your Google Sheets

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

• Users with Gmail or Google Workspace email addresses
• Other Google Docs, Sheets or Slides files
• Google Calendar events
• Places and map directions
• Google Finance entities
• YouTube videos
• Ratings

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

Add smart chips

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 a:
   • 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.
   • Place smart chip: Enter a place, address or location.
   • Finance smart chip: Enter the name of the Google Finance entities, like stocks, mutual funds or currencies.
   • Rating chip: Enter 'Rating' and click on the chip to select a zero- to five-star rating from drop-downs.
5. To view the information, hover over the smart chip.

Tip: You can insert chips of different types together with text in one cell. Currently, calculation reference to cells with multiple chips is not supported.

Use '@' to insert dates more easily

1. On your computer, open a spreadsheet in Google Sheets.
2. To insert dates, select an option:

• Enter '@' then under the 'Dates section', select from the pop-up list.
• Input:
  • @date: Opens the date picker
  • @today: Shows today's date
  • @yesterday: Shows yesterday's date
  • @tomorrow: Shows tomorrow's date
  • A relative date, like @monday, @next tuesday or @last wednesday

Tip: To open the date picker, double-click a date.

Convert emails, links and more to smart chips

Add people smart chips

Insert from menu

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 Smart chips Convert to people chip.

Tip: To insert from the cell menu, right-click a cell. Click Smart chips Convert to people chip.

Tab to convert

Paste an email address to a cell, then press Tab to create a people chip.

Add file smart chips

Insert from menu

1. On your computer, open a spreadsheet in Google Sheets.
2. Select a range of cells with file links.
3. At the top, click Insert Smart chips Convert to file chip.

Tip: To insert from the cell menu, right-click a cell. Click Smart chips Convert to file chip.

Insert from cell

1. On your computer, open a spreadsheet in Google Sheets.
2. To find the file preview, hover over a cell with a file link.
3. At the bottom of the preview, click Replace URL Chip.

Tab to convert

Paste a file link to a cell, then press Tab to create a file chip.

Add event smart chips

Insert from menu

1. On your computer, open a spreadsheet in Google Sheets.
2. Select a range of cells with calendar event links.
3. At the top, click Insert Smart chips Calendar events.

Tip: To insert from the cell menu, right-click a cell. Click Smart chips Calendar events.

Insert from cell

1. On your computer, open a spreadsheet in Google Sheets.
2. To view the event preview, hover over a cell with a calendar event link.
3. At the bottom of the preview, click Replace URL Chip.

Add place smart chips

Insert from menu

1. On your computer, open a spreadsheet in Google Sheets.
2. Select a range of cells with Google Maps links.
3. At the top, click Insert Smart chips Convert to place chip.

Tip: To insert from the cell menu, right-click a cell. Click Smart chips Convert to place chip.

Insert from cell

1. On your computer, open a spreadsheet in Google Sheets.
2. To view the map preview, hover over a cell with a Maps link.
3. At the bottom of the preview, click Replace URL Chip.

Tab to convert

Paste a Maps link to a cell, then press Tab to create a place chip.

Add finance smart chips

Insert from menu

1. On your computer, open a spreadsheet in Google Sheets.
2. Select a range of cells with Google Finance entities.
3. At the top, click Insert Smart chips Finance.

Tip: To insert from the cell menu, right-click a cell. Click Smart chips Finance.

Add YouTube smart chips

Insert from cell

1. On your computer, open a spreadsheet in Google Sheets.
2. To view the YouTube video preview, hover over a cell with a YouTube video link.
3. At the bottom of the preview, click Replace URL Chip.

Tab to convert

Paste a YouTube video link to a cell, then press Tab to create a YouTube chip.

Add rating smart chips

Insert from menu

1. On your computer, open a spreadsheet in Google Sheets.
2. Select a range of cells with integer values between zero and five.
3. At the top, click Insert Smart chips  Rating.

Tip: To insert from the cell menu, right-click a cell. Click Smart chips Rating.

Tips:

• You can make format changes to chips, such as:
  • Colour
  • Size
  • Font style
• To change the format of a people chip:
  1. Select the people chip that you want to edit.
  2. At the top, click Format Smart chips.
  3. Select an option:
     • Default
     • Surname, first name
     • Email address
• To remove formatting, at the top, click Format Clear formatting.

Add drop-down chips

You can add and customise drop-down chips that display multiple options.

Add or edit a drop-down

1. On your computer, open a spreadsheet in Google Sheets.
2. Select an option:
   • Enter '@'. In the menu, under the components section, click Drop-downs.
   • At the top, click Insert Drop-down.
   • Click Data Data validation Add rule .
   • Right-click on a cell Drop-down.
3. To make changes to a drop-down, click the drop-down and select an option.
4. To edit a drop-down's options, click the drop-down Edit button .

Learn more about how to create an in-cell drop-down list.