Is it possible to segment a bilingual Excel file by something other than cells?

Question

I am using Studio 2015 to process a bilingual Excel file. I have my source in column A and the translation in column B. Each cell is a paragraph containing 2 or more sentences. When I add to Trados, my file is segmented by cell, so each of my segments in the Editor view contains the entire paragraph. I'd like to be able to segment by sentence, so that I can add sentenced based TUs to my TM. Is there a way to do this with a bilingual Excel or even a different file type?

Paul · Accepted Answer

Hi Beatriz, 
 
I'm afraid you can't do this with any of the bilingual filetypes. So not Excel or CSV for example. Segmentation is always done on the cell... and I believe this is the same in other tools as well for a bilingual file. 
 
You can do it if the file is treated as monolingual. So a possible solution might be to create two files with only content where you actually had a translation already in the Excel, and create translation memory from it. Then open the Excel as a monolingual file with a copy of the source in the column that should contain the translation, and the original source column hidden. Pre-translate with your TM and you'll be good to go. 
 
If the excel file doesn't contain any translations yet then it's easy... just copy source into the target column, hide the source and translate as a monolingual file. 
 
Regards 
 
Paul

Trados Studio > 1. Trados Studio

Is it possible to segment a bilingual Excel file by something other than cells?