Short answer: If Mac dictation is not working in Google Sheets, double-click the cell or press Return until a blinking cursor appears, then start dictation. A selected cell is not in edit mode. Sheets has no voice typing of its own, so check your edit access, protected ranges and Apple's dictation settings.
You have a column of call notes to fill in, and talking through them would be far quicker than typing. You click a cell in Google Sheets, press your dictation shortcut, say a sentence, and nothing appears. Or the words appear and wipe out what was already in the cell. Or your first sentence lands where you wanted and the second one turns up a row further down, on top of somebody else's entry.
Google Sheets is an awkward place to dictate for three reasons. First, it has no voice typing of its own, so on a Mac you are relying on Apple's built-in dictation or another dictation app. Second, a spreadsheet grid is not a page of text. Clicking a cell selects it, but you are not editing it yet. Third, Sheets decides what your words become. A spoken date, a number or a phrase that starts with a plus sign can be stored as something you never said.
None of that means dictation is broken. It means the cell was not ready for text, the sheet would not accept it, or Sheets changed it on arrival. This guide works through each cause in order. If dictation is failing in every app on your Mac, not only in Sheets, start with our complete guide to Mac dictation not working instead.
Where is voice typing in Google Sheets?
If you are hunting for Tools, then Voice typing, you will not find it in a spreadsheet. That menu item belongs to Google Docs, and Google Slides offers voice typing only for speaker notes. Sheets simply does not have it. It is not a setting you switched off or something missing from your account. If voice typing inside Docs is what has stopped working for you, our guide to Google Docs voice typing not working covers that separately.
That leaves the dictation built into macOS, which works in any text field in any app, a browser tab included. Because Apple dictation is part of macOS rather than part of the website, Sheets never asks for microphone permission, and you do not need to allow the mic for Google's site in your browser. A missing site permission is not the reason dictation fails here. The reasons are all about the cell.
Why a spreadsheet is harder on dictation than a document
In a document, clicking anywhere puts a blinking cursor in the text, and whatever you say goes there. In Sheets, one click puts a blue border around a cell. That is selection, not editing. Typing into a selected cell replaces whatever was in it, and dictated words arrive exactly like typed ones, so at best you overwrite the cell, and the switch into editing is not always clean.
Editing mode is different. Double-click the cell, press Return, or click in the formula bar above the grid, and a cursor appears inside the cell's contents. Only then does dictation behave the way you expect. Then, when you are done, Return does not add a new line. It commits the cell and moves you down a row. Add access levels, protected ranges, formulas that fill whole blocks of cells, and a browser with its own extensions, and there are plenty of ways to be looking at a cell that will not take your words.
The 30-second split test
Before you change anything, find out whether the problem is Sheets, your browser or your Mac. Open TextEdit, create a new document, start dictation and say a sentence.
- If dictation fails in TextEdit too, the problem is Apple dictation or your microphone. Go straight to fix 10.
- If it works in TextEdit but not in any web page, try a Gmail draft or any search box. If those fail as well, the problem is your browser. Go to fix 9.
- If it works on other web pages but not in Sheets, the problem is the spreadsheet. Start at fix 1 and work down.
The 10 fixes, in order
1. Put the cell into edit mode before you speak
This is the most common cause by far. Double-click the cell, or select it and press Return, until you see a blinking cursor inside it. Pressing F2 also works on keyboards where the function keys are set up for it. You can also click in the formula bar above the grid, which edits the same cell with more room to see what you are saying. Only once the cursor is blinking should you start dictation.
Then check where that cursor is. Double-clicking a cell that already has text can drop the cursor in the middle of a word, and dictation inserts at the cursor. If any text is highlighted, dictation replaces it. To add to the end of an existing note, click once at the very end of the text in the formula bar before you speak, so nothing is selected and the cursor sits after the last word.
2. Stop Return from scattering your notes down the column
In Sheets, Return means "this cell is done". It saves the entry and moves the selection one row down. If you say "new line" or "new paragraph" while dictating, Apple dictation sends a line break, which Sheets treats as Return. The cell is committed mid-thought, and whatever you say next can land in the cell below, replacing what was there. Anything that sends a Tab does the same thing sideways.
To put a line break inside a cell, press Cmd+Return or Option+Return (which one works can depend on your browser) at the point where you want the break, then carry on dictating. For longer notes, dictate a sentence or two at a time and add breaks by hand. If your words have already spread down the column, Cmd+Z undoes one step at a time until the original cells come back.
3. Make sure you can actually edit the spreadsheet
If nothing you type or dictate changes anything, look near the title and the Share button at the top of the page. A label such as View only means you can look but not change. Comment access is similar: you can add comments, but not edit cells. Unlike Google Docs, Sheets has no suggesting mode, so there is no way to propose changes inside the cells themselves.
Check which Google account the sheet is open under, too. If you are signed in with a personal and a work account in the same browser, the file may have opened under the one without edit rights. Switch accounts from your profile picture, or ask the owner for edit access. If you only need your own version, choose File, then Make a copy, and dictate into the copy. And if the file is an uploaded Excel spreadsheet showing in Drive's preview, open it with Google Sheets before you try to edit.
4. Look for protected sheets and ranges
Owners can protect a whole sheet or a range of cells. Depending on how the protection is set, you are either blocked with a message saying the cell is protected, or shown a warning you have to confirm before editing. Either way, a dialog opens and takes keyboard focus, so your dictated words have nowhere to go. If a box flashed up and disappeared as you started speaking, this is the likely cause.
If you own the sheet, open Data, then Protect sheets and ranges, to see what is protected and who can edit it. If you do not, ask the owner which cells are open for you, or work in a copy.
5. Stop Sheets turning your words into dates, numbers or formulas
Sheets looks at every entry and decides what kind of value it is. Dictate "March 3" and you may get a date. Dictate "3/4" and you may get a date that depends on your locale settings. Dictate a phone number or an ID with a leading zero and the zero can disappear. And if what you say begins with an equals sign, a plus sign or a minus sign, Sheets treats the whole entry as a formula, which usually ends in an error such as #ERROR! or #NAME?.
Apple dictation adds to this, because it converts spoken words into digits and symbols. "Five percent" can arrive as "5%", which Sheets then stores as a number rather than the words you meant. There are two reliable fixes:
- For one cell, type an apostrophe first, then dictate. The apostrophe tells Sheets to keep the entry as plain text, and it does not show in the cell.
- For a whole column of notes, IDs or phone numbers, select the column and choose Format, then Number, then Plain text before you start. Everything you dictate into it afterward stays exactly as written.
6. Watch for autocomplete, dropdowns and smart chips
Three Sheets features can change your words after you speak them:
- Autocomplete. When you start an entry in a column, Sheets can suggest a matching value that already exists higher up. If a suggestion is showing when Return is pressed, Sheets accepts it. Dictate "Acme" and you can end up with "Acme Holdings Ltd" copied from row 12. You can turn this off from the Tools menu, under Autocomplete.
- Dropdowns. Cells with data validation expect one of a fixed list of values. If dictation adds a full stop, so "Approved." instead of "Approved", the entry no longer matches. Depending on the rule, Sheets either marks it as invalid or rejects it outright. Turn off automatic punctuation in Apple's dictation settings for this kind of work, or pick from the dropdown by hand.
- Smart chips. Typing an @ sign in a cell can open a menu of people, files and other chips. If you dictate an email address, that menu can pop up mid-entry and grab the next Return. Close the menu with Escape, or type the @ yourself.
7. Know which cells will not hold your words
Some cells look like ordinary values but are really the output of a formula. Dictating into one of them replaces the formula with your text, which is rarely what you wanted.
The trickier case is a formula that fills a whole block of cells from one cell at the top, such as FILTER, SORT, UNIQUE, ARRAYFORMULA or IMPORTRANGE. Everything below the top cell belongs to that formula. If you dictate into one of those cells, the formula at the top breaks with a #REF! error saying the result was not expanded because it would overwrite data. Delete what you dictated and the block fills back in. Pivot table results are calculated in the same way, so change the source data rather than the pivot table itself.
8. Check where keyboard focus really is
A spreadsheet window is full of text boxes that are not cells. The Name box at the top left shows the cell reference, such as A1, and anything you dictate there is treated as a place to jump to. Cmd+F opens Sheets' own find bar. Comment threads, the chart editor, version history and other side panels all have their own fields. And the browser's address bar is always one click away.
If your words keep appearing somewhere unexpected, focus was in one of those places when you started. Click back into the grid, get the cell into edit mode (fix 1), and try again. Also remember that dictation goes to the active cell even if you have scrolled away from it. If the blue border is off screen, your words are going to a cell you cannot see.
9. Rule out the browser and its extensions
Sheets runs inside your browser, so anything that changes how the browser handles typing can affect dictation. Grammar checkers, translation tools, text expanders and some password managers all watch what you type. Open the sheet in a Chrome Incognito window, where extensions are off unless you have allowed them, or in a different browser. If dictation suddenly works, turn your extensions back on one at a time to find the culprit. Our guide to Mac dictation not working in Chrome goes deeper on browser-side causes.
While you are there, look at the status near the top of the sheet. If Sheets says it is offline or trying to connect, edits can stall until the connection comes back, so wait for it or reload the page. Very large sheets can also lag, so dictated text arrives in a burst a moment after you finish speaking. Give it a second before clicking elsewhere, or you may commit a half-finished entry.
10. Check Apple dictation itself
If dictation failed in TextEdit too, the problem is on the Mac. Open System Settings, then Keyboard, and make sure Dictation is turned on. Check the shortcut shown there, since pressing the wrong key is a frequent cause, and our guide to a Mac dictation shortcut that does nothing covers every shortcut problem. Check that the dictation language matches the language you are speaking, and that the microphone source is the mic you are actually using.
Dictation also cannot hear you if something else is holding the microphone, such as a video call or a recording app. Finish those first. On a work Mac, dictation may be restricted by your organization's management profile. If everything looks right and it still fails, quit your browser completely, restart the Mac and try again.
Google Sheets quirks that look like broken dictation
Some problems are not failures at all, just the way spreadsheets handle text:
- The text runs into the next column, or seems cut off. A long entry spills over empty cells to its right and is clipped when the next cell has something in it. The words are all there. Choose Format, then Wrapping, then Wrap to see them.
- Every cell starts with a capital letter. Dictation treats the start of each entry as the start of a sentence. That is expected, and easy to change afterward if the column needs lowercase.
- Lookups and filters stop matching. A trailing full stop or a stray capital makes a dictated "approved." different from "Approved". If a VLOOKUP or a filter misses rows you dictated, check the ends of the entries.
- Dictation stops halfway through a note. Apple dictation stops listening after a pause. If that keeps happening, our guide to Mac dictation cutting off mid-sentence explains what you can change.
Quick triage table
| What you see | Most likely cause | Fix |
|---|---|---|
| Nothing appears in the cell | Cell selected, not in edit mode | 1 |
| Dictation replaced the whole cell | Cell selected, or text highlighted | 1 |
| Second sentence lands a row down | "New line" sent Return | 2 |
| Nothing can be changed at all | View-only access or wrong account | 3 |
| A box flashes up and dictation vanishes | Protected cell or range | 4 |
| Words become a date, number or error | Automatic formatting or formula parsing | 5 |
| Extra words appear after yours | Autocomplete accepted a suggestion | 6 |
| A #REF! error appears above | Dictated into a formula's output block | 7 |
| Words turn up in the wrong place | Focus in a panel, box or address bar | 8 |
| Fails on every web page | Browser or extension | 9 |
| Fails in TextEdit too | Apple dictation or mic problem | 10 |
Dictation works in Google Docs, so why not Sheets?
A document is one long run of text, so the cursor is always somewhere sensible and Return just starts a new line. A spreadsheet is hundreds of small text boxes, each of which has to be opened, filled and committed, and each of which Sheets inspects and may reformat. Docs also has its own voice typing, which Sheets lacks. The same selected-versus-editing split exists in desktop spreadsheet apps as well, so if you use both, our guides to dictation in Excel on Mac and dictation in Numbers will look familiar.
A dictation workflow that suits spreadsheets
Dictation in Sheets works best when you treat each cell as a short, deliberate entry:
- Prepare the columns first. Set note, ID and phone number columns to Plain text before you start, so nothing gets reformatted.
- Use the formula bar for long notes. It shows the whole entry as you speak, so you can see mistakes before you commit.
- Commit and move by hand. Dictate one cell, press Return or an arrow key yourself, then enter edit mode on the next cell. It sounds slower, but it avoids the cleanup.
- Draft long passages elsewhere. For a paragraph of analysis, dictate it into a document and paste it into the cell.
- Check numbers and names before you share. A misheard figure in a spreadsheet can feed into totals and charts without anyone noticing.
It is worth the effort, because speaking is much faster than typing. Most adults type around 40 words per minute, and even professional typists usually sit around 80 to 100, while normal speech runs at 130 to 150 words per minute. For a sheet full of notes, comments or descriptions, that difference adds up quickly. For more on setting up a sheet for voice entry, see our guide to dictating into Google Sheets cells.
A dictation tool that behaves the same in every cell
Apple dictation is free and built in, but it has its own shortcut quirks, it stops when you pause to think, and its "new line" commands send exactly the Return key that commits a cell. On a sheet where you are dictating short entries into dozens of cells, those small frictions add up.
Voice Keyboard Pro is a menu bar app for Mac that works in Google Sheets the same way it works everywhere else. Hold your hotkey, speak, release, and the text appears at your cursor, whether that is a cell, the formula bar or a comment box. Because you hold the key for as long as you are speaking, you decide exactly where each entry starts and ends. It does not depend on Apple's dictation toggle or shortcut, and the website never needs microphone permission, because the app uses its own permissions that you grant once in Privacy & Security. It still needs a cursor inside a cell, like any typing does, so fix 1 applies to it too.
A few features matter for spreadsheet work in particular:
- Smart Vocabulary is a personal dictionary with replacement rules. Add client names, product codes and internal terms once, and they come out spelled the same way every time. In a spreadsheet that matters more than usual, because filters, lookups and dropdowns all depend on entries matching exactly.
- Meeting Mode records meetings with speaker detection and produces AI notes, so you can capture decisions from a planning or budget review and update the sheet afterward.
- Calendar meeting detection notices when a scheduled meeting is starting, so there is nothing to remember to set up beforehand.
On privacy, our servers store only operational pings. No audio and no transcript content is stored. There is a free tier with daily limits, and Pro is $4.99 a month or $34.99 a year. The same app is also a custom keyboard on iPhone, with a mic button for dictation in any iOS app.
Frequently asked questions
Does Google Sheets have voice typing?
No. Voice typing is a Google Docs feature, and Google Slides offers it only for speaker notes. In Sheets on a Mac, use Apple's built-in dictation or another dictation app, which work in any cell you can edit.
Why does clicking a cell not let me dictate into it?
One click only selects the cell. Double-click it, press Return, or click in the formula bar until a blinking cursor appears, then start dictating. Dictating into a cell that is only selected replaces its contents at best.
Why does my dictation jump to the cell below?
Saying "new line" makes Apple dictation send a line break, and Sheets treats that as Return, which saves the cell and moves down a row. To add a line break inside a cell, press Cmd+Return or Option+Return instead.
Why do dictated numbers turn into dates or errors?
Sheets reformats entries it recognizes as dates or numbers, and treats anything that starts with =, + or - as a formula. Type an apostrophe before dictating, or set the column to Plain text under Format, then Number.
Do I need to allow the microphone for Google Sheets in my browser?
Not for Apple dictation, which is part of macOS and never asks the website for permission. The browser only needs microphone access for a website's own mic button, and Sheets does not have one.
What to do next
Run the 30-second split test, then work through the fixes that match what you saw. For most people it is fix 1: the cell was selected but never in edit mode. If your notes keep ending up a row too low, fix 2 is the answer, and if words turn into dates or errors, fix 5. And if you want dictation that starts and stops exactly when you choose in every cell, try Voice Keyboard Pro's free tier on your next column of notes.
The words land at your cursor in whatever app you are already in — Mail, Slack, Word, a browser form. No dictation window, nothing to copy across.
Free forever for casual use · Apple Silicon & Intel