Extract data from smart chips in your Google Sheets

When you insert smart chips into a spreadsheet, you can extract data from the smart chips into separate rows or columns.

1. On your computer, open a spreadsheet in Google Sheets.
2. Select a cell with a single chip or a range of cells that each contain a chip.
3. Choose an option:
   1. Right-click on the cell or cells Data extraction .
   
   2. Click Data > Data extraction .
4. Under 'Data to extract', select the data types that you want to extract.
5. Under 'Extract to', select a cell or a range of cells for the extracted data.

Extract data with syntax

Sample usage

A2.Location

A2.[Creation time]

A2:A4.Title

Syntax

Cell_or_range.data_type

• Cell_or_range: A cell with one smart chip or a range of cells each containing a smart chip with the same type.
• Data_type: The data type to be extracted from the selected cell or range of cells. 

Example

Input this formula in B2: =A2.[filename]

Input this formula in C2: =A2.[creation time]

Input this formula in D2: =A2.[last modified time]

Result:

	A	B	C	D
1	Chip	Filename	Creation time	Last modified time
2	<file chip>	Sample chip extraction doc	25/01/2023 13:22:29	25/01/2023 13:22:41

Extract data from smart chip

1. On your computer, open a spreadsheet in Google Sheets.
2. Hover over a cell with a single chip.
3. Click Data extraction to open a sidebar on the right.
4. Under 'Data to extract', select the data types that you want to extract.
5. Under 'Extract to', select a cell or a range of cells for the extracted data.

Refresh extracted data

To refresh extracted data from cells:

1. On your computer, open a spreadsheet in Google Sheets.
2. Select a cell with a single chip or a range of cells with each containing a chip.
3. Right-click on a cell Smart chips Refresh data.

To refresh extracted data from Data extraction sidebar:

1. On your computer, open a spreadsheet in Google Sheets.
2. Select a cell with a single chip or a range of cells with each containing a chip.
3. Choose an option:
   1. Right-click on the cell or cells Data extraction .
   2. Click Data > Data extraction .
4. Click Refresh and manage.
5. Find the smart chips data that you want to refresh.
6. Click Refresh data

Tip: To refresh all smart chips data, click Refresh all at the bottom of the sidebar.

Types of data that you can extract

You can extract data from smart chips in your Google Sheets to include information about the following chips:

People smart chip

Information comes from domain profiles.

• Email
• Name
• Location*
• Phone*
• Title*

Note: Information with * is only available to Google Workspace Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, and the Teaching and Learning Upgrade users.

File smart chip

Information comes from your files in Google Drive.

• MIME type
• URL
• Filename
• Owner*
• Creation time*
• Last modified by*
• Last modified time*

Note: Information with * is only available to Google Workspace Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, and the Teaching and Learning Upgrade users.

Event smart chip

Information comes from events on your calendar.

• URL
• Summary
• Creator*
• Description*
• Date/time*
• Location*
• Attendees*

Note: Information with * is only available to Google Workspace Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, and the Teaching and Learning Upgrade users.

Note: Extracting uses your permissions to access the data, so you may be able to extract data into a file that collaborators on that file may not be able to access themselves. 

Related articles

Insert smart chips in your Google Sheets