Multilingual Excel and delimited text files

The settings are a bit different for Excel files and for CSV or tab-separated files. In the Base format tab, you can choose: Excel or Comma or tab-separated.

If you translate into one target language only: Check the Simple bilingual configuration check box. Normally, memoQ uses the multilingual setting. With the simple bilingual configuration, the Columns tab is not visible. In this case, you can deal with the columns at the bottom of the window. For more details, see the Dealing with columns section.

No segmentation in the multilingual setup: If you import the document with the multilingual setting, memoQ doesn't segment the source text. The contents of each cell will be a single source or target segment in memoQ. You can't join segments across multiple cells. But you can split segments that belong to a single cell.

You can tell memoQ to segment the source text in source cells - if there are no translations in the same row. To do this: Check the Segment source text (only if the target cell contains no text) check box. But if an imported row contains translated text, segmentation will not happen. memoQ doesn't know how to segment the translation along with the source. Normally, this is turned off.

If you want memoQ to segment the source text, you have two more options:

• Segment on line break: If you check this, memoQ will start a new segment each time there is a line break in the cell. (This can happen in Excel only.)
• Include manual line break as inline tag: If you check this, memoQ will insert an inline tag for each manual line break in the cell (this is the one you insert in Excel with Alt+Enter).

Under Select base format, click the Excel radio button. Then click the Excel options tab.

On the Excel options tab, you can set the following:

You can import content that is formatted – or not formatted – with specific background colors. You can list the colors in the box under the two radio buttons.

• Do not import if background color is: This is the default setting. While importing the document, memoQ will skip rows where the source cell is formatted with the background you choose.
• Only import if background color is: Click this radio button if you want memoQ to import content that has the background colors you set in the list below the radio button.

  To add colors to the box below the radio buttons:

• Type a color code in the RGB text field, and click Add. The color code is a six-digit hexadecimal number: the first two digits are for blue, the third and fourth for green, and the last two are for red. For example, the code 00FF00 stands for pure green.

• It's easier if you pick the color in Excel. Click the Pick in Excel link. memoQ opens the source document in Excel. (Excel must be installed.) Then the Add colors from file window appears:

  

In Excel, select a range that contains the background colors you want to use. Then click Add colors of selection. The colors appear on the list in the Document import settings window. You can select a new range, and click Add colors of selection again. When there are no more colors to add, click Finish. This closes the Add colors from file window, and Excel, too.

• To remove a color from the list, click the color, and then click Remove.

• To import text from hidden worksheets: Check the Include hidden sheets box.

• To import text from hidden rows: Check the Include hidden rows check box.

• Check the First row contains column names check box if your Excel file has column names in the first row.

Normally, memoQ will not import numbers or formulas from Excel workbooks. However, you can import them:

• To import numbers or formulas in source and target cells, check the Include cells containing formulas or numbers check box.

• The target cells may already contain (different) numbers or formulas. Normally, memoQ will overwrite these by copying the number or formula (or text) from the source cell. If you want to keep the previous formula or number in the target cell, clear the If a target cell was not included check box.

  Formatting in the source cells? To keep extra formatting inside cells, check the Maintain inline formatting in cells check box. memoQ will export the translations (and the source text) with the same formatting as it was imported.

Under Select base format, click the Comma or tab-separated radio button. Then click the Comma or tab-separated options tab.

On the Comma or tab-separated options tab, you can set the following:

1. Choose an encoding: Normally, memoQ detects the encoding (the code page) of the files you are importing. If the encoding cannot be detected, memoQ uses Unicode (UTF-8). To use a different encoding, choose it from the Codepage if not detected drop-down box.

2. If the source encoding is not Unicode, and you're translating into a language with a different writing system (for example, from English into Japanese): You need to choose a different encoding (code page) for the exported translation. Normally, memoQ uses the same encoding to export the translation. To export the translation in a different encoding, choose it from the Export codepage drop-down box.

3. Choose the character that separates the columns: Normally, memoQ uses the Tab character. This is probably the most frequent one. You can choose any other character, though: Use radio buttons to choose other common separator characters like the Comma or the Semicolon. If your file uses a different separator from the three common ones, click the Other radio button, and type the character in the text box to the right.

4. Watch the preview: At the bottom of the window, you can see how memoQ would import your file with the current settings. Check if the characters appear correctly, and if the columns are separated properly. If you are importing several files, memoQ shows the preview from the first one. If it's too small, or not typical enough, choose a different file for preview: Click Load preview from sample file, and choose the file to use for the preview.

Are there double quotes or line breaks in the CSV file? The CSV specification has complicated requirements for handling these characters (see section 2., points 5., 6., and 7 of the linked document). If a CSV file does not meet these requirements, memoQ fixes the issues before exporting. This means the imported and the exported files will be different. Keep this in mind if you are using non-standard CSV files.

Start just like with a truly multilingual file (see above).

To set a column as source text:

1. Select the column in the list.
2. In the Meaning of selected column drop-down box, choose Source text.

If a source cell in a row is empty or contains spaces only, memoQ won't import that cell, its translations, or its contexts or comments.

To set a column as translation in a target language:

1. Select the column in the list.
2. In the Meaning of selected column drop-down box, choose Translation.
3. In the For column drop-down box, choose one of the columns that are already marked as Source text. If there is only one column that has source text, the list will contain that column only. For example, this could tell memoQ that column B has translations for the text in column A.
4. In the Language drop-down box, choose the target language of the column. You can choose any language that memoQ supports. But if the project doesn't have that language, the column won't be imported.

If you don't choose a language: The column will be set to In-place translation. memoQ imports this column as source text, and replaces this source text with the translation.

To set a column as start or end time for the segment:

1. Select the column in the list.
2. In the Meaning of selected column drop-down box, choose Starting timestamp of subtitle or Ending timestamp of subtitle, as needed.

To set a column as length limit:

1. Select the column in the list.
2. In the Meaning of selected column drop-down box, choose Length limit (characters).

3. From the For column drop-down box, choose which column this length limit belongs to. If you choose a target column, memoQ uses the limits for those cells. If you choose the source column (it has "(all translations)" next to it), memoQ uses the limits for all translations.

Choose settings for the memoQ video preview tool

It is important to know how much text you can put on the screen at once. Change the value of the Line length limit (characters) field as needed.

Density means how much text is on the screen over time. You can set limits for Words per minute and Characters per second - the two most common measurements.

No warnings in memoQ itself during translation: when you confirm a segment, memoQ does not warn you if you are over these limits. You see which lines are longer than the limit only when you export the file.
However, the memoQ video preview tool shows all three values in real time when playing the video.

To tell memoQ where to find a video online: Enter the URL into the Base URL for preview text box. If this address is in the Excel file, you can also enter here the cell where it is, for example: E2 or Sheet2!A3.

"Online" means a file on a server: At the moment, streaming video services such as YouTube are not supported.