Translate one Excel column in bulk with AI in Duaer

Build bulk translation in Duaer

1. Add Form Trigger with one File field labelled Sheet and Accepted File Types .xlsx.
2. Add Extract from File with Extract From XLSX and Input Binary Field Sheet. Each row becomes one item.
3. Add Basic LLM Chain with Duaer Chat Model on Chat Model. Source for Prompt (User Message) Define below, Prompt (User Message): Translate this product name into German. Output only the translation: {{ $json.Name }}.
4. Basic LLM Chain outputs only text. Add Merge with Input 1 from Extract from File and Input 2 from Basic LLM Chain, Mode Combine, Combine By Position.
5. Add Convert to File with Convert to XLSX to export the sheet with the new text column.

Steadier translations

• Fixed terms: list them in the Prompt, such as tumbler = Isolierbecher.
• Drop empty cells with Filter first, and feed Merge Input 1 from after Filter so row counts match.
• Each row is one model call at the model price. Try the Prompt on 20 rows before thousands.