MemoQ - How to import an entire Excel cell as one segment? Thread poster: Fabrice Brunon
|
|---|
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
Local time: 10:55
English to Russian
+ ...
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 
Russian Federation
Local time: 10:55
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
Hong Kong
Local time: 15:55
Member
Chinese to English
+ ...
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]
| | |
|
|
|
| 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
| | | | Stepan Konev
Russian Federation
Local time: 10:55
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? | Trados Studio 2022 Freelance | The leading translation software used by over 270,000 translators.
Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop
and cloud solution, empowering you to work in the most efficient and cost-effective way.
More info » |
| | Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
