MemoQ - How to import an entire Excel cell as one segment?
Thread poster: Fabrice Brunon
Fabrice Brunon
Fabrice Brunon  Identity Verified
France
Local time: 17:50
English to French
+ ...
Jan 4, 2020

Hello!

When importing an Excel file for translation into MemoQ (9.2), is it possible to split segments so that one segment = one full Excel cell (several sentences), as opposed to one segment = one sentence?

Thanks!


 
mikhailo
mikhailo
Local time: 19:50
English to Russian
+ ...
re Jan 5, 2020

Fabrice Brunon wrote:

Hello!

When importing an Excel file for translation into MemoQ (9.2), is it possible to split segments so that one segment = one full Excel cell (several sentences), as opposed to one segment = one sentence?

Thanks!


Bad question. You haven't specified separator in cells. If line break — xlsx filter settings checkbox «Import linebreaks as inline tags» (and RTFM)


 
Stepan Konev
Stepan Konev  Identity Verified
Russian Federation
Local time: 19:50
English to Russian
https://helpcenter.memoq.com/hc/en-us/articles/360010377519-Importing-the-content-of-an-Excel-spread Jan 6, 2020

To invoke it, press 'Import With Options...' - locate your file - press 'Change filter & configuration'

 
Lincoln Hui
Lincoln Hui  Identity Verified
Hong Kong
Local time: 00:50
Member
Chinese to English
+ ...
Punctuation Sep 21, 2020

mikhailo wrote:

Fabrice Brunon wrote:

Hello!

When importing an Excel file for translation into MemoQ (9.2), is it possible to split segments so that one segment = one full Excel cell (several sentences), as opposed to one segment = one sentence?

Thanks!


Bad question. You haven't specified separator in cells. If line break — xlsx filter settings checkbox «Import linebreaks as inline tags» (and RTFM)

MemoQ uses punctuation. The "Import linebreaks as inline tags" setting does not work; what the webpage posted above says is a flat-out lie.

The only workaround I've found is to create a new segmentation rule set for Excel files, and put a torch to all the separators in the Advanced View.

[Edited at 2020-09-21 05:07 GMT]


 
Kay-Viktor Stegemann
Kay-Viktor Stegemann
Germany
Local time: 17:50
English to German
In memoriam
Import it as multilingual delimited text file Sep 21, 2020

You can import Excel files as multilingual delimited text files:

Import with Options - choose file type "Multilingual delimited text file" - choose file. In the "document import options" window, make sure that "Filter" says "Multilingual delimited text filter" (in older MemoQ versions, this defaults to a Microsoft Excel filter if you chose an XLS(x) file).
Now, "change filter and configuration" and set the column with the source texts and another column for the target texts.... See more
You can import Excel files as multilingual delimited text files:

Import with Options - choose file type "Multilingual delimited text file" - choose file. In the "document import options" window, make sure that "Filter" says "Multilingual delimited text filter" (in older MemoQ versions, this defaults to a Microsoft Excel filter if you chose an XLS(x) file).
Now, "change filter and configuration" and set the column with the source texts and another column for the target texts.

That should do the trick: one cell, one segment.
Collapse


Andrea Bauer
 
Stepan Konev
Stepan Konev  Identity Verified
Russian Federation
Local time: 19:50
English to Russian
A simpler way Sep 22, 2020

1. Clone the segmentation rules for Excel files
2. Go to the Advanced view
3. Remove all rules


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

MemoQ - How to import an entire Excel cell as one segment?






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »