I have a client who has sent me an Excel document. It has various columns from A-H. He wants me to translate only column B only and have it appear alongside in column C (so you can still see the source in column B)
I have not done this before. Can anyone point me to the place in the manual that explains it, or let me know how to do it here.
Make sure that your export column (C) in Excel is empty.
As you choose your Excel file for translation:
1. Select the Filter tab in the Project Configuration panel. You will notice three fields there.
2. Type the name of the import column (B) in the first field (Import source column).
3. Type the name of the export column (C) in the third field (Export column).
Thank you. What is the second field for?
The second field is for the target language Excel column with the segments already existing (e.g. for reviewing the translation).
I think in this case, you will be able to translate your file in two projects:
One - import column A and export column C.
Two - import column B and export column D.
> "The second field is for the target language Excel column with the segments already existing (e.g. for reviewing the translation)." Could you clarify this.
This is the case where both source and target columns are already filled in with source and target segments respectively. Your task would be to review and correct the target (translation).