csv2po

Convert between CSV (Comma Separated Value) files and the PO format. This is useful for those translators who can only use a Spreadsheet, a modern spreadsheet can open CSV files for editing. It is also useful if you have other data such as translation memory in CSV format and you wish to use it with your PO translations.

If you are starting out with your own CSV files (not created by po2csv), take note of the assumptions of the column layout explained below.

Usage

csv2po [options] <csv> <po>
po2csv [options] <po> <csv>

Where:

<csv>

is a file or directory containing CSV files

<po>

is a file or directory containing PO files

Options (csv2po):

--version

show program’s version number and exit

-h, --help

show this help message and exit

--manpage

output a manpage based on the help

--progress=PROGRESS

show progress as: dots, none, bar, names, verbose

--errorlevel=ERRORLEVEL

show errorlevel as: none, message, exception, traceback

-i INPUT, --input=INPUT

read from INPUT in csv format

-x EXCLUDE, --exclude=EXCLUDE

exclude names matching EXCLUDE from input paths

-o OUTPUT, --output=OUTPUT

write to OUTPUT in po, pot formats

-t TEMPLATE, --template=TEMPLATE

read from TEMPLATE in po, pot, pot formats

-S, --timestamp

skip conversion if the output file has newer timestamp

-P, --pot

output PO Templates (.pot) rather than PO files (.po)

--charset=CHARSET

set charset to decode from csv files

--columnorder=COLUMNORDER

specify the order and position of columns (location,source,target)

--duplicates=DUPLICATESTYLE

what to do with duplicate strings (identical source text): merge, msgctxt (default: ‘msgctxt’)

Options (po2csv):

--version

show program’s version number and exit

-h, --help

show this help message and exit

--manpage

output a manpage based on the help

--progress=PROGRESS

show progress as: dots, none, bar, names, verbose

--errorlevel=ERRORLEVEL

show errorlevel as: none, message, exception, traceback

-i INPUT, --input=INPUT

read from INPUT in po, pot formats

-x EXCLUDE, --exclude=EXCLUDE

exclude names matching EXCLUDE from input paths

-o OUTPUT, --output=OUTPUT

write to OUTPUT in csv format

-S, --timestamp

skip conversion if the output file has newer timestamp

--columnorder=COLUMNORDER

specify the order and position of columns (location,source,target)

CSV file layout

The resultant CSV file has the following layout

Column

Data

Description

A

Location

All the PO #: location comments. These are needed to reconstruct or merge the CSV back into the PO file

B

Source Language

The msgid or source string

C

Target Language

The msgstr or target language

The layout can be customized by --columnorder, you can add, or remove columns using that as well, for example --columnorder=context,source,target.

Examples

These examples demonstrate the use of csv2po:

po2csv -P pot csv

We use the -P option to recognise POT files found in pot and convert them to CSV files placed in csv:

csv2po csv po

Convert CSV files in csv to PO files placed in po:

csv2po --charset=windows-1250 -t pot csv po

User working on Windows will often return files encoded in everything but Unicode. In this case we convert CSV files found in csv from windows-1250 to UTF-8 and place the correctly encoded files in po. We use the templates found in pot to ensure that we preserve formatting and other data. Note that UTF-8 is the only available destination encoding.

csv2po --columnorder=location,target,source fr.csv fr.po

In case the CSV file has the columns in a different order you may use --columnorder.

Bugs

  • Translation comments #[space] and KDE comments _: are not available in CSV mode which effects the translators effectiveness

  • Locations #: that are not conformant to PO (i.e. have spaces) will get messed up by PO tools.