This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
MemoQ - How to import an entire Excel cell as one segment?
Thread poster: Fabrice Brunon
Fabrice Brunon 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!
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
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)
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Stepan Konev Russian Federation Local time: 19:50 English to Russian
To invoke it, press 'Import With Options...' - locate your file - press 'Change filter & configuration'
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Lincoln Hui 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]
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
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
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Stepan Konev 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
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
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.
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