1. Go to File > Options > File Types > untick all the Excel file types except for the Bilingual Excel
2. Go to Bilingual Excel > Common > type in the letters that correspond to the Source Column and Translation Column in your document, and leave the option First line is column heading ticked if it applies to your document, or untick it if it doesn't
3. Open your Excel file from the Welcome view in Studio and choose the option of translating it as single document, which will process the spreadsheet as a bilingual file, thus your target segments will be already populated
4. Confirm all segments
5. Add or create a TM
6. Batch Tasks > Update Main Translation Memories |
