NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Spreadsheet basics›Add a place chip

Google Sheets · Verified tutorial

Add a place chip in Google Sheets

Use the table header menu to change the "Location" column type to Place chip. Leave the cells blank and do not change the Office values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Use the table header menu to change the "Location" column type to Place chip. Leave the cells blank and do not change the Office values.

Step-by-step

1

Select the targetUse the table header menu to change the "Location" column type to Place chip.

2

Apply the changeLeave the cells blank and.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

The Location table column is configured as a Place chip column.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Undo the last change, reselect the intended range, and try again. The Location table column is configured as a Place chip column.

Example spreadsheet data

This is the clean fixture used for the verified run.

Office	Location
Barcelona
London
New York

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Use the table header menu to change the "Location" column type to Place chip.
Apply the change. Leave the cells blank and.
The Location table column is configured as a Place chip column.