When to Use Batch Translation
Batch translation is ideal when you have product listings, survey responses, CRM data, or any structured content in a spreadsheet that needs to be translated into one or more languages. Instead of copying and pasting each cell, process hundreds or thousands of entries at once.
Setting Up Your Sheet
Organize your data so that source text is in a single column. Leave adjacent columns empty for the translated output. For example, place English text in column A and leave column B free for the Spanish translation.
Selecting a Range
Open the Multi Translate Pro sidebar from Extensions > Multi Translate Pro > Open. Select the cells you want to translate. The sidebar shows the number of cells selected and an estimated credit cost.
Choosing Languages and Engine
Set your source and target languages. For multi-language output, run the batch once per target language, placing results in separate columns (e.g., column B for Spanish, column C for French, column D for German).
Running the Batch
Click Translate Selection. The add-on processes cells in parallel and fills the output column with translations. A progress bar shows completion percentage. Large batches (1,000+ cells) may take a few minutes depending on the engine.
Tips for Large Batches
- Break into chunks — For sheets with 5,000+ rows, translate in batches of 1,000 to avoid timeout issues.
- Use a glossary — Apply a glossary to maintain consistent terminology across all rows.
- Check credit balance first — Estimate costs by multiplying average cell character count by the number of cells.
- Review samples — Spot-check 5-10 rows after each batch to verify quality before continuing.
Exporting Results
Once translation is complete, you can download the sheet as XLSX or CSV for use in other systems. The translated columns preserve formatting and cell references from the original sheet.