Problem translating a CSV file in Studio 2014
Thread poster: Olieslagers

French Polynesia
Local time: 10:49
Dutch to French
+ ...
Feb 27, 2014


I just received a new project and I have problems opening it in Studio 2014.
The agency send me an Excel 97-2003 worksheet file. The source language is in column D and target should come in colomn E.

I first saved the file as a CSV.
Then in Studio 2014 I went into options>file types>CSV> and entered :
-Source column = 4
-Target column = 5

I am able to open the file but Studio only "sees" a few segments (3 out of 3285)...Why is that?
I am certainly doing something wrong, but I can't figure it out!

Thanks in advance for your help and suggestions!

[Edited at 2014-02-27 22:08 GMT]


Jorge Payan  Identity Verified
Local time: 15:49
Member (2002)
German to Spanish
+ ...
Why the conversion to CSV.... Feb 28, 2014

if you could translate it directly in Excel format by copying text in source column to target column and then hiding all the columns excepting the target one?

I guess that when you convert to csv, if there are empty cells in column D and/or E, the contiguous commas are being recognized as a single one and making a mess of the tabular structure of the file.


[Edited at 2014-02-28 03:51 GMT]


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

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

Problem translating a CSV file in Studio 2014

Advanced search

SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running, helps experienced users make the most of the powerful features, ensures new

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »

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