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

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:

1. Copy your source column into the target column in Excel
2. Hide all columns apart from the target column in Excel
3. Translate the file in Studio
4. 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

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:

1. Copy your source column into the target column in Excel
2. Hide all columns apart from the target column in Excel
3. Translate the file in Studio
4. 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