Case Converter: Uppercase, Lowercase, Title Case
This add-on changes the case of the text in the cells you select in Google Sheets™: uppercase, lowercase, Capitalize Each Word, Sentence case, Title Case or the inverted case. Only the text changes: formulas, numbers, dates, checkboxes, empty cells, bold, italics, colours and links are left exactly as they are. It is free.
Install it from the Google Workspace Marketplace™, or from Extensions › Add-ons › Get add-ons inside Google Sheets™.
How to use it
- Select the cells, columns or rows you want to change. You can select several blocks with Ctrl+click.
- Open the Extensions menu, find Case Converter and pick an option.
- A small message tells you how many cells changed. Ctrl+Z (Cmd+Z on Mac) restores the previous text.
What it takes care of
- Cells with formulas, numbers, dates or checkboxes are never written. Text that starts with = or + is also left alone, because Sheets would read it as a formula.
- Bold, italics, colours and links inside a cell stay in place.
- Title Case keeps small words lowercase (of, and, the; de, los; della…). It guesses the language from the text itself and falls back to the language of your Google account.
- Accented letters and ñ, ç, ü are handled correctly. A German ß becomes SS in uppercase, as in standard German spelling.
- Up to 20,000 cells per run; for bigger sheets, select a smaller block.
Languages
The menus follow the language of your Google account: English, Spanish, Portuguese, French, German and Italian. Any other language shows English.
Questions
Nothing changed.
The selected cells had no text to change: formulas, numbers and empty cells are skipped, and text that is already in the case you chose counts as unchanged.
The selected cells had no text to change: formulas, numbers and empty cells are skipped, and text that is already in the case you chose counts as unchanged.
Can I undo?
Yes. Ctrl+Z (Cmd+Z on Mac) restores the previous text.
Yes. Ctrl+Z (Cmd+Z on Mac) restores the previous text.
Does it work in the mobile app?
No. Google Sheets™ add-ons run in the web version only.
No. Google Sheets™ add-ons run in the web version only.
What can it see?
Only the spreadsheet you have open, and only while you use it. It reads the cells you selected and writes back the ones whose text changes. See the privacy policy.
Only the spreadsheet you have open, and only while you use it. It reads the cells you selected and writes back the ones whose text changes. See the privacy policy.
Anything else: support@singletasktools.com.