Guides

Dictation in Google Sheets on a Mac: cells, numbers, comments, and what to type instead

By · Published · Updated

To dictate into Google Sheets on a Mac, double-click a cell so a text cursor blinks, start Apple Dictation or YapToText, talk, and press Enter. Google's Voice typing is documented for Google Docs and for speaker notes in Google Slides, and Google's help page for it does not list Sheets, so in a spreadsheet the ways that work are the ones that type into any app.

Apple Dictation is free and built into macOS. YapToText, the free app I built, types at the cursor in your browser, keeps your voice on your Mac, can press Return for you after each value, and writes spoken numbers as digits when you ask. I built it because my hands make typing difficult, and I dictate with it every day. The one thing I would not dictate is a formula, and the section on numbers, dates and formulas explains why.

Download YapToText on the Mac App StoreDownload for free. No account, nothing locked, macOS 14 or later on Apple silicon. Source on GitHub.

On this page: 11 sections
  1. Steps
  2. Whether Google Sheets has voice typing
  3. Put a text cursor in the cell first
    1. Step 1: Start editing the cell
    2. Step 2: Dictate the value
    3. Step 3: Finish the entry
  4. Use Apple Dictation in a cell
    1. Turn it on once
    2. Dictate into the cell
  5. Use YapToText in Sheets, free and on device
    1. Step 1: Click into the cell
    2. Step 2: Tap Right Command and talk
    3. Step 3: Tap it again
    4. Let YapToText press Return for you
  6. Numbers, dates and formulas
    1. Type the formulas
  7. Dictate comments and notes
  8. If dictation is not working in Sheets
    1. If YapToText's words do not land in Sheets
  9. What each one cannot do
  10. The short version
  11. Questions

Steps

  1. Double-click the cell in Google Sheets so a text cursor blinks.
  2. Press your Dictation shortcut to start Apple Dictation, or tap Right Command to start YapToText.
  3. Say the value. With YapToText, press 3 while you talk for Clean Up if it is a number.
  4. Stop dictating with the same key, and check the words in the cell.
  5. Press Enter to finish the entry.

Whether Google Sheets has voice typing

Google's help page for Voice typing, Type and edit with your voice, describes it in Google Docs, where you click Tools, then Voice typing, and in Google Slides, for speaker notes and captions. It works in the latest Chrome, Edge and Safari, and its voice commands are English only. Google Sheets is not among the apps that page describes. Google documents Voice typing for Docs and Slides, not for Sheets.

That is what Google's page says, not a promise about every account. If your Sheets shows Voice typing in the Tools menu, trust your screen over this page, and open an issue on GitHub so I can fix it. For a long block of text, one workaround is to dictate it in a Doc with Voice typing and paste it into the cell. The guide to dictation in Google Docs covers Voice typing step by step, and Google voice typing on a Mac covers what else Google offers.

So in Sheets, the two ways that work are the two that work in every app: Apple Dictation and YapToText. Both type at a text cursor, and in a spreadsheet that takes one extra step.

Put a text cursor in the cell first

A selected cell has a border around it, not a blinking cursor, and dictation types at a cursor. Google's Edit and format page says to click a cell that is empty, or double-click a cell that is not, then start typing, and press Enter when you have finished. Double-click the cell, see the cursor, then talk.

Step 1: Start editing the cell

  • You: Double-click the cell, empty or not.
  • Check: A text cursor blinks inside the cell, not just a border around it.

Step 2: Dictate the value

  • You: Start Apple Dictation or YapToText, as below, and say the text or the number.
  • Check: The words appear in the cell.

Step 3: Finish the entry

  • You: Press Return, the key Google's pages call Enter.
  • Check: The value sits in the cell and Sheets moves on. Double-click the next cell to go again.

Google's Edit and format page says to press Command Enter on a Mac to add another line within a cell. I have not tested what a spoken new line does inside a Sheets cell, so for a second line, press Command Enter yourself. Google says you can also click an empty cell and just start typing, but I have not tested YapToText's paste into a cell that is only selected, so start editing first.

Use Apple Dictation in a cell

Apple Dictation is free and already on your Mac. Apple's guide says it works anywhere you can type, so a cell you are editing works like any other text field, in any browser, with no Google setting involved. Apple Dictation is free and fine for a label or a short note in a cell.

Turn it on once

  • You: Choose Apple menu, System Settings, then Keyboard. Go to Dictation, turn it on, and click Enable.
  • macOS: May ask whether to share audio recordings to improve Siri and Dictation. Not Now is a fine answer.
  • Check: Dictation stays on. Note the key in the Shortcut menu, because that is what you will press in Sheets.

Dictate into the cell

  • You: Double-click the cell. Press the Microphone key if your keyboard has one, or your Dictation shortcut.
  • macOS: Highlights the cursor and makes it pulse, or plays a tone, when it is ready.
  • Check: Words appear as you speak. Press the Microphone key or the shortcut again to stop, then Enter.

Three things matter more in a cell than in a document. In supported languages Apple adds commas, periods and question marks as you go, so look for a period at the end of a short value; Apple says you can turn Auto-punctuation off under Dictation in Keyboard settings. Dictation stops by itself after 30 seconds without speech, which is fine for one cell, and the 30-second limit page explains it. And your voice may be processed on the Mac or sent to Siri servers: the text below Dictation in Keyboard settings tells you which.

Use YapToText in Sheets, free and on device

YapToText is the free Mac app I built for dictating into every app, and to it, Sheets is a text box in your browser. It runs Whisper on your Mac and puts the words at the cursor, with no account and no subscription, and it does not care which browser you use. It needs an Apple silicon Mac with macOS 14 or later, and it is free on the Mac App Store. Edit the cell, tap, talk, tap, and the value lands where the cursor was.

Step 1: Click into the cell

  • You: Double-click the cell.
  • YapToText: Nothing yet. It types into the app in front, never into its own window.
  • Check: A text cursor is blinking in the cell, not in the browser's address bar.

Step 2: Tap Right Command and talk

  • You: Tap Right Command once and say the value.
  • YapToText: Opens the floating panel with your voice as a wave and your words as they form.
  • Check: The wave moves when you speak. If it stays flat, the app is not hearing your microphone yet.

Step 3: Tap it again

  • You: Tap Right Command again.
  • YapToText: Finishes the transcript on your Mac, pastes it at the cursor and puts back whatever you had copied before.
  • Check: The words are in the cell. Press Enter to finish the entry. If they went to the clipboard instead, Accessibility is not on yet; the fixes below cover it.
YapToText's floating dictation panel on a Mac: a live waveform, the sentence being typed, and cancel, pause and stop buttons.
Figure 1. The words form in the panel while you talk, and land in the Sheets cell when you tap the key again.

Let YapToText press Return for you

YapToText can press Return the moment your words land: in Settings, Advanced, Text output, under After a dictation lands, choose Add App, pick your browser while it is open, and leave it on Press Return. The catch is that Sheets is not an app to your Mac; your browser is. So the setting fires in every tab, Gmail and Docs included, after every dictation. Turn Press Return on for a session of data entry, and off again when you finish.

It presses the key without a second look, so a misheard value goes into the cell too. I have not tested this loop end to end in Sheets, so try it on a scratch sheet first.

  • Intelligent Insert. It reads the words around the cursor with a few invisible keystrokes so a dictation fits the sentence it lands in, and the 1.5.2 release made it more reliable in Gmail, chat pages and Electron apps. If your browser beeps when a value lands, turn it off for that browser, as the fixes below describe. The Intelligent Insert guide explains the keystrokes.
  • No lean in a browser. Auto mode gives a browser no special lean, so ordinary prose gets a conservative pass that fixes what was misheard and rewrites nothing.
  • Long text, no clock. A notes or description column is where dictation saves the most typing. A dictation runs until you tap the key again; only a safety stop at 30 minutes ends one on its own.
  • Names spelled your way. Product names and project codes are where speech models stumble. Dictionaries turn a phrase you say into the exact spelling you want.
  • A safety net. By default History keeps your last 500 dictations and deletes anything older than 30 days, so a value that landed in the wrong cell can be copied or inserted again.

Numbers, dates and formulas

Numbers are where a spreadsheet differs from a document. YapToText's Clean Up mode turns spoken numbers into digits without adding units you did not say. For a number, press 3 while you talk, and Clean Up writes it as digits.

The catch is length. Auto mode, on by default, leaves a dictation of six words or fewer exactly as spoken, and most cell values are shorter than that, so a lone number under Auto comes out however Whisper wrote it. Pressing 3, Clean Up's number in the default order, sends that one dictation through Clean Up.

Say: In a cell you are editing, after pressing 3 for Clean Up while you talk.

twelve hundred and fifty

What happens: Clean Up writes the number in digits, with no currency sign or unit you did not say.

YapToText's Switch Mode list: Auto, Raw Transcription, Clean Up, Note, Email, Message and Code Comment, numbered 1 to 7.
Figure 2. In the default order Clean Up is number 3, so pressing 3 while you talk sends that one value through Clean Up.
  • For a currency sign. Say it. Dollar sign is a two-word name, so "dollar sign 50" gives $50.
  • For exactly what you said. Press 2 for Raw Transcription, which is literal speech to text with basic punctuation and no AI.
  • With Apple Dictation. Apple's commands list says numeral formats the next phrase as a number.
  • For today's date. In YapToText, say insert today's date, a built-in command on the Commands page, and check how the cell reads it.

Dates and currency are where Sheets has its own say. Google's page on formatting numbers says you select the cells and click Format, then Number, to set how numbers, dates and currency look, and Google says a spreadsheet's locale changes its default currency, date and number formatting. So dictate the date the way you would type it, then check the cell before you build on it. Read numbers back too: Whisper can mishear a number like any other word, and a wrong digit in a column is harder to spot than a wrong word in a sentence.

Type the formulas

Google's page on formulas says you type an equals sign in a cell, then the function you want, and Sheets may suggest formulas and ranges and shows a help box with the function's syntax as you go. That is a keyboard workflow. YapToText does have spoken names for the marks: equals sign and plus sign are two-word names, and one-word names such as asterisk need insert in front, as in "insert asterisk". But any misheard letter breaks a reference, and the cleanup modes rewrite sentences, not syntax. I have not tested dictating formulas, and I would not. Say the prose, type the syntax.

  • Say these. Column headings, labels, comments, notes and descriptions.
  • Type these. Formulas, cell references, function names and anything Sheets will calculate from.
  • Numbers. Either, as long as you read them back.

The modes guide covers Clean Up, and the spoken punctuation guide lists every name YapToText understands.

Dictate comments and notes

Sheets has two kinds of text attached to a cell. Comments are for discussion: Google's comments page says to highlight the cell, click Add comment in the toolbar, type your comment and click Comment, and you can mention someone by typing @ and their name. Notes are plain text on the cell, and Google's Sheets shortcuts list Shift F2 to insert or edit one. A comment box is a text box, so dictate into it the way you would type into it.

  • You: Select the cell and click Add comment, or press Command Option M, which Google's shortcuts list for inserting a comment on a Mac. With the cursor in the box, start Apple Dictation or tap Right Command.
  • Check: The words land in the comment box. Click Comment to post it.

A note works the same way: press Shift F2, check that the cursor is in the note, and dictate. Two cautions. An @ mention is something to type, because Sheets suggests names as you type and you click the one you mean. And I have not tested YapToText in a Sheets comment or note specifically, so check the first one before you dictate a dozen. If you turned on Press Return for your browser, turn it off first, so it does not fire inside the box.

If dictation is not working in Sheets

Most trouble in Sheets comes from the grid, not the microphone. If nothing types, check for a blinking cursor before anything else. Climb this ladder, smallest step first:

  1. No Voice typing in Sheets. That matches Google's help page, which describes it for Docs and Slides. Use Apple Dictation or YapToText instead of hunting for it.
  2. Nothing types. The cell is selected but not being edited. Double-click it, then start again.
  3. A period at the end of a value. Both Apple Dictation and Whisper punctuate as they go. Delete it before you press Enter, or turn off Auto-punctuation for Apple Dictation in Keyboard settings.
  4. A number came out as words. With YapToText, press 3 for Clean Up while you talk. With Apple Dictation, say numeral first.
  5. A date looks wrong. Check Format, then Number, and the spreadsheet's locale.
  6. Apple Dictation does nothing. Apple's checklist: Dictation on in Keyboard settings, the right language and region, the right shortcut, then the microphone under Microphone source. When Voice Control is on, standard Dictation is not available. The Mac dictation not working guide goes through each fix.

If YapToText's words do not land in Sheets

  1. If the words go to the clipboard. On YapToText's Home page, press Grant next to Accessibility and switch the app on in System Settings, Privacy & Security, Accessibility. Without it, every dictation is copied to the clipboard instead of typed.
  2. If your browser beeps. Intelligent Insert's invisible keystrokes can trigger the alert sound. On the Dictation page, in the Delivery card, choose Turn off in another app and pick your browser, or lower Alert volume in System Settings, Sound.
  3. If pasting misbehaves. In Settings, Advanced, choose Add App Override under Per-app method, pick your browser and keep Type character-by-character.
YapToText's Dictation settings page on a Mac: the Keys, Recording, Microphone and Delivery cards.
Figure 3. The Delivery card at the bottom of the Dictation page holds Intelligent Insert and the list of apps where it is off, which is where your browser goes if it beeps in Sheets.

The guide to dictation in a browser and the troubleshooting guide cover the rest.

What each one cannot do

  • Google's Voice typing. Google's help page describes it for Docs and for Slides speaker notes and captions, not for Sheets, and its voice commands are English only.
  • Apple Dictation. It stops after 30 seconds of silence, adds punctuation you may not want in a cell unless you turn Auto-punctuation off, and whether your voice leaves the Mac depends on what Keyboard settings says.
  • YapToText. It has no Sheets commands: it does not move between cells, select ranges or build formulas. It types at the cursor, and After a dictation lands can press Return for you, in the whole browser. It needs an Apple silicon Mac with macOS 14 or later, and nothing is claimed for Intel Macs.

If your spreadsheets live in Excel or Numbers instead, the guides to dictation in Excel on a Mac and dictation in Numbers on a Mac cover what is different there.

The short version

  • Voice typing. Google documents it for Docs and Slides, not Sheets.
  • A cursor first. Double-click the cell, dictate, then press Enter.
  • Numbers. With YapToText, press 3 for Clean Up and they come out as digits; read them back.
  • Formulas. Type them; dictate the labels, comments and notes around them.

In Sheets, dictate the words and the values, and type the syntax.

If something here does not match what you see in Sheets, open an issue on GitHub. Every one gets read.

Download YapToText on the Mac App StoreDownload for free. No account, nothing locked, macOS 14 or later on Apple silicon. Source on GitHub.

About the author. Ryleigh Newman is a developer whose hands make typing difficult and who dictates every day with YapToText, the app this site describes. Facts about other apps come from their own sites, with the date they were read. More about the project.

Sources

Questions

Does Google Sheets have voice typing?

Google's Voice typing help page describes it in Google Docs and in Google Slides speaker notes and captions, and does not list Sheets. Apple Dictation and YapToText both type into Sheets cells on a Mac for free.

How do I dictate into a Google Sheets cell on a Mac?

Double-click the cell so a text cursor blinks. Start Apple Dictation with your Dictation shortcut, or tap Right Command with YapToText, say the value, then press Enter.

Can I dictate numbers into Google Sheets?

Yes. With YapToText, press 3 for Clean Up while you talk, and spoken numbers come out as digits. With Apple Dictation, say numeral before the number. Read numbers back either way.

Can you dictate formulas in Google Sheets?

You can say some symbols by name, but a formula is mostly symbols, cell references and function names, and one misheard letter breaks it. Type the formula and dictate the labels and notes around it.

Can I dictate a comment in Google Sheets?

Yes. Select the cell, click Add comment or press Command Option M, and dictate into the comment box with Apple Dictation or YapToText. Type any @ mention, then click Comment.

Why does dictation not type into my Google Sheets cell?

The cell is probably selected but not being edited. Double-click it so a cursor blinks, then start dictating again.