Expanding the power of Google Sheets with localized formatting and improved CSV imports
Tuesday, February 7, 2023
We’re introducing updates to improve the overall Google Sheets experience for users around the world.
First, Sheets will now automatically use 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.
- 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.
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.
- Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers
- Available to users with personal Google Accounts