Open Excel file in Trados Studio with Cell settings
Thread poster: Ahmed Maher

Ahmed Maher  Identity Verified
Local time: 09:39
English to Arabic
+ ...
May 26, 2014

Hi all,

I have Excel file with 2000 cell. It is one column and 2000 rows. I want to open it in Trados Studio, so that I have only 2000 segments.
In my file, every cell contains more than one sentence separated by fullstops. As you know, Trados consider every single sentence as one segment.

I have tried with Files Types settings, but can not see such option available for Excel 2007.

Thanks very much in advance.


SDL Community  Identity Verified
United Kingdom
Local time: 09:39
Easy enough :-) May 26, 2014

Hi Ahmed,

Just change the segmentation on your TM to be used for paragraph based segmentation instead. With an excel file each cell is considered to a paragraph. So if you segment based on paragraph instead of sentence then you'll see the desired result.

You can find this ins Translation Memories -> Settings -> Language Resources -> Segmentation Rules. It's just a check box:




Ahmed Maher  Identity Verified
Local time: 09:39
English to Arabic
+ ...
Thanks a million May 26, 2014


For prompt reply, clear instructions, professionalism, and kindness, I shall say "Bravo 100%".

Thanks very much.



To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Open Excel file in Trados Studio with Cell settings

Advanced search

Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search