Translating several columns of a CSV file
Thread poster: avsie (X)

avsie (X)  Identity Verified
Local time: 21:15
English to French
+ ...
Aug 22, 2013

Hi everyone,

For starters, I'm using Studio 2011 SP2R 10.4.3079.1 with Microsoft Office 2010.

Most of the questions regarding CSV files are about how to set the filter to recognise one colum as the source and another column as the target, but my problem is different.

I have a CSV file (tab-delimited) with several columns: column 1, column 2, column 3, column 4, column 5 and column 6. Only columns 3, 4 and 6 need to be translated, the rest is just information (like product codes, IDs, URLs, etc.). There are no source and target columns, it's all source, but we don't want to translate all columns.

My first test was to convert to Excel and hide the columns I didn't need. That worked fine, however once I tried to save the Excel as CSV again, it automatically saved as "semi-colon delimited", and that's not what I want. I want a tab-delimited file back. Maybe I just need to know the trick how to save an Excel file as a tab-delimited file, if it's the case, please enlighten me!

But that save as Excel then save as CSV again workaround is a bit annoying, especially since there's one source file per language, and the project is needed in several languages. This is not sustainable in the long run.

Is there a way to tell Studio to recognise several columns as source columns in a tab-delimited file, and none as target columns? I'm usually pretty good at tweaking filters, but this time I'm a bit baffled...

Thanks in advance!



Giulio_T  Identity Verified
Local time: 21:15
English to Italian
A copule of ideas Aug 22, 2013

I tried that too, but I was only able to figure out a sub-optimal method: changing the file's extension to .txt and translating each row as if it was a single translation unit, copying all the source text and changing the parts that require translation.
Don't know if this can help you in any way...

As to tab-delimited files, I don't know about Excel but LibreOffice lets you choose the tab as separator for csv files.



SDL Community  Identity Verified
United Kingdom
Local time: 21:15
Excel is the best way for a file like this Aug 22, 2013

Hi Marie-Claude,

When you have multiple source columns I think CSV is not the easiest way to go, and you were intuitively doing the right thing in the first place. To save the Excel as delimited text just Save-As and then select the Delimited text format from the drop down menu.




Srini Venkataraman
United States
Local time: 14:15
Member (2012)
Tamil to English
+ ...
pl see Aug 22, 2013


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

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

Translating several columns of a CSV file

Advanced search

PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
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 »

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