iPhone Dictation Not Working in Google Sheets? 10 Fixes That Work

Short answer: In Google Sheets on iPhone, dictation uses the mic on your keyboard, and the keyboard only appears when a cell is being edited. Double-tap the cell, or tap the edit bar, until a cursor blinks. If words turn into dates or errors, start the entry with an apostrophe.

You open a spreadsheet in Google Sheets on your iPhone to log a figure or add a quick note beside a row, and you would rather say it than type it with your thumbs. You tap the cell and look for the mic. There is no keyboard at all. Or the keyboard appears, but it is a number pad with no mic on it. Or you dictate a note and it turns into a date, a formula error or a number, or half of it lands in the cell below.

Google Sheets on a phone is mostly for looking at a grid. A tap selects a cell without opening it, so nothing is being written and no keyboard appears. When you do open a cell, Sheets reads every entry and decides what kind of value it is, a date, a number, a formula or plain text, and that decision happens after your words have arrived. On top of that, a spreadsheet can be view-only, protected, or open in a preview that was never meant for editing.

So most Google Sheets dictation problems are about the cell and about how Sheets reads what you said, not about your microphone. This guide works through every cause in order, starting with the most common. If dictation is failing in every app on your phone and not only in Sheets, start with our complete guide to iPhone dictation not working instead. The same fixes apply to Google Sheets on iPad.

How dictation reaches Google Sheets on iPhone

Google Sheets has no voice typing tool of its own. On iPhone, dictation comes from the keyboard. You open a cell, tap the mic key and speak, and the text arrives at the cursor exactly as if you had typed it. Sheets cannot tell the difference, which is why the same rules apply to spoken and typed entries alike.

That has one important consequence. If the keyboard does not appear, there is no mic to tap. Many Sheets dictation problems are really "no keyboard" problems, and the fix is to open the cell properly rather than to change a setting.

The 30-second Notes test

Before you change anything, open the Notes app, create a new note, tap in the body so the keyboard appears, then tap the mic key and say a sentence.

• If dictation fails in Notes too, the problem is dictation on your iPhone, not Sheets. Go to fixes 9 and 10.
• If it works in Notes but no keyboard appears in Sheets, start with fixes 1 and 2, then check fixes 3 and 4.
• If the keyboard appears but has no mic, go to fix 5.
• If your words arrive but end up in the wrong cell, or cut off, go to fix 6.
• If your words arrive but turn into a date, a number, an error or something else, go to fixes 7 and 8.

The 10 fixes, in order

1. Edit the cell, do not just select it

This is the most common cause by a wide margin. A single tap on a cell selects it and puts a border around it. It does not open it for editing, so the keyboard stays down and there is no mic. To edit, double-tap the cell, or select it and then tap the edit bar that shows the cell's contents, which reads something like "Enter text or formula" when the cell is empty. The keyboard slides up with a cursor in the edit bar, and the mic key is where it always is.

Wait until you can see the cursor blinking before you tap the mic. If you tap it the instant the keyboard appears, the first words can be lost while the cell is still getting ready. And keep your other fingers off the grid while you talk. A tap on another cell, or a scroll that Sheets reads as a tap, ends the edit and closes the keyboard, which stops dictation mid-sentence.

2. Open the spreadsheet in the Sheets app

Where a spreadsheet opens depends on how you got to it. Tap a link in Mail or Messages and it may open in Safari rather than the app. Open a file in the Google Drive app without the Sheets app installed and you may get a preview. Neither is a good place to edit. The mobile browser version of Sheets offers limited editing on a phone, and a preview is for reading only, so taps on cells do nothing useful and the keyboard never comes up.

Install Google Sheets from the App Store if you do not have it, then open the file from inside the app, or use the option to open it in the app when your browser offers one. If a spreadsheet shows an Edit button or a pencil icon, tap it first.

3. Check your access and which Google account you are using

If the spreadsheet opens but no cell will take an entry, you may only have permission to look at it. Sheets can be shared as view-only, or as comment-only, where you can add comments but not change cells. The app usually says so near the top of the screen, and may offer a way to ask the owner for edit access. If you only need to work with the numbers yourself, making a copy gives you a version you can edit.

The account matters as much as the sharing. If you are signed in to more than one Google account, the spreadsheet may have opened under one that was never invited, and a work or school account can have sharing rules that a personal account does not. Tap your profile picture in the Sheets app to see which account is active and switch to the one the file was shared with.

Your connection matters too. Sheets saves your changes to Google's servers as you go. If you are offline and the file is not set up for offline use, you may not be able to edit it, and edits made on a weak signal can take a while to appear for other people. If an entry looks different after you reopen the file, check your connection and dictate the missing part again.

4. Look for protected sheets, ranges and formula cells

Owners can protect a whole sheet tab or just a range of cells, so a spreadsheet you can edit in general may still have parts you cannot touch. Depending on how the protection is set up, Sheets either refuses the edit or warns you before letting it through. If one area refuses while the rest of the sheet works, that is the likely reason, and the owner or whoever set up the protection can change it.

Some cells are not meant to be typed into at all. A value produced by a formula is replaced if you dictate over it, which is rarely what you want. And a formula that fills a whole block of cells from one cell at the top owns everything in that block. Dictate into one of those cells and the formula breaks with a #REF! error. Delete what you dictated and the block fills back in. If you are not sure whether a cell holds a formula, select it and look at the edit bar before you open it.

5. Switch to a keyboard that has a mic

Sheets can show a number pad for entering figures, and some versions of the app put a button next to the edit bar that switches between letters and numbers. A pad built for digits and operators has no microphone key. If you see numbers where you expected letters, look for that button and switch back to the full keyboard.

If you use more than one keyboard, the globe key cycles between them. Tap and hold it to see the list and pick the one you dictate with. Apple's keyboard shows its mic when dictation is enabled, and many third-party keyboards have no mic of their own. If Apple's keyboard is showing and still has no mic, dictation is off or restricted on your iPhone. Fix 10 covers the settings, and our guide to a microphone button missing from the iPhone keyboard goes through every cause in more detail.

6. Confirm the entry, and keep Return for the end

Your words are not in the cell until you confirm them. Tap the checkmark next to the edit bar when you are done. Return usually confirms the entry too and moves you on to another cell, which is where a spoken "new line" causes trouble. It ends the entry halfway through your thought, and depending on what happens next, the rest either lands in the neighbouring cell or goes nowhere because no cell is open any more.

A cell is a poor home for paragraphs on a phone anyway. Keep each entry to one phrase or sentence, and if you need several lines of detail, use a comment or a notes column with room to wrap. If an idea has already split, open the first cell, tap at the end of its contents, and dictate or paste the rest back in, then clear the fragment from the cell next to it.

Let dictation finish before you confirm. If you tap the checkmark while the last words are still being processed, they can be dropped. Give it a beat after you stop speaking, check the edit bar shows everything, then confirm.

7. 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. A note that starts with a fraction such as "3/4" can become a date too, depending on your locale settings. A phone number or an ID with a leading zero can lose the zero. And an entry that begins with an equals sign, a plus sign or a minus sign is treated as a formula, which usually ends in an error. A phone number dictated with its country code, starting with a plus, is a common way to hit this.

Dictation adds to the problem, 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. Our guide to dictating numbers, dates and currency covers how to say them so they come out the way you want. For entries that must stay exactly as you said them, 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. On iPhone there is one catch: with Smart Punctuation turned on, the keyboard may type a curly apostrophe, which Sheets treats as an ordinary character. If you see the apostrophe in the cell afterwards, turn off Smart Punctuation under Settings, General, then Keyboard, and try again.
• For a whole column of notes, IDs or phone numbers, format it as plain text. Select the column, open the formatting options and choose Plain text as the number format. If your version of the app does not offer it, set it once from Sheets on a computer. Everything you dictate into the column afterwards stays exactly as written.

8. Watch for dropdowns, checkboxes, smart chips and autocomplete

Some cells are not free text, and some Sheets features change your words after you speak them:

• Dropdowns. Cells with data validation expect one of a fixed list of values, and tapping one may show the list instead of a cursor. If you dictate into one anyway, a full stop added by dictation turns "Approved" into "Approved.", which no longer matches, so Sheets marks it as invalid or rejects it. Pick from the list by hand.
• Checkboxes. A tap ticks or unticks them. There is nothing to dictate into.
• Smart chips. An at sign in a cell can open a menu of people and files. Dictate an email address and that menu can appear mid-entry and catch your next words or your Return. Dictate the rest first, then type the @ yourself.
• Autocomplete. When you start an entry in a column, Sheets can suggest a matching value from higher up. If the suggestion is accepted, "Acme" can become "Acme Holdings" copied from another row. Read the edit bar before you confirm.

9. Free up the microphone

Dictation needs the microphone to itself. A phone or FaceTime call, a video call in another app, or a recording app still running in the background can all keep hold of it, and dictation may refuse to start until they let go. End the call or stop the recording, then try again.

Headphones are the next suspect. If the mic key does nothing, or dictation starts and gives up at once, disconnect your Bluetooth earbuds or headset and test with the iPhone's own microphone. If that works, the problem is the headset connection, not Sheets. Our guide to iPhone dictation not working with AirPods walks through the headphone side.

10. Check dictation on your iPhone

If dictation failed in Notes too, the problem is on the phone. Open Settings, go to General, then Keyboard, and make sure Enable Dictation is on. If the switch is missing or greyed out, check Screen Time: under Content & Privacy Restrictions, open the allowed apps list and make sure Siri & Dictation is allowed. A work or school iPhone may also restrict dictation through its management profile.

Make sure the keyboard language matches the language you are speaking, since dictation follows the active keyboard. Then install any pending iOS update, update Google Sheets from the App Store, and if nothing else has worked, restart your iPhone. A restart clears stuck audio sessions and keyboard processes in one step.

Google Sheets quirks that look like broken dictation

• The text is there, but cut off. A long entry in a narrow column is hidden at the cell edge when the next cell has something in it. Nothing is lost. Select the cell and the edit bar shows all of it. Wrapping the text or widening the column makes it visible on the grid.
• Your entry went onto the wrong tab. Sheet tabs sit along the bottom of the screen, and it is easy to be one tab over from where you meant to be. Check the tab name before you dictate a batch of entries.
• Your words went into search. If you had just used find, focus may still be there. Close it, open the cell you meant, and dictate again.
• Dictation stops halfway through a note. iPhone dictation stops when you pause for a moment. Our guide to iPhone dictation that keeps stopping explains what you can do about it.
• Every entry ends with a full stop. iPhone dictation adds punctuation automatically, which suits sentences better than labels and figures. You can turn off Auto-Punctuation under Settings, General, then Keyboard, or delete the full stop before you confirm.
• Names and codes come out wrong. Customer names, product codes and abbreviations are the words dictation mishears most, and in a spreadsheet they matter, because a misspelled name breaks sorting, filters and lookups later.

Quick triage

• No keyboard after tapping a cell: the cell is selected, not open. Fix 1.
• Taps do nothing and the file looks like a preview: it is not open in the Sheets app. Fix 2.
• No cell will take an entry: view-only, comment-only or the wrong account. Fix 3.
• One area refuses, or a #REF! error appears: protection or a formula block. Fix 4.
• Keyboard is a number pad, or has no mic: Fix 5.
• Half an entry landed in the next cell, or the end went missing: Return or confirming too soon. Fix 6.
• Words became a date, a number or an error: Sheets read them as a value. Fix 7.
• A list, a menu or a longer word appeared: dropdowns, chips or autocomplete. Fix 8.
• Mic starts then stops at once: microphone busy or Bluetooth. Fix 9.
• Fails in Notes too: iPhone dictation settings. Fix 10.

Google Sheets on iPhone versus Google Sheets on a Mac

On a Mac, you dictate into Sheets with a keyboard shortcut rather than a mic key, and the usual traps are a selected cell with no cursor and browser extensions that get in the way. On iPhone there are no extensions to worry about, but everything runs through the on-screen keyboard, so the first question is always whether the keyboard appeared, and whether it has a mic. The rest is the same on both: a cell is selected before it is open, Return moves you on, and Sheets decides what your words mean once they arrive. Our guide to Mac dictation not working in Google Sheets covers the desktop side. If you also work in Microsoft's spreadsheet on your phone, our guide to iPhone dictation not working in Excel covers the same kind of problems there.

A dictation workflow that suits spreadsheets on a phone

• Give notes their own column, formatted as plain text. Then nothing you dictate gets turned into a date or a formula, and fix 7 never comes up.
• Dictate words, tap figures. A number is quicker to type on the number pad than to say, while a sentence of context is much quicker to say than to type.
• One entry per cell. Double-tap, speak one phrase, check the edit bar, tap the checkmark. Keep "new line" out of it.
• Pick from dropdowns and tick checkboxes by hand. They are built for taps, and it keeps stray punctuation out of your data.
• Read it back before you close the file. A misheard customer name is easy to fix now, and much harder once a formula or a report depends on it.

It is worth getting right, because speaking is much faster than typing. Most adults type around 40 words per minute on a full keyboard, and even professional typists usually sit around 80 to 100, while normal speech runs at 130 to 150 words per minute. On a phone the gap is wider still. That matters in a shared spreadsheet, where the notes column is often the one that gets skipped, and a sentence of context is the difference between a row your team can act on and one that only makes sense to you. Our guide on how to dictate into Google Sheets cells has more on building the habit.

A keyboard with a mic that works in every cell

Apple's dictation is free and built in, but it stops when you pause, it depends on settings that are easy to switch off by accident, and fixing a misheard word means going back into the cell and editing by hand on a small screen.

Voice Keyboard Pro is a custom iPhone keyboard with a built-in mic button for dictation in any iOS app, Google Sheets included. Double-tap a cell, tap the mic, speak, and your words are added at the cursor. Because it is a keyboard rather than a feature of one app, it works the same way in Sheets, Notes, Messages and everywhere else you type. Like any keyboard, it only appears while a cell is open for editing, and Sheets still reads your entry as a date, a number or text once it arrives, so fixes 1 to 4 and 6 to 8 still apply.

A few features help with spreadsheets in particular:

• Voice Edit lets you speak a change to fix text, so you can correct a name or a word in a note without selecting and retyping it.
• Two-way translation while dictating, across 24 languages, lets you speak in one language and write in another, which helps when a shared sheet is kept in a language you do not usually speak.
• Swipe typing is there for the moments when speaking out loud is not practical.

Setup means adding the keyboard in Settings and allowing Full Access so it can reach the transcription service. Our guide to enabling Full Access for an iPhone keyboard explains what that permission does. 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. On a Mac, the same app lives in your menu bar: hold a hotkey, speak, release, and the text appears at your cursor in Google Sheets or anywhere else.

Frequently asked questions

Does Google Sheets have voice typing on iPhone?

Not as a feature of its own. You dictate with the mic on your iPhone keyboard, which types into whichever cell is open for editing, exactly as if you had typed the words.

Why is there no keyboard when I tap a cell?

A single tap only selects the cell. Double-tap it, or select it and tap the edit bar, and the keyboard will appear with its mic. If double-tapping does nothing either, check that the file is open in the Sheets app and that you have edit access.

Why did my dictated note turn into a date or an error?

Sheets reads each entry and converts anything that looks like a date, a number or a formula. Start the entry with a straight apostrophe, or format the column as plain text, and your words will stay exactly as you said them.

Why can I see the spreadsheet but not edit it?

You may have view-only or comment-only access, you may be signed in with a different Google account from the one the file was shared with, or the file may be open in a preview or a browser rather than the Sheets app. Fixes 2 and 3 cover each case.

Does this work the same way on iPad?

Yes. Google Sheets on iPad has the same cells, edit bar and conversion rules, so every fix here applies. The keyboard is larger, but the mic key works the same way.

What to do next

Run the 30-second Notes test, then work through the fixes that match what you saw. For most people it is fix 1: the cell was selected but not open, so there was no keyboard and no mic. If the keyboard never appears however you tap, check fixes 2 and 3. If your words arrived but came out as a date, a number or an error, it is fix 7. And if you want dictation that works the same way in every app on your phone, try Voice Keyboard Pro's free tier on your next spreadsheet.