CSV Files

Many programs support CSV file format.

Translation lists can be exported in CSV format for processing in Microsoft Access or Microsoft Excel, for example. This interface can be configured so that the strings can be reimported after processing.

To export translation lists in the CSV file format, choose the lists to be exported and as Export-Format Customizable Text Export. Click on the Settings button to configure the export.

Encoding

Select in the drop down box Encoding, whether the strings shall be stored as ASCII- or Unicode characters. Unicode character can also be stored in "Big Endian" format. Use Unicode if you want to export strings in Asian languages or if you want to export translation lists that use different Codepages for source and target language.

Separator

Select in the drop down box Separator which character is to be used to separate the data fields. If you use comma or semicolon as separator, text resources will be enclosed with ("). If you choose tabulator as separator, these text delimiters will not be used. Use comma or semicolon as the separator if you want to export data to Microsoft Access, Microsoft Excel or other editors and later want to re-import the changed string resources to Passolo. Choose tabulator as separator, if you want to export in Passolo glossary format for example.

Write strings that are already exported

If you activate this check box, strings that are already translated will be exported.

Write strings that are not translated

If you activate this check box, strings that are not yet translated will be exported. If you also activate the check box Write strings that are already exported, all strings will be exported.

File will be reimported in Passolo

If you activate this check box, the file format will be adapted so that the strings can be reimported. In any case the export file must contain a header line and the ID as the first column. The necessary changes are carried out automatically.

Add a header line

If you activate this check box a header line describing the data fields will be written to the first line of the export file. This information can for example be used by Microsoft Access to assign the names of the database fields automatically.

Column header for languages

You can choose, whether the numeric language ID or the language code shall be used in the header line for the source and target language.

Column Selection

The list Columns in File shows all data fields which the export file shall contain. To add a data field, select the corresponding entry in the list of Available Columns and click << Add. To delete a data field from the list, select the entry in the list of Columns in File and click Remove >>.

The order of the data fields in the list Columns in File determines the order in data will be written in the export file. You can change the order of the data fields by selecting a data field in the list and pressing Move up or Move down to move its position.

If you have activated the option File will be reimported in Passolo, you can import the translation lists after external processing again. You don't need to carry out any further adjustings when importing. Passolo can determine the format of the export file and assign the file to the right translation list automatically.