What’s changing
We’re introducing updates to improve the overall Google Sheets experience for users around the world.
First, Sheets will now automatically interpret regional-specific decimal separators based on your spreadsheet's locale. For example, in France, it is more common to use commas as decimal separators. Starting today, when using a keyboard with a number pad, you can use the decimal key to insert the regional-specific decimal separator in Sheets.
Second, we’re making it easier to import CSV files into Sheets. Previously, if you used commas (,) as your decimal separators and semicolons (;) as your text separators, you had to choose a custom delimiter and type ";" for the import to properly split text to columns. Starting today, Sheets will autodetect semicolons (;) as a way to separate text into columns.
Getting started
- Admins: There is no admin control for this feature.
- End users: Visit the Help Center to learn more about setting a spreadsheet’s location & calculation settings, formatting numbers in a spreadsheet and importing data sets & spreadsheets.
Rollout pace
Sheets Locale:
- Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on February 7, 2023
Semicolon autodetect in Sheets:
- This feature is available now for all users.
Availability
- Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers
- Available to users with personal Google Accounts