Exporting CSV files

memoQ is able to export term base contents into tabular text files called CSV files. Choose a term base to export its contents into a CSV file, invoke the Term base export settings dialog, and configure the CSV file. memoQ tries to set the values automatically, but please check Preview before exporting the term base. If it does not appear correctly, you need to manipulate the settings manually.

 
MemoQ exporting csv Term base export settings

Invoking

You can invoke the Term base export settings dialog from the Term bases pane of the Project home or the Resource console, by selecting the term base you wish to export, and clicking Export to CSV.

Structure

The Term base export settings dialog consists of the File area for specifying the file type of the CSV file, the General area for specifying the file encoding, the delimiter character, whether or not the field names should be written into the first row of the CSV file and other general properties, the Fields area for selecting fields of a term base to be exported into the CSV file, the Preview window for displaying how the first 256 lines of the CSV file would be exported as per the present settings, and a series of buttons.

Use

File area:

· MemoQ ellipsis button Term base export settings: Click this button to browse for the target folder structure. The path of the CSV file will appear in the CSV path field.
· Export as CSV: Click this radio button if you want the selected term base to be imported later into another CAT or terminology tool
· Export as MultiTerm XML: Click this radio button if you want the selected term base to be imported later into MultiTerm, the terminology application of Trados.
 

CSV settings area:

· Encoding: Choose the encoding of the CSV file from this drop-down list. CSV is a text file, and therefore encoding information is not stored in it.
· Write field headers in first row: Check this check box if the first row of the CSV file should contain the names of the fields. The field names will appear in the CSV file as in the Preview window. Uncheck it if you don’t want to export the names of the fields into the first row. If you uncheck it, the field names in the Preview window will disappear.
· Delimiter radio buttons: Select the character memoQ should use to separate table cells from each other within a row:
o Tab: Select this radio button to use tab as delimiter that separates one column from the other in the CSV file.
o Comma: Select this radio button to use comma as delimiter that separates one column from the other in the CSV file.
o Semicolon: Select this radio button to use semicolon as delimiter that separates one column from the other in the CSV file.
o Other: Select this radio button to use a custom character as delimiter that separates one column from the other in the CSV file.
 

Fields area:

Go through every field name listed, and select whether or not they should be exported into the CSV file. By default the check box of each field name is checked. The
checked field names will appear in the CSV file as in the Preview window. If you uncheck a check box, the related column will disappear from the Preview pane.
 

Preview area:

While configuring the export, you can look at the preview that shows how the first 256 lines of the exported CSV file will look.

Navigation

To start exporting the term base contents into the CSV file, click the Export button. After clicking Export, memoQ will display the results of the export. Click Cancel to close the dialog without exporting the term base contents.

Term base export settings