Case Wizard help
Installing, permissions, what each conversion does, and what to do when something looks wrong.
Getting started
Adding it to Google Sheets
Open The Case Wizard listing, click Install, and choose the Google account you use for Sheets. It is free, there is nothing to pay, and you are never asked for a card.
Where to find it once it is installed
Open any spreadsheet and go to Extensions › The Case Wizard. The sidebar opens on the right and stays there while you work.
If the menu item is not there yet, jump to Common problems. Nine times out of ten the spreadsheet was already open when you installed and simply needs a refresh.
How you actually use it
Select the cells you want to fix, pick a conversion in the sidebar, look at the before-and-after preview, then apply. The preview is the point. Nothing changes in your sheet until you press the button.
The permissions screen
The first time you open it, Google asks you to approve two things. That is the whole list.
See and edit this spreadsheet only
The narrow version of the permission. It works on the spreadsheet you have open and no other file in your Drive.
Display and run third-party web content
A scary name for a boring job. It draws the sidebar, which is the entire interface.
There is no permission to see your email address, because there is nothing to bill you for. You can remove access at any time at your Google account permissions page.
“Google hasn’t verified this app”
This screen is normal, and it goes away by itself.
It appears while an add-on is going through Google’s verification review, and it appears for every add-on sitting in that queue.
To continue: click Advanced, then Go to The Case Wizard (unsafe), then Allow. The word “unsafe” is Google’s standard wording for “we have not finished checking this one yet”. It is not a warning about anything we have done.
What each button does
| Button | Before | After |
|---|---|---|
| UPPERCASE | invoice paid | INVOICE PAID |
| lowercase | INVOICE PAID | invoice paid |
| Title Case | annual REPORT draft | Annual Report Draft |
| Sentence case | the Invoice Was Paid Late | The invoice was paid late |
| Smart Name Case | sarah O'BRIEN | Sarah O'Brien |
| Trim spaces | Acme Pty Ltd | Acme Pty Ltd |
| Text into links | thesheetwizard.com | A clickable link, built with =HYPERLINK() |
Title Case and Smart Name Case are not the same thing
Title Case capitalises the first letter of every word, which is what you want for headings and product names.
Smart Name Case is built for people’s names, so it knows that O'Brien and McDonald keep a capital in the middle. If you are cleaning a customer list, use this one.
Trim spaces is the one that fixes broken lookups
A stray space at the end of a cell is invisible, and it is the reason VLOOKUP and XLOOKUP return an error on a value you can plainly see sitting there. Trim removes leading spaces, trailing spaces and double spaces between words, all in one pass.
If a lookup is failing on data that looks correct, run Trim on both columns before you debug anything else. It is the answer more often than it has any right to be.
Text into links
Turns a column of plain web addresses into working links in one go, using a =HYPERLINK() formula. If your addresses are already blue and clickable, Sheets has linked them for you and there is nothing to convert.
What it will not touch
Formulas are left completely alone.
If a cell in your selection contains a formula, the add-on skips it. You can select a whole column that mixes typed text and formulas, apply a conversion, and only the typed text changes.
This matters because the obvious alternative, a find and replace or a helper column, will happily flatten a formula into text and you will not notice until something downstream breaks.
It also leaves numbers, dates and blank cells as they are. Changing the case of a date would be a strange thing to do to somebody.
Your data
Only the sheet you have open
Not your Drive, not your other files. That is built into the permission it asks for, so it is not a promise, it is a limit.
Nothing is sent anywhere
The add-on makes no network requests at all. There is no server to send anything to, because everything happens inside your spreadsheet.
No account, no sign-up
We do not know who you are and we are not asking. There is nothing to log in to.
Nothing is stored or sold
No trackers, no advertising networks, no data brokers, no database with your name in it.
Full detail is in our privacy policy.
Common problems
The add-on is not in my Extensions menu
Close the spreadsheet tab and open it again. Google only builds the Extensions menu when a spreadsheet loads, so anything installed while a sheet was already open will not appear until the next load.
Still missing? Check you are signed into the same Google account you installed it with. See the next section.
I am signed into more than one Google account
This is the most common cause of odd behaviour, and it is Google’s doing rather than ours.
When you are signed into several accounts at once, Chrome numbers them in the address bar as /u/0/, /u/1/ and so on. An add-on installed on /u/0/ will not appear when you are working in /u/1/. It is not lost. You are in a different account.
Quickest test: open the spreadsheet in an incognito window, sign into one account only, and see whether it behaves.
Nothing happened when I pressed the button
Check that you actually had cells selected. The add-on works on your selection, and an empty selection gives it nothing to do.
Also check whether the cells contain formulas. Those are skipped on purpose, so a selection made entirely of formulas will come back unchanged, exactly as designed.
A hyphenated name came out half right
Known behaviour, and worth flagging honestly. MARY-anne becomes Mary-anne rather than Mary-Anne, because the letter after a hyphen is not currently treated as the start of a new word.
For now, fix hyphenated surnames by hand after the conversion. It is on the list to improve.
I want to undo a conversion
Use Google’s own undo straight away: Ctrl+Z, or Cmd+Z on a Mac. The add-on writes into your sheet the ordinary way, so Sheets treats it as a normal edit and undo works on it.
If you have closed the file since, you can still get the old version back with File › Version history.
My links did not change
Sheets often turns anything that looks like a web address into a link by itself. If yours are already blue and clickable, they are already links, and there is nothing left for the conversion to do.
The sidebar is blank, or the spinner never stops
Close the sidebar and reopen it from Extensions › The Case Wizard. If that does not do it, reload the spreadsheet. Still stuck? Try an incognito window with one Google account signed in, which rules out a browser extension getting in the way.
My work or school account will not let me install it
Google Workspace administrators can block add-ons across a whole organisation. If you see a message about your administrator, or the install button does nothing at all, you will need to ask your IT team to allow it. We cannot override that from our end, which is rather the point of the setting.
Still stuck?
Tell us what happened and we will help.
To get a useful answer first time, tell us what you selected, which button you pressed, what you expected, and what you got instead. A screenshot is worth about four paragraphs.
We are a small operation rather than a call centre, so you will get a real person. It just may not be instant.