Multilingual Excel Sheets in memoQ (an update)

Click SEE MORE for the time-coded index of contents! Tips on the use of the multilingual delimited text filter and its options applied to a 4-sheet Microsoft Excel workbook.

Table of Contents:

00:10 - Introduction and description of the file
02:17 - Importing (prior to memoQ version 9)
02:35 - Failed import! File is open!
02:57 - Changing the default filter (Excel)
04:04 - Importing the file in memoQ 9 or later
06:52 - Configuring the sheets & columns import
09:37 - Can't differentiate column name setting!
11:30 - Copying column settings for a sheet
12:36 - A warning!
13:00 - Importing and examining the result
13:28 - Locking text not to be translated
14:28 - Exporting and examining the finished translation

[akashimitsumoto]

I was looking for this instruction for ages! I wonder why there is no such concrete and concise tutorial like yours. Much appreciated.

[shiyucai]

Thank you so much for sharing such a detailed tutorial!

[saidbazry]

Thank you very much Kevin. You really help a lot.

[nicholascrenshaw]

A big fan of your channel! Enjoying MemoQ 11 now. It looks like the name of the filter changed to "Multilingual Excel and delimited text filter."
A major issue I deal with is having these kind of files where the client has put massive numbers of line breaks inside of the cells, and there is also target text included. On the Segmentation options, we have the option to segment on line break, but if target text is already included I get the error telling me I have to include manual line breaks as inline tags, which puts an ugly line break tag at the end of every segment, and also messes with my translation memory. Really wishing they could fix that!

[jack]

Is there a way to somehow import each sheet (from one Excel file) as separate documents in memoQ? Like in this example, instead of one memoQ document that contains all 4 sheets, they are instead imported as 4 documents.