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

Google Sheets tutorials›Spreadsheet basics›Convert a range to a table

Google Sheets · Verified tutorial

Convert a range to a table in Google Sheets

Convert the existing range A1:C4 into a Google Sheets table. Keep row 1 as the headers and preserve every value.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Convert the existing range A1:C4 into a Google Sheets table. Keep row 1 as the headers and preserve every value.

Step-by-step

1

Select the targetConvert the existing range A1:C4 into a Google Sheets table.

2

Apply the changeKeep row 1 as the headers and preserve every value.

Shortcut or faster method

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

Expected result

The original range is represented by a table covering A1:C4.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A1:C4 and repeat the final action. The original range is represented by a table covering A1:C4.

Example spreadsheet data

This is the clean fixture used for the verified run.

Task	Owner	Budget
Prepare brief	Anna	120
Review draft	Ben	240
Publish page	Cara	80

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Convert the existing range A1:C4 into a Google Sheets table.
Apply the change. Keep row 1 as the headers and preserve every value.
The original range is represented by a table covering A1:C4.