SDL Trados Studio 2014 cannot import numbers in Excel
Thread poster: Dominik Langer

Dominik Langer
Local time: 12:44
English to German
+ ...
Nov 11, 2015

Hello to all,

So I have a file with 2 columns in Excel. Column 1 holds the source text, column 2 length restrictions in simple numbers (i.e. 80, 100, etc.). When I try to import this file in Studio it imports everything as normal, EXCEPT the numbers only segments. It does not matter whether the column in Excel is desiganted as text, number, standard or whatever (probably currency or percentage would work). I find this extremely upsetting and irritating. I guess that Studio will be looking at those segments and simply "process" them in the background, since they are back in the file when I export it again, BUT I would like to a) always see numbers in the Editor anyways, for context and whatever, and b) in this case I actually want to have the numbers below the source segment, so that I don't have to switch between Excel and Studio all the time to check for the length restrictions. I hope I got across why I'm upseticon_smile.gif

Now, when I create a new Excel file and simply enter a number it won't be imported as well, so it's not the file. It's apparently also not something I messed up, because my friends and colleagues have the same "issue", but no one ever noticed, because things like that don't happen on a regularly basis.

However, when I just copy the two columns into Word and create a translation file they ARE imported, just the way I want it to (i.e.
number) in the source column.

Why is that and what can I do to remedy this if it is even possible? I was sure this wasn't always the case. Is there some hidden option with which to disable this "feature" in Studio? I've checked in the file format options, found nothing...

Any help is appreciated, thanks!

Best regards,


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

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

SDL Trados Studio 2014 cannot import numbers in Excel

Advanced search

SDL MultiTerm 2019
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2019 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2019 you can automatically create term lists from your existing documentation to save time.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for users! Save over 13% when purchasing Wordfast Pro through Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »

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