If you need to translate text while working in Google Sheets (often called Google Calc), there is a super easy built-in way to do it without external add-ons.

Google includes the native GOOGLETRANSLATE formula.

Here is an example translating text directly:

=GOOGLETRANSLATE("Hello","en","es")

If you want to autodetect the source language, use "auto":

=GOOGLETRANSLATE("Hello","auto","es")

And to load the source content directly from a cell (e.g. F12):

=GOOGLETRANSLATE(F12,"auto","es")