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

French Polynesia
Local time: 10:45
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:45
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

CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »

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