Donna
Features How it works Roadmap Pricing FAQ
Download for Mac

Guides / Private On-Device Chat

How do I translate an Excel workbook to German?

Updated 2026-11-14

Give the whole file to a tool that can edit workbooks, name German as the target, and tell it to translate text cells only while leaving numbers, dates, formulas and layout alone. Then open the result in Excel and spot-check headers, dropdown lists and any formula that matches on text. Cell-by-cell options like Google Sheets' GOOGLETRANSLATE work for small ranges, but a whole-file translation is faster for multi-sheet workbooks.

Why a workbook is harder to translate than plain text

Pasting a sheet into a web translator flattens it. You lose the tabs, the structure and the formatting, and you still have to paste everything back cell by cell. A real workbook translation means touching only the text and leaving numbers, dates, formulas and layout exactly where they were.

There are three common routes:

  • GOOGLETRANSLATE in Google Sheets: one formula per cell, handy for a small range, awkward for a workbook with many tabs.
  • Excel's Translate option on the Review tab (in versions that include it): translates the text you have selected, one selection at a time.
  • A chat that takes the whole file: you describe the job once and get a translated workbook back.

The third route is the one this guide walks through.

Translate a whole workbook with Donna's on-device chat

Donna's chat is a private AI that runs locally on your Mac. Attach an Excel file and she reads and edits it on-device, then hands back a file in the same format. That means you get an Excel workbook, not a wall of pasted text. Translating a whole workbook is one of the jobs the chat is built for, and it is on the free plan, with no card and no trial.

Step by step

  • Install Donna from the download page on a Mac running macOS 13 (Ventura) or later.
  • Open Donna's chat and attach your Excel workbook.
  • Tell her the target language and the rules you want followed (a starter prompt is below).
  • When the reply arrives, open the returned Excel file and look it over.
  • Ask for changes in the same chat, such as 'use du instead of Sie' or 'keep the product names in English'.

If the workbook is big, start with a single sheet. You can judge tone and terminology on one tab before you commit to translating all of them.

A prompt to start from

Be specific. Something like this gives the chat clear rules:

'Translate every text cell in this workbook from English to German. Leave numbers, dates, formulas and sheet names as they are. Use the formal Sie. Keep product names and abbreviations in English. Give me back an Excel file.'

Why each part matters:

  • Source and target language: name both, so nothing is guessed.
  • Leave numbers, dates and formulas alone: Excel shows function names in the language of the installed version (VLOOKUP appears as SVERWEIS in German Excel), so formulas never need translating.
  • Sheet names: decide up front. If a formula or another file refers to a tab by its name, leave the tab names in the original language.
  • Tone: German splits formal Sie from informal du. Pick one, especially for instructions and customer-facing text.
  • A short glossary: a handful of preferred terms (for example, how 'pipeline' or 'headcount' should read in German) keeps the vocabulary consistent across sheets.

What to check in the German file

A translated workbook can look right and still behave differently. Check these before you send it on:

  • Lookup keys and dropdown lists: if a formula matches on text like 'Open' or 'Paid', or a dropdown offers a fixed list, translating one side but not the other breaks the match. Make sure both sides agree.
  • Column widths: German words tend to run longer than English ones, so headers and labels may be cut off. Widen the columns where needed.
  • Totals: compare a few sums and averages against the original to confirm nothing numeric changed.
  • Numbers and dates: decimal separators and date order follow the settings of whoever opens the file, so there is nothing to translate there.
  • The German itself: machine translation usually reads well, but have a German speaker review anything contractual, legal or customer-facing.

When this is and is not the right approach

It fits best when the workbook is something you would rather not paste into a web translator: budgets, HR sheets, client lists. The chat runs locally and files are read and edited on-device. For a single cell or a short column, Excel's own Translate option is quicker.

Donna runs on macOS 13 or later only. Windows is coming soon. A chat can optionally be switched to Claude for a bigger model, which may help with a large or specialised workbook. The on-device description applies to the default local chat, so read the Privacy Policy before you switch a sensitive file.

The same chat takes Word, PowerPoint and PDF files too. For more on how it works, see how to use a private AI chat that runs locally on your Mac, or how to redact a PDF with AI without uploading it.

Try Donna. Records, transcribes and summarizes your meetings on your Mac, with nothing sent to a server.

Download Donna for Mac

Frequently asked questions

Will I get an Excel file back, or just translated text?

You get a file back in the same format you attached, so an Excel workbook you can open straight away. Check the formatting and column widths once it opens.

Does translating a workbook cost anything?

No. The on-device chat is part of the free plan, which has no card, no trial and no expiry. Pro is only needed for the meeting recording features, and you can see the plans on the pricing page.

Is my workbook uploaded anywhere?

The chat runs locally and reads and edits your file on the Mac. If you switch a chat to Claude for a bigger model, treat that as a different setup and check the Privacy Policy first.

What if the translation gets my industry terms wrong?

Put a short glossary in the prompt, or tell the chat which terms to keep in English, then ask it to redo the file. For anything legal or customer-facing, still have a German speaker read it.

Can I translate a Word or PowerPoint file the same way?

You can attach Word, PowerPoint and PDF files in the same way as Excel. Donna reads and edits them on-device and hands back a file in the same format.

Related guides

  • How do I translate a Word document to French on a Mac?
  • How do I use a private AI chat that runs locally on my Mac?
  • How do I rewrite a PowerPoint deck with AI on my Mac?
  • How do I redact a PDF with AI on my Mac without uploading it?
  • What is the keyboard shortcut to copy a Google Meet link?
  • How do I open Microsoft Teams meetings automatically on a Mac?
Donna

The Mac assistant that opens your meetings, records and transcribes every call on-device, and keeps your whole day on track.

Product

  • Features
  • How it works
  • Roadmap
  • Pricing

Get Donna

  • Download for Mac
  • Integrations
  • FAQ

Company

  • Privacy
  • Terms
  • Contact
© 2026 Donna. Made for people with too many meetings.Designed in the menu bar.