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

Google Sheets tutorials›Spreadsheet basics›Change spreadsheet locale

Google Sheets · Verified tutorial

Change spreadsheet locale in Google Sheets

Open File > Settings and change this spreadsheet's locale to United Kingdom. Save the setting. Do not change any cell values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Open File > Settings and change this spreadsheet's locale to United Kingdom. Save the setting. Do not change any cell values.

Step-by-step

1

Select the targetOpen File > Settings and change this spreadsheet's locale to United Kingdom.

2

Apply the changeSave the setting.

Shortcut or faster method

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

Expected result

The spreadsheet locale is United Kingdom (en_GB).

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 spreadsheet locale is United Kingdom (en_GB).

Example spreadsheet data

This is the clean fixture used for the verified run.

Item	Amount
North	120
South	180

Video transcript

Open the prepared Regional settings spreadsheet.
Select the target. Open File > Settings and change this spreadsheet's locale to United Kingdom.
Apply the change. Save the setting.
The spreadsheet locale is United Kingdom (en_GB).