How to create a Bilingual excel sheet after translation is done?

Question

Hi, 
 I usually receive an excel file to work on Trados and I need to create a English-Japanese bilingual excel file for delivery. 
 Below is what I want looks like , but

text_id 
 value 
 Target Language

58### 
 Page changes are now live 
 ページが変更されました

most of the case what I get looks like below;

text_id 
 value 
 Target Language

58### 
 ページが変更されました

Could you kindly advise me what to do and if I give you more information, just let me know. 
 Kind regards, 
 Shihoko Sato

Jerzy Czopik · Answer

The easiest way: use Bilingual Excel file type. 
In Studio 2015, when creating a project, go to File Types BEFORE you add the file. 
Then click on “Additional file types exist”, chose Bilingual Excel, then deactivate or remove the other two Excel file types. 
When done, click the + sign beside the file type name, go to common and set up which column is what. 
 
When finished, simply finalize your project and that was it.

Paul · Answer

Hi Shihoko, 
 
You didn't state what version of Studio you're using? The bilingual excel as Jerzy suggested is the best way to handle this, but if you're using Studio 2014 or earlier you won't have this. So in this case just copy your source language to the target column in Excel, then hide the first two columns. Now you'll just get the source language for translation and when you save the target it'll put it into the third column which is the target. 
 
Regards 
 
Paul

Paul · Answer

Unknown said: what do I set up which column is what on setting page of bilingual excel ? 
 Well, the filetype options say this: 
 
 So just enter the letter that corresponds to the way the columns are set up in Excel. If you only have what you showed it'll probably be B & C... but maybe you didn't show the whole file? Yopu also need to make sure that the Bilingual Excel filetype is above the other Excel filetypes in the list, or disable the others and only use the bilingual version. 
 Regards 
 Paul

Paul · Answer

Hi Shihoko, 
 Based on what you've said you could always save it as xlsx... but if you don't want to do that you could use this approach: 
 
 This would require you downsaving to CSV though and I reckon upsaving to xlsx would be a better bet. 
 If you don't wish to do either of these things then do this: 
 
 Copy your source column into the target column in Excel 
 Hide all columns apart from the target column in Excel 
 Translate the file in Studio 
 Save the target file and unhide the columns 
 
 This works fine unless you already have some translated content in the target column. If you do then you could use Excel to copy source to target unless there is already target there, but it gets messy. I reckon your best bet is to upsave to xlsx. 
 Regards 
 Paul

Trados Studio > 1. Trados Studio

How to create a Bilingual excel sheet after translation is done?