CSV Localization

General

The CSV format is not a well defined standard. There are several variations: field separators, quoting, escaping, encoding and others.

So LingoHub has defined a CSV standard that is suitable for localization and based on RFC4180.

Format

  • encoding should be UTF­-8 (but you can export to other encodings)
  • the markup follows the RFC4180 standard, which means:
    • comma (,) will be used as column separator
    • all values have to be quoted with double ­quotes (“)
    • quotes can be escaped using double double­ quotes, eg.: “Hello, “”LingoHub”””
    • the line ending is always CRLF
    • quoted values can span multiple lines
    • the placeholder syntax is: {placeholder_name}
  • the first line is the header and must have the following columns:
    • “Title” constant
    • “Description” constant (this column is optional)
    • the next columns hold the ISO639-1 code for the languages in the file, eg.: “en”, “pt-BR”

Example

Additional example files can be accessed here.

"Title","Description","en","pl","de"
"settings","General Settings","Settings","Ustawienia","Einstellungen"
"has_placeholders","This example shows the usage of placeholders","Hello {username}","Cześć {username}","Hallo {username}"
"quotes","Quotes in content","Hello ""LingoHub""","Cześć ""LingoHub""","Hallo ""LingoHub"""
"linebreaks","an example for linebreaks","Here is a
linebreak","Oto 
nowa linea","Hier ist ein
Zeilenumbruch"

References



Was this Helpful ?   yes     no Chat with us