Google Sheets – Set Default Locale for New Spreadsheets

google sheets

To change a spreadsheets locale one selects File > Spreadsheet Settings > Locale

There is a problem here in that one must make that change for each new spreadsheet created and not doing so causes some difficulties in that cells need to be changed to the new Locale which isn't always successful.

How does one set the default locale for every new spreedsheet in Google Sheets?

Best Answer

The locale setting is set by the language setting for your account. You can set/change this at: https://myaccount.google.com/language

The timezone is a device setting.

Summarised (and confirmed) from a Google Support question Set default timezone/locale for all current and future Sheets