Translate an Excel File into Russian with Formulas Intact

What Russian changes in a spreadsheet

Russian is written in Cyrillic, left to right, and runs longer than English. Short headers suffer most: Qty becomes Количество, which Russian spreadsheets often shorten to Кол-во. In Excel this has three practical effects.

• Fonts. Calibri, Arial and Times New Roman include Cyrillic letters. A brand or decorative typeface that does not will show empty boxes instead of Russian text, or Excel will substitute another font and your headers will look different.
• Plurals. Russian has four plural categories (one, few, many, other): 1 товар, 2 товара, 5 товаров. A full sentence typed in a cell is translated with the right agreement; a sentence built by a formula, such as =A2&" items", cannot agree with the number.
• Conventions. Russia uses a decimal comma, a space as thousands separator (1 250,50), dates as 31.12.2024, and the rouble as ₽ or руб. Common abbreviations end with a full stop: шт. for pieces, тыс. for thousands.

Business documents use the formal вы; instructions on a form use the polite imperative, for example Введите дату (enter the date).

What Manuce returns, and what it leaves alone

Manuce translates the text cells on every sheet of the workbook and returns your original .xlsx with the Russian text in place. Column widths, colours, borders, number formats, filters and merged cells are kept. You also receive a Word version, a PDF and the plain text, which are handy if a Russian-speaking reviewer does not use Excel.

Formulas are not modified: a calculated cell keeps its formula and keeps calculating. Numbers, dates and amounts stay as they are, so a total in pounds, dollars or euros is not converted into roubles.

Not translated:

• sheet tab names: a tab called Sales stays Sales, which keeps references such as 'Sales'!B2 working; if you rename it Продажи in Excel, formulas in the workbook follow;
• cell comments;
• charts, and shapes or text boxes placed on the sheet;
• column widths: a narrow column is not widened, so a longer Russian header may be cut off on screen, just as it would have been in the original.

Manuce does not produce sworn or certified translations. If a Russian authority requires a certified translation of accounts or statements, you will need a sworn translator.

The trap: formulas that contain text

Because formulas are left untouched, any text written inside quotation marks in a formula stays in the source language, while the cells it is compared with become Russian. Example: =IF(C2="Paid",D2,0). After translation, C2 reads Оплачено, the condition is false and the column shows 0 throughout. The same applies to =COUNTIF(B:B,"London") once column B reads Лондон.

Two ways to avoid it:

• Before uploading, replace the text in the formula with a cell reference, for instance =IF(C2=$H$1,D2,0) with Paid in H1. H1 is translated along with everything else, so the comparison still holds.
• After delivery, search the formulas for quotation marks and replace each word with the Russian term exactly as it appears in the translated cells, letter for letter, including ё versus е.

Concatenations such as ="Total: "&E2 need the same treatment; while you are there, write Итого: and check how the noun after a number agrees.

Preparing the workbook and checking the result

Before you upload:

• switch any font without Cyrillic glyphs to one that has them;
• delete obsolete sheets, since the quote is based on the exact word count of the workbook;
• find formulas containing quoted text, as described above;
• read the free sample, one paragraph translated at the level you choose, to judge how your headers are rendered before paying.

Russian is a surcharge language (×1.25 coefficient on the per-word rate).

On delivery:

• scan the headers: where Количество or Сумма без НДС (amount excluding VAT) is cut off, widen the column or turn on text wrapping;
• re-sort any column that was in alphabetical order, as Cyrillic order differs from Latin;
• rename the tabs and redo chart titles, comments and text boxes by hand;
• if possible, open the file with Russian regional settings: standard date formats then display as dd.mm.yyyy, but a custom format with fixed text, such as 0" pcs", stays as it is because formats are preserved.

In practice

1. Replace fonts without Cyrillic and spot formulas that contain quoted text.
2. Upload the .xlsx: the quote appears at once, based on the exact word count.
3. Read the free sample translated into Russian, then choose your level.
4. Download the translated workbook with its Word version, PDF and plain text.
5. Widen narrow columns, rename the tabs and redo chart titles.