Follow

Formatting requirements for a CSV memory/glossary file

In order to successfully import a CSV file into Translation Glossary and Translation Memory, the following format must be used exactly.

NOTE: If using a Mac ensure you save the .csv file as a Windows or Text .csv file.

NOTE: Commas in source and translation text are not allowed.

Your file must begin with these 4 column headings in the following order:

source_language,source_text,translation_languages,translation_text

 

Beneath these headings, each entry gets a new row, like so:

source_language,source_text,translation_languages,translation_text
en,Hello,es,Hola

en,Widget Corp, LLC,es,Widget Corp, LLC

 

Multiple translation languages can be specified in a single row using the "|" character in-between languages, like so:

source_language,source_text,translation_languages,translation_text
en,Hello,es,Hola

en,Widget Corp, LLC,es|fr|de|zh-TW,Widget Corp, LLC

 

See the sample.csv file at the bottom of this page.

 

Use the following language abbreviations:

ar Arabic
bg Bulgarian 
zh Chinese (Simplified) 
zh-TW Chinese (Traditional)
cs Czech
da Danish
nl Dutch
en English
en-gb English (British)
fi Finnish
fr French
fr-ca French (Canada)
de German
el Greek
iw Hebrew
hu Hungarian
id Indonesian
it Italian
ja Japanese
ko Korean
ms Malay
no Norwegian
pl Polish
pt Portuguese
pt-br Portuguese (Brazil)
ro Romanian
ru Russian
sr Serbian
sk Slovak
es-la Spanish (Latin America)
es Spanish (Spain)
sv Swedish
tl Tagalog
th Thai
tr Turkish
uk Ukrainian
vi Vietnamese
fa Persian
hi Hindi

 

Comments