Creating a dictionary with Microsoft Excel

  1. Open Excel.
  2. Create a two-column sheet with source terms in the first column and the corresponding targets in the second.
    If you want to allow multiple target terms for one source entry, add an extra row for each target term.
    SQL statement SQL-instructie
    Application Toepassing
    Not supplied Niet meegeleverd
    Not supplied Niet inbegrepen
  3. Select the source and target columns, selecting the source column first and the target column second.
  4. In QA Distiller, do one of the following to open the Dictionary import tool:
    • Click Settings > Dictionary settings > Create dictionary.
    • Press CTRL + F8.
  5. Do one of the following:
    • On the menu bar, click Import > List open excel files.
    • Press F2.
  6. Select the Excel file that contains the terminology.
    If you selected the correct document, there is a message in blue at the top of the dialog box: Selection OK, you can now import.
  7. Do one of the following:
    • On the menu bar, click Import > Import.
    • Press F5.
    The contents of the terminology list are displayed in a newly opened window, where you can edit the source and target cells, disregard terminology by changing the value 1 into a 0 in the Accept column, and add any comment that you want in the Comment column.
    • The comments that you enter are just for reference and are not stored or displayed anywhere else.
    • If you do not want to edit anything in the terminology list, you can click Import > Quick import and save, which allows you to save the DICT file immediately to the location of your choice.

  8. Click Close and, on the menu bar, click File > Save or File > Save as.
  9. Click Save.
The Dictionary import tool creates a text file containing a header, the language codes, and the terms separated by a pipe symbol.