MemoQ - How to import an entire Excel cell as one segment?
Thread poster: Fabrice Brunon

Fabrice Brunon  Identity Verified
France
Local time: 23:38
Member (2005)
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
Local time: 01:38
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  Identity Verified
Russian Federation
Local time: 01:38
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  Identity Verified
Hong Kong
Local time: 06:38
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
Germany
Local time: 23:38
Member (2016)
English to German
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  Identity Verified
Russian Federation
Local time: 01:38
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?

Advanced search






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search